Firebird News

Friday, July 25, 2008

OSCON gets under way - clarion is used with firebird

But this is an open source conference, and Clarion is a closed source product. What exactly is ClarionMag doing here?

In my experience there are are plenty of Clarion developers already using open source products and tools. For the most part that means databases such as MySQL, Firebird, PostgreSQL and Ingres, and web tools, of which there are a great many (Apache and PHP are popular choices).

.:():..:():..:():.

On MySQL forks and MySQL’s non-Open Source documentation

One of the things that sets MySQL apart (in, IMHO, a very bad way) from other Open Source database projects/products such as PostgreSQL (license) and Firebird (license) is that the MySQL documentation is NOT Open Source. The MySQL documentation is and always has been copyright MySQL AB, and “… use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of MySQL AB”.

http://jcole.us/blog/archives/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-documentation/

.:():..:():..:():.

Friday, July 18, 2008

Zeos is Now Ready for FB 2.1.1

Here is the full blog post

The first FB 2.1 version has a problem when attempt first connect to the database but the version 2.1.1 seem already fix that bug, as in the Zeos forum "Seawolf" analyze that "(CORE-1868) The server could crash in isc_dsql_free_statement(). fixed by A. Peshkof" is the problem that make Zeos crash at first connection to the DB. Here is the link to the discussion about this problem in Zeos forum. So if you want to use the Firebird 2.1 version with Zeos then move to Firebird version 2.1.1


.:():..:():..:():.

Firebird - Technical Question

Just starting to migrate our application from an Access backend to Firebird. We have created a firebird database and can connect to it through our app however our SQL statements require objects to be quoted, i.e.

.:():..:():..:():.

Thursday, July 10, 2008

Firebird Embedded use on linux

Here is the guide for firebird 1.5.x on linux , I will try to use the guide on ubuntu and
later with firebird 2.x

also i will try to use it with both c++ and mono
http://tirania.org/blog/archive/2005/Sep-30-2.html
http://www.firebirdfaq.org/Firebird-Embedded-Linux-HOWTO.html#Final_directory_structure

To use Firebird on Linux without needing to add users or set permissions, you can use the Classic server and get it down to just a few files. I used FirebirdCS-1.5.x on SuSE 9.2 but it should work for any Linux distribution and any recent Firebird release. What you need is:

1. A directory to setup a mini Firebird environment. I used ~/firebird and you need these files in the directory:

libfbembed.so
firebird.conf
security.fdb
intl/fbintl
bin/fb_lock_mgr

2. You need to link with or dynamically load the libfbembed.so library. It will allow direct connection to the database without needing a server process.

3. The firebird.conf file just needs one line with "RootDirectory=?" where ? is the full path of the mini Firebird environment directory.

4. The security.fdb file will be used to validate the username and password when you connect so you can either setup users in it or just set the sysdba password to a known value and login using sysdba. This security file is really a dummy file and will not provide any real security but its an embedded database so you are not looking for the same type of security a networked server would need.

5. The files all need to be owned by the user who will be opening the database so in my case they were all owned by me. Special care needs to be taken with the fb_lock_mgr since the one in /opt/firebird/bin is setup owned by firebird.firebird and with the setuid bit turned on but you will not need any of this for this configuration. In general if you're application is running as user "foo" then that user needs to have read/write access to the database you are trying to open, to the security.fdb file, and to the directory you installed the Firebird mini environment.

In your code you need to set the environment variable FIREBIRD to the location of the mini Firebird environment and then you should be able to use isc_attach_database and just pass a full pathname to the database file you want to use.

Here is the original article , but the site seems to be missing
http://web.archive.org/web/20070611151645/http://fbtalk.net/viewtopic.php?id=194
.:():..:():..:():.