Sqlrelay – Getting Started Guide With Interbase/Firebird
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux. Here is the Getting Started Guide With Firebird
SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux. Here is the Getting Started Guide With Firebird
Work is in progress toward a ibpp 3.0 codebase which will officially be tweaked for and supporting Firebird 2.0, while bringing new extensions too. You may peek at some very preliminary (and very subject to significant changes) information about the version 3.0.
I’ve been playing with Firebird 2.0 a bit the last couple days. I had played with it in the past (version 1.5) and loved it. Version 2.0 is even better.
abstract of the tutorial : developing database applications, using Turbo Delphi .Net and Interbase [ED: main ideas can be applied to firebird instead of interbase server – just use the FirebirdClient .Article does have very nice graphics with general architecture and that is why i linked to it]
Pabloj wrote in his blog: As per this post on Devshed forums I’m pasting here some sample code (taken from Mike Hillyer’s excellent “Accessing MySQL BLOB columns using Visual Basic 6“), hope it helps.
FirebirdClient v2.1.0 Beta 1, ADO.NET Data Provider for Microsoft .NET
2.0, and mono is available for download.
Hellen wrote on the Firebird-general list:
We have a logo that serves us well, is simple, uncluttered and
distinctive, and looks great on a t-shirt. 🙂
the freshports page is here.
What is a port?
A port is the term used to describe a collection of files which makes it extremely easy to install an application. As it says in the FreeBSD Ports description: Installing an application is as simple as downloading the port, unpacking it and typing make in the port directory.
Query cancelation
Implementation of the statement cancellation feature has been committed into the version 2.1. It works via the monitoring tables – you just need to issue the DELETE command against the MON$STATEMENTS table (there’s no API implementation yet). It could be done by the application itself (using a secondary attachment) or by a server administrator. Examples:
DELETE FROM MON$STATEMENTS
WHERE MON$STATEMENT_ID = ?
or
DELETE FROM MON$STATEMENTS
WHERE MON$ATTACHMENT_ID = ? AND MON$STATEMENT_STATE = 1 -- active
The feature works for both SS and CS engines. The client application receives the GDS error code isc_cancelled.
Trusted authentication on Windows
Ability to authenticate Firebird users through a Windows domain is now available in the source tree and will be included into the v2.1 release. An up-to-date client library is required in order to use this feature. CURRENT_USER represents a logged in Windows domain user in this case. It’s expected that firebird.conf will introduce an option allowing you to choose between native-only, trusted-only and mixed authentication modes.