Wanna transaction in MySQL? Ok, pay now, or go to Firebird.

Looks like Oracle decided to charge money for those who wants to use InnoDB with MySQL. InnoDB offers features like transaction control, not found in the “classic” version of MySQL. Read more  here and here.

Need Transactions, Stored Procedures, Triggers, etc. and don’t wanna to pay? GO FIREBIRD!

Update: As pointed by some of our readers, InnoDB is still offered for free in the MySQL “Community” edition.

Default transaction in a #php application

By default, the transactions are IBASE_WAIT, so it waits until the record is no longer edited. You have to start a transaction with the IBASE_NOWAIT option to get an immediate response in a deadlock situation.

One example is a php application waiting for desktop app (administration tool) to finish the transaction

When I try to update a record that’s edited in a desktop app or IBexpert, and there is a deadlock, ibase_execute just hangs, does not return any value nor raises an exception.

Announcement :stable version of Firebird driver for the PHP Codeigniter Framework

Carlos wrote on firebird-php group : I’ve developed a stable version of a Firebird driver for the PHP Codeigniter Framework . Good feedback has been received from the Codeigniter community so far, and hope this could be useful for more developers working with PHP and Firebird.The sources are available at bitbucket here and any issues can be reported here
or at my blog here and for the English readers

Thanx, live long and prosper…
Carlos García Trujillo

ps: seems that the driver is quite popular in such a small timeframe

I am happy that my driver for # firebird # codeigniter already are used by people from around the world in so little time:)

Top 10 Firebird wishlist

Some people doesn’t know, but anyone registered in the Firebird Tracker (registration is open, quick and free) can ask for improvements, report bugs, or vote in some existing tickets to raise their “priority”.

It is true that a high ranked ticket may never be implemented/solved. It is also true that the FB developers are free to implement what they want, without following any specific order or wishes. In fact, a ticket can be left untouched for a long time, if none of the developers feel inclined to work on that issue. But it is also true that having the users community voting for items, may sign to the Core Team developers with a direction to follow.

Here is a list of the top 10 ranked tickets at the moment:

Key Summary Assignee
CORE-2530 Improve even more the FB network protocol Unassigned
CORE-775 True SMP support for SuperServer Dmitry Yemanov
CORE-726 True Boolean Datatype Unassigned
CORE-720 Local temporary tables Vlad Khorsun
CORE-776 Database Links Vlad Khorsun
CORE-657 Database encryption Vlad Khorsun
CORE-733 Compress Data over the Network Unassigned
CORE-749 Object names of at least 64bytes Dmitry Yemanov
CORE-808 UNION, INTERSECT and MINUS support Unassigned
CORE-694 Support timezones with timestamp Unassigned

Note that the top 10 issues are not bugs (the FB Core Team is a very efficient bug killer 😉 ), but enhancements/improvements to Firebird.

It seems that 775 and 657 are expected to be solved in Firebird 3. Core 773 and 2530 are related to the Firebird wire protocol.

Sadly, the top voted item (2530) is still unassigned. If you ever tried to use Firebird over the Internet and felt it is too slow, this is the issue you need to vote 😉 This improvement requires a new wire protocol, and changes to the API that would break the currently third-party access components. So, not easy task, but I hope to see it implemented in the future.

FirebirdDB driver for Codeigniter 2.0 is released Finally!

Here is the announcement on Codeigniter Forums

I have developed a FirebirdDB driver for Codeigniter 2.0
you can get it at BitBucket here

Code Igniter seems to be a cool PHP framework

CodeIgniter is most often noted for its speed when compared to other PHP frameworks. In a critical take on PHP frameworks in general, PHP creator Rasmus Lerdorf spoke at frOSCon in August 2008, noting that he liked CodeIgniter “because it is faster, lighter and the least like a framework”.

#Ruby news : Firebird driver compilable on #rbx (rubinius) and full test passes on Linux (for the classic Ruby VM)

Here is the description of rubinius:

Rubinius is an implementation of the Ruby programming language.
The Rubinius bytecode virtual machine is written in C++, incorporating LLVM to compile bytecode to machine code at runtime. The bytecode compiler and vast majority of the core classes are written in pure Ruby.

Here are the rbx experiments done by Brent Rowland

fb now builds fine but won’t load due to missing rb_ary_freeze and rb_struct_new. #rbx

http://twitter.com/#!/brentrowland/status/27771719659

And yes the Linux tests for classic Ruby VM are all ok

Linux testing of the latest fb code went well. 32- and 64-bit Rubies

1 28 29 30 31 32 84