One of the advantages of Firebird?

[JD]

My main concern is that when I am developing for PostgreSQL or MySQL administrative access is required to set up the database and user management can be somewhat complicated, especially when it is a quick and dirty trial.

For such "quick & dirty trials", you can write a simple interface that you can use to set up the database and manage users.

That is what I've done and with that I find that in the long run, I can even hand over such responsibilities to people that are not database administrators. The interface keeps your database access password hidden from the users but lets them manage users and perform basic database administration such as backup, restore, sweep etc.

JD

[BigChimp]

A bit OT: LibreOffice want to replace HSQLDB with Firebird embedded in their base component:
https://bugs.freedesktop.org/show_bug.cgi?id=51780

... which would make it easier for "normal" people to deal with Firebird DBs

(Of course, when/if this happens is up for grabs, but there is some back-and-forth on the firebird-devel list)

[snorkel]

you know if postgresql is not running you can copy the data files around just like you
can with firebird, it's not a single file but you can just copy them.
You can also use Rsync or something like that, the key is the postmaster has to be stopped.

I wrote a inno setup script that would "embed" postgres into my install, so doing stuff like that
is possible.

[JD]

A bit OT: LibreOffice want to replace HSQLDB with Firebird embedded in their base component:
https://bugs.freedesktop.org/show_bug.cgi?id=51780

... which would make it easier for "normal" people to deal with Firebird DBs

(Of course, when/if this happens is up for grabs, but there is some back-and-forth on the firebird-devel list)

That is wonderful. It reduces the Java dependence little by little. Looking forward to a Java-free LibreOffice.