sorted by: recent | see :
popular
Content Tagged with reading + Articles
Another great new feature of Firebird 2.5
Other than CREATE USER something really valuable has been added, the ability to query other databases.
Firebird SuperClassic - Another option
Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.
Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.
Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for [...]
Apache, PHP and Firebird Performance Tuning
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 [...]
Firebird qli.exe scripts documentation
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 [...]
Anything Else
Git-SVN: Whys And Hows
COBOL language in Firebird SQL Pre-processor is now enabled on debian/ubuntu
This feature was requested on ubuntu bug tracker and now fix is released in firebird2.0 for Ubuntu Intrepid Ibex
https://bugs.edge.launchpad.net/ubuntu/+source/firebird2.0/2.0.3.12981.ds1-16
and in firebird2.1/firebird.2.0 for debian
http://packages.qa.debian.org/f/firebird2.1/news/20080523T050204Z.html
Firebird Experts Forum - fastest forum i have ever seen is powered by firebird
The forum here is created using the phpBB Software, available on http://www.phpbb.com. It is a great and free Open Source Solution and since version 3, it has full support for firebird. This installation uses apache 2.0, phpBB 3.01, php 5.21 and firebird 2.1 on windows 2003 server.
If you never installed a WAFP Server (WIndows+Apache+Firebird+PHP) on [...]
Data load speed test , Mysql vs Firebird
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.
remember to upgrade to firebird 2.0.4 or firebird2.1
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 …
Firebird security bug fixed in gentoo linux
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
Performance improvement by using firebird client from cvs head
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: [...]
reading
firebird
performance
news
developer
Articles
Technical
Integrated auth in Firebird 2.1
Just a quick sample of integrated windows auth in Firebird 2.1
Get to know FB in 2 minutes - Updated!
With the recent release of Firebird 2.1 final, it is time to update the “Get to know Firebird in 2 minutes” paper. English (PDF/HTML) and Brazilian Portuguese is already up to date (revision 1.2). You can help translating/updating the document to other languages.
[Upd] German, French and Czech versions are now updated too.
NULL Handling in SQLite Versus Other Database Engines
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.
New Firebird packages fix several vulnerabilities in debian
This Debian security advisory is a bit unusual. While it’s normally
our strict policy to backport security bugfixes to older releases, this
turned out to be infeasible for Firebird 1.5 due to large infrastructural
changes necessary to fix these issues. As a consequence security support
for Firebird 1.5 is hereby discontinued, leaving two options to
administrators running a Firebird database:
I. [...]
Firebird JDBC and OOo 2.3
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 ]
OpenOffice
reading
firebird
Articles
Technical
Worth
jaybird
HowTo Install Firebird 2.0.3 Database Server On Ubuntu 7.10
This tutorial explains how you can install the Firebird database server (version 2.0.3) on an Ubuntu 7.10 server.
Qt4 + Firebird - problem solved in ubuntu
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 [...]
Firebird .NET provider and calling sp with parameters
Firebird .NET provider has ability to create parameterized queries. Both named and unnamed parameters are supported. Everything works as you expect with select, insert, delete or update commands. The tricky part comes with stored procedures. Unlike MS SQL, that has direct support for named parameters, in provider, we’re parsing parameter names and we’re sending it [...]
Best way to open an database in qt(c++classes)
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?
What is SchemaProber?
The main purpose of SchemaProber is to provide a lightweight representation of a database schema. It doesn’t do anything except relay information from the database. Here’s the class diagramVariationen von http://www.pokerneu.de. for SchemaProber
FirebirdSQL Reference - up again
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.
The Compete Guide to ODBC Escape Sequences in Firebird and Interbase (with ibprovider)
ODBC Escape sequences has included in ODBC standard and allows write SQL queries which compatible with many DBMS. Firebird and Interbase does not contains own implementation for escape sequences and therefore we have implemented them in IBProvider and now users can write compatible SQL queries for Firebird and Interbase as for MS SQL Server, Oracle, [...]
nbackup+php = script for backing firebird from the web or cron job
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
Secure PHP+Firebird installation on unix/linux systems
With the growing concerns regarding comment SPAM, XSS attacks, security breaches, etc, we should spend some time learning how to defend ourselves against such threats.etc. So, let’s focus on securing our PHP server, thus barring most of the attacks from the start.
http://www.alberton.info/secure_php_installation.html
howto install firebird odbc driver for unixodbc (from source )
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 [...]
Firebird and .net provider membership
Joe Wirtley started working on a project with the Firebird database server and .net provider
Gfix manual added to the firebird-docs repository
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.
Visual Studio 2005 - Management Databinding in Firebird
Luciano Bastianello wrote :”This article Spurred from the demand for a friend who invited to me to try to me with the databinding on the database Firebird ”
You can read the google translation here
Talk on database locking and relational - oo bridge
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 [...]
La gestion des transactions dans Firebird
you can read the article translated here
La gestion des transactions dans Firebird
Présentation du concept de transaction et du modèle transactionnel de Firebird, comparaison par rapport à d’autres SGBD. Avantages et inconvénients, bonnes pratiques de conception et de programmation.
Via http://firebird-fr.eu.org/doku.php?id=wiki:rendez-vous2007
Links for Web Designers - April
Tons of awesome current design resources.
Setting up Firebird 2.0.1 in CentOS-5.0
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.
Interesting thread on realbasic forum
An good thread to read on realbasic forum (hey is Friday and is related to firebird advantages)
Page 1 | Next >>