Firebird embedded – Linux (update)

In this post I explained how to set up an embedded Firebird version for Linux.A few weeks ago I read a post from Olivier Mascia that explained a simpler way: instead of starting the program using a script that sets up a couple of environment variables, just callsetenv() to set those variables in the program.

There are many good articles in the archives about firebird and creating an accounting program with open source tools.

First tests in the Amazon’s free Elastic Cloud 2

I have installed from source Firebird 2.5 in the new free (for one year only) micro instances from Amazon
But you can install firebird from tar.gz or rpm (seems that basic linux installed there is based on Centos) after that the sky is the limit : django , ruby , php or why not extjs pascal web servers
Don’t forget about the replication and backups 😉 This seems to be better than google GAE or microsoft hosting: no limits on number of database or number of queries
ps:you can connect securely to firebird by creating a ssh tunnel

Can Firebird gain against MySQL?

From Marco Cantu’s blog:

Now, this could be a very good opportunity for all of the other open source database servers (and also some of paid ones!), particularly the most popular ones like Firebird and PostgreSQL. I’m particularly fond of Firebird (the InterBase offspring) and use it in many projects and did a lot of consulting to Delphi developers using it. Can this be the rise of Firebird? MySQL with its huge popularity has certainly obscured it, so it could be a good time to act.

Morfik 3 released – now free to everyone

Morfik is used to easily develop rich Internet applications that can be run also in devices, like the iPhone. They just released the version 3 of the product, with some interesting news:

NO MORE PAY TO PLAY

With this release, we have changed the game, significantly. Now you don’t have to pay to play the game! That’s right,  Morfik 3 AppsBuilder is no longer licensed. It is accessible to everyone – at no cost.

Download Morfik 3 now!

There is no catch. We are serious about enabling developers to take full advantage of the power of the Web. This is about making it as easy as possible for all to discover, use and be successful with Morfik. We want to build the community of active users, which will ultimately help you get the most out of your Morfik development environment.

I remember Morfik having a “free” version in the past, and after some time, they changed their minds and started to offer only paid/licensed versions. I hope this time they are serious about the “there is no catch” thing.

Morfik uses Firebird as its default database.

Migrating users from FB 2.1 to FB 2.5

People moving to FB 2.5.0 may be asking if it is safe to copy the security2.fdb file from previous versions of Firebird to Firebird 2.5, keeping the users previously created, so avoiding to recreate them.

In theory, copying the file should work, but with no guarantees. Firebird 2.5 uses a new ODS (11.2). You can do a backup/restore in FB 2.5 to update the ODS of security2.fdb, but some problems will still persists, regarding the use of the new role RDB$ADMIN (which gives SYSDBA rights to “normal” users) – in this case, normal users who were granted RDB$ADMIN role, will have problems to use the new SQL commands CREATE/ALTER/DROP USER. Note: Firebird 2.5.1 will bring a sql script to fix this problem.

So, the safest way to move users to FB 2.5 right now, is to recreate them in Firebird 2.5, either using gsec.exe or the new CREATE USER statement.

Thanks to Dmitry Yemanov for detailed information about the problem.

1 27 28 29 30 31 84