Category: Technical Articles
Technical articles, How-tos, guides, etc.
#Jaybird #JDBC cleanup – deprecated org.firebirdsql.pool.sun classes api is removed
More than 1000 lines of deprecated sun api were removed from JDBC driver
The nice side efect is faster tests for JDBC driver
And the best thing is: removing these classes and their tests reduced the execution time of the (pure-java) tests by 20%
Do you want Firebird database to be part of XAMPP?
Please vote on this survey if you agree to Firebird to become more popular in Php/Python world and to be added to the XAMPP package
http://www.apachefriends.org/en/survey-2012.html
Web2Py 2.0.3 is out with support for new #python driver : fdb
New stable version is out and it includes support for the new Firebird driver fdb
Here is how the patch was done also a simple DAL example is attached
Understanding barrier on Linux
It is known that massive write operations in Firebird databases (like updates affecting thousands or millions of records) had become much slower in more recent Linux servers. After investigation, I found this to be related with the fact that most recent distros brings the barrier parameter of the filesystem activated.
Unfortunately, I wasn’t able to solve this “problem” completely, without opening a door for corruption. The slow down when barrier is enabled can be minimized a lot if the database is configured with forced writes OFF, but this also may lead into corruption if something bad happens to the server.
Anyway, the purpose of this post is to share an article that helps to understand how barrier works and why it slow down such kind of operations.
Firebird Django and the Future : FDB pure python driver , Django 1.4.x , Python 3.x support
Maximiliano Robaina wrote on the firebird django group some words and questions about the future of the driver :
My ideas for future organization are:
- Update de google repository with the last django-firebird version with support for django 1.4. It will be the last update in this sense.
- From here, the next oficial repository will be at github
- The version on github will use fdb in place of kinterbasdb
The point 3 is the most important to discuss because it means the total drop of firebird 1.5.x support.
I have added to the group the notes for installing django 1.4.x firebird driver on ubuntu
ps: bonus for using the FDB driver is python 3.x support out of the box , that means we can start testing django 1.5 on python 3.x
Resolving Firebird performance problems (presentation)
Presentation from Firebird Developers Day 2012 is online http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems
We can now say that the libfbclient 3.0 for #Android is running !
How to implement FROM_UNIXTIME() like function in Firebird
Here is the example explained in Spanish :
select dateadd(second, 1255033470, cast(’01/01/1970 00:00:00.0000′ as timestamp)) from rdb$database;