How to get the attachment with the Oldest Active Transaction via the Monitoring Tables
OAT and MON$ – How to get the attachment with the Oldest Active Transaction via the Monitoring Tables on Paul Beach’s blog.
Author: mariuz
http://wiki.ubuntu.com/Mariuz
New gbak manual uploaded
Norman Dunbar wrote on Firebird-support :I’ve uploaded the latest gbak manual on account of the firebird-support thread “how to wipe a database“.
Updated gbak manual to mention that -z option will backup your database and overwrite the backup file.
Creating access control into Lazarus + Firebird applications
This is a getting started article (written in Portuguese) from a series of articles related to Firebird and Lazarus
In the first part it’s explained how to install Lazarus and Firebird/Flamerobin on Ubuntu
I have been implementing the access control on my applications. It is a simple model, I have been “improving” since I started the program and always adapting to the new reality that has been presented. Not the last word on programming, but I believe it can be a good start for those who want to implement something from scratch.
pyfirebirdsql 0.3.3: python dbapi for firebird is released
pyfirebirdsql will become the next Firebird Python driver
Philippe Makowski wrote on the firebird-python list
The driver is hosted on github https://github.com/nakagami/pyfirebirdsql
First thanks Hajime Nakagami for your job
I really thinks that we need to put our effort on this driver so it became the Firebird Python driver instead of Kinterbasdb
here few points I saw :
– need a change in setup.py so install work
– transactions parameter we need the possibility to send custom transaction parameter buffers, for what I saw today transactions are (isc_tpb_write, isc_tpb_wait, isc_tpb_read_committed, isc_tpb_rec_version)
– need documentation
– can we extend it or create a new module to work with trace api ?
….
ps after a small change in setup.py I will certainly package it for
Mageia and Fedora
perl-DBD-Firebird rpm package is in #Mageia, first distro with the new Firebird #perl driver
Mageia is a Mandriva Fork and is Perl friendly and become more and more Ruby friendly
Now the perl DBD Firebird driver landed in the Mageia repository
#Oracle vs HP #Unix on #Itanium , and how you can fight back using Firebird on that
Oracle is abandoning HP Itanium customers as usual (like they did with MySQL) and there is a mehod to fight Back : use an open source “oracle like” RDBMS engine : Firebird
Posted by Paul Beach:
For those who are curious, Firebird V2.5 builds just fine on Itanium HPUX (IA-64). See prefix.hpux_aCC and prefix.hpux_ia64 in the builds/posix directory. The only issue we have in providing such builds, is access to the relevant hardware/operating system to do a build, and bringing upto date the HPUX installer.
How to attract more developers to use FirebirdSQL , thread continues
Of course, I couldn’t finish this post without guessing (just guesses) the reasons why Firebird SQL is so unpopular if compared to MySQL or PostgreSQL :
1. There’s no big player like Sun/Oracle or IBM supporting it right now.
ED: Not an issue: there is no need for the big Oracle hug, look what they have done to MySQL, OpenOffice, Hudson , they killed or dumped the projects and only community saved them by forking the source code and continuing under some sort of fundation umbrella: Apache, TDF … . Another article that you must read is by Glyn Moody : Has Oracle been a disaster for Sun’s open source?
2. The official website is terrible (http://www.firebirdsql.org). Seems futile, but the first impression of the project is horrible. Makes you think it’s stalled.
ED:This is fixed , site was reworked , check the new design and compare with the old version from archive.org
3. Firebird’s biggest sponsor today is IBPhoenix , which main business IS Firebird. But even it’s website falls in the same problem.
ED This is fixed , site was reworked , check the new design and compare with the old version from archive.org
4. The fact of being Delphi related since it’s beginning.. With Delphi’s decadence, its popularity just floundered with it.
ED : That is solved we do have support for all the other new players : nodejs, rails , django , lua … And Lazarus apps are still the fastest one in benchmarks vs Java, .net …
5.Poor documentation
ED:Soon to be fixed , but more hands are needed , it’s easy to complain , please help to update and fix the bugs in the docs area
Maybe things may change to Firebird SQL after Oracle bought Sun (many MySQL users are getting scared (I see no reason for this by the way)) and may play with Firebird, but it’s something improbable to happen. 🙂
ED:Wind of change : i get more hits on my blog with things like phpbb3 installations , rails installations … and the traffic for FibirebirdSQL.org and FirebirdNews.org is going up, sourceforge download stats are up , also on the linux distro land and bsd side we are going well : packaged and ready to replace LAMP with FLAPS , firebird php driver is included in default php install on Windows
Of course, these are just my opinions about it. I really whould like to know yours. Why do you think so few developers are using Firebird today?
Firebird main website redesign : testers/proofreaders needed
We need all resources at the current stage of new web-site development.We have beta version now – www.firebirdtest.com, and it requires testing efforts.
The most important thing now is proofreading, so we need English native speakers first.
To report any problem, please create issues at tracker.firebirdsql.org in the Web site section http://tracker.firebirdsql.org/browse/WEB
(issues with wrong section will be not considered).
Please feel free to ask any questions.
Fb Trace Manager v1.5.1 released
Fb Trace Manager v1.5.1 released