I have been configuring a fair number of Linux database servers for a line-of-business application; it runs the Firebird SQL database in server mode only (no application code at all – just DB).
All of these are the wonderful Dell PowerEdge 2950 units with the PERC6i RAID controller, and my typical configuration is 6x 146G 15k SAS drives. These are the highest-performance, highest capacity solution in 3.5″ drives.
I have an app that uses Embedded Firebird for its DB so that I don’t need to
install a DB server. On Vista my app throws an exception “Error trying to
write to file (the correct path here)”.
Now we have 64bit builds of Firebird 2.1 for MacOSX 10.5, we have issues trying to test them properly using the Firebird QMTest QA suite. This QA suite relies on Python and kinterbasdb. Currently Philippe Makowski has been able to run the tests from a 64bit Linux client. But is unable to run the tests locally. Well currently the python framework that comes with MacOSX 10.5 is only 32bit and this forces a 32bit build of kinterbasdb, since the build environment of kinterbasdb uses distutils to use the same compile switches as python. So I thought I would have a look at the issue and see if I could build a 64bit version of kinterbasdb for MacOSX 10.5.
On 2008-02-19 a new version of FreeAdhocUDF is published. The version adhoc20080219 fixes small bugs in 2 functions and comes with 47 new functions. Now there are 408 (four-hundred-and-eight) InterBase/FireBird and Windows/Linux compatible functions in FreeAdhocUDF.
SQL Maestro Group announces the release of AnySQL Maestro – a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc). Key features include database object management, graphical database designer, visual query builder, data export and import, BLOB Viewer/Editor, and a lot of other things.
If you run a site, blog or any other kind of on-line media, you can help to advertise FirebirdNews! Currently, we have a button (see at the sidebar in the MainPage) and from now, we are also offering animated banner that is always up to date with the latest content posted to the site. You can see an example below, and also can get the code to put it in your own sites.
An introductory article about using the new Generic Database Output Module
This modules supports a large number of database systems via libdbi. Libdbi abstracts the database layer and provides drivers for many systems. Drivers are available via the libdbi-drivers project. As of this writing, the following drivers are available: Read more
SQL Server Integration Services (SSIS) – is a comfortable way for developing ETL processes. Integrations Services Projects are well integrated with other development tools of SQL Server 2005 – Analysis Services (SSAS) and Reporting Services (SSRS). Excel workbooks, text and XML files as well as databases with OLE DB Provider realization may be both data sources and data receivers. To work with Firebird и Interbase data в Integration Services you should use OLE DB Source and OLE DB Destination Components. Also you should install IBProvider Professional Edition.