Technical articles, How-tos, guides, etc.
Posted By Adriano dos Santos Fernandes on his blog:
Here I’m going to explain how Firebird DDL commands works in the architecture, why it stops innovation and how it is supposed to work in Firebird 3.0.
When Dmitry Kuzmenko (IBSurgeon) spoke at FDD a few weeks ago, he shown the results of his recent tests creating a 1 TB (yes, ONE TERABYTE) database with Firebird!
It was really cool to know that FB can handle such beast! A more detailed report about this will be public available in August. Keep checking FirebirdNews!
Hi,
I’ve been working on an improved plug-in for wireshark (previously known as ethereal) and have produced a “Wire Protocol Specification” as a byproduct.
From my preliminary reading of news groups, etc., several people have asked for this kind of information. It’s not complete, it’s not correct but it’s better than anything else I have been able to find.
It should go in your Documentation and Papers section.
Regards,
Mark Chambers
Lorenzo Alberton wrote in his blog about his paper presented at PHP conference
Storing tree structures in a bi-dimensional table has always been problematic. The simplest tree models are usually quite inefficient, while more complex ones aren’t necessarily better. In this talk I briefly go through the most used models (adjacency list, materialized path, nested sets) and introduce some more advanced ones belonging to the nested intervals family
ED: some of the principles can be applied to Firebird with CTE
Adriano has done some tests with the Firebird Protocol behavior in high latency (aka. Internet), and posted the results in his new blog. Worth reading!
Note: If you check the Firebird tracker, you will notice that the most voted feature right now is “improvent of the network protocol”. You can vote there too, to raise the priority even more.
About a month ago there was a question in Firebird (CZ) group how to find whether the user is able to use particular role or to get all roles for user.
As you probably know, a lot of stuff (almost everything) is in system catalog (system tables). The only problem is to figure out what’s the right set of parameters to use. To get all roles with users able to use it, you can use …
Philippe Makowski created a prerelase repositories for OpenSuse and SLE
Choose the repository you need and setup Firebird 2.1.3RC1, Flamerobin and the Python driver
Dmitry Kuzmenko posted in his blog an “interesting” situation detected with the use o gbak + Firebird 1.5 + Local protocol. Read it here.
Question of the day on Firebird odbc driver list
has anyone used JavaScript in PDF-Forms with the ODBC driver?
I can’t retrieve any values from the database.
ps: maybe the driver is not configured OK
