sorted by: recent | see : popular

Content Tagged with Technical + reading

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 [...]

I’ve run some data load tests with various databases using DBMonster, so connecting to databases through JDBC on a WindowsXP personal computer. Here are the results, in both cases I loaded 100 rows in the parent table and 1000 in the child table, with foreign keys enabled.

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

Just a quick sample of integrated windows auth in Firebird 2.1

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.

I having been trying to connect (without success) to a Firebird server from OOo 2.3.[ED:but in the end it was solved by using this guide and it was fast too ]

This week I looked at Firebird2 and decided to give it a try. In a few minutes I discovered that the package libqt4-sql (the one that provides support for accessing databases from Qt4 apps) comes with just a few drivers enabled (coincidentally the ones that I mentioned above). Firebird is NOT enabled by default. Here is [...]

I want to exchange some ideas. I have a class to connect to the database Firebird. All classes that need access to the database is inherited this class. What is the best way to make connection to the database?

http://home.lsces.co.uk/lsces/wiki/index.php?page=FirebirdSQL+Reference Has MySQL updated to 6.0 and PostgreSQL updated to 8.2. Some pages will request a login. That is because we are using private information to provide them and can’t allow access in the public domain.

Following is a PHP script to run nbackup on FB2.1 Put this script in a place where your system can call it automatically/regularly in back-ground

Here is an small guide on installing firebird odbc driver from source (alternate you can install it from binary repository ) A good reference to unixodbc is located here  [See remaining text…]  first step is to  have [...]

After many lunchtimes of testing and documenting, and with a little (!) help from Paul in the Limbo Transactions testing, I have checked in the gfix manual. Onwards to other things now - gpre! Cheers, Norman.

I did a talk on various strategies of how to bridge relational databases and object-oriented programming. In retrospect I should have submitted this as a “double feature” talk, so that I could cover more ground on the actual using of the existing packages in the PHP space. The other talk was on database locking. I think [...]

The 5.0 of CentOS release was done on April 12th. This is an guide on how to install firebird 2.0.1 in CentOS 5.

roxware wrote: Haven’t tried it in MX 7 but in MX 6 you could do the following

This page described the process of installing and running FirebirdSQL on Ubuntu Linux.[ED: it will be added in the firebird wiki soon]

I knew 9 years of IB/FB experience would come in handy. [ED:wordpress firebird conversion in progress] [See remaining text…]  wp-db is the mini database abstraction layer for WordPress. It allows you to run WordPress on various [...]