sorted by: recent | see : popular

Content Tagged with Firebird + Technical

Other than CREATE USER something really valuable has been added, the ability to query other databases.                    

In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.  The only major changes from the last post is that I’ve now upgraded the database engine to the [...]

At the moment (well, for the last two years now) we only use FBLib. The original author is nowhere to be found, so I started maintaining or rather fixing the issues we deteced. For our latest FBLib, you can get a update from tiOPF’s project on SourceForge.net. svn co https://tiopf.svn.sourceforge.net/svnroot/tiopf/3rdParty/FBLib/Trunk FBLib I tagged the original version of FBLib as well, so [...]

If you still have the habit of joining tables in the “where clause”, instead of using explicit join sintax (SQL92), you prabably would like to check this post describing possible wrong result sets due to bad understanding on how it works.

Does someome have any links or documentation for qli.exe? I recently used qli.exe scripts for fixing BD structure corruption as described in http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr , since then and I’ve been searching for information about qli commands or scripts but it seems not to be so much information about it. Near the bottom of this page is a download link for the qli syntax [...]

By Jiri : Well, not so back as you might think, but the incompatibility between Beta 3 and SP1 Beta 1 is gone. I’ve done some new methods etc. so it’s now at least able to work in totally simple cases. In next weeks I’ll try to review all the changes and push the support [...]

Lazarus Ide is now included in Ubuntu Hardy/Intrepid and can be easily be installed and then can work with Firebird

Stack-based buffer overflow in Firebird before 2.0.4, and 2.1.x before 2.1.0 RC1, might allow remote attackers to execute arbitrary code via a long username. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-0467 Security vulnerability in Borland InterBase A security vulnerability discovered early this year in open source database Firebird also affects Borland’s InterBase. The security vulnerability allows …

Here is an howto install jaws php cms on ubuntu with firebird backend

Firebird allows remote connections to the administrative account without verifying credentials. The default configuration of Firebird before 2.0.3.12981.0-r6 on Gentoo Linux sets the ISC_PASSWORD environment variable before starting Firebird, which allows remote attackers to bypass SYSDBA authentication and obtain sensitive database information via an empty password. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-1880

He doubled his performance by just switching the firebird client : We’ve just built and tested ‘libfbclient.so’ from the head branch and tested it against the release version 2.0.3. In other words, we only switched out the client library, and left the database server itself intact at version 2.0.3. The performance improvement is huge: fbclient-head: 6% processing time spent in ‘futex’ fbclient-2.0.3: [...]

Few days/weeks back I had an error in Entity Framework client in FirebirdClient. Today I finally found it and fixed it. While playing with walking across relationships one think suprised me. As you you, when you navige your code thru “entities” in LINQ to SQL the lazy loading works and works in background, you don’t [...]

The 2nd part of the Interbase and Firebird Developer’s manual for ADO .Net has published. It describe code generators and Visual Studio 2005/2008 tools.

This little article shows how to access Firebird databases by using the ZEOS component Library in version 6.1.5 (including Patches 1&2) and how to use these components in database applications. It does not matter if you use the “real” SQL-Server or the embedded version which is restricted to local held databases. A couple of examples [...]

The goal is to make SQLite handle NULLs in a standards-compliant way. But the descriptions in the SQL standards on how to handle NULLs seem ambiguous. It is not clear from the standards documents exactly how NULLs should be handled in all circumstances.

This is a nice article written by Felix Colibri, and includes a diagram showing the relationships among all the system tables.

you will need an apache+php+php5interbase setup (in ubuntu or any distro,or windows) [See remaining text…]  $sudo apt-get install php5-interbase cvs then checkout the latest version in /var/www directory $cd /var/www $cvs -d:pserver:anonymous@ibwebadmin.cvs.sourceforge.net:/cvsroot/ibwebadmin logincvs -z3 $sudo cvs -d:pserver:anonymous@ibwebadmin.cvs.sourceforge.net:/cvsroot/ibwebadmin co -P ibwebadmin $sudo [...]

Pay attention, specially if you are using old IBO versions: Dmitry Yemanov posted in Firebird-Devel list that the OldParameterOrdering setting (found in Firebird.conf) will be removed from Firebird 2.5, and OldColumnNaming will be removed in FB 3.0. Both of them were introduced as temporary solutions to compatibility problems, to give time to developers solve the [...]