'Lite' Databases (Re: sqlite3 and dates)

[Sibylle Koczian]

Am 20.02.2015 um 15:16 schrieb Dennis Lee Bieber:
>
> 	The middle-ground is probably something like the embedded version of
> Firebird (pity there has been no updated book -- "The Firebird Book" came
> out in 2004, v1.5 while 2.5 is current [Whoops, looks like there /is/ an
> update, print-on-demand in three overpriced volumes])
>
The second edition as PDF EBook is part of the IBPhoenix DVD (Developer 
Edition $100). But I can't find out from the website what that DVD 
contains in its current edition. It used to have Firebird itself and 
quite a lot of additional software and documentation.

Firebird embedded has no network access and multi-user capabilities at 
all if I read the documentation correctly 
(http://www.firebirdsql.org/manual/ufb-cs-embedded.html). But "A 
Firebird embedded server DLL can also be used as a network client" to a 
regular Firebird server (from the same page). On the other hand triggers 
and stored procedures should work exactly like the client/server 
versions (and the procedure language is pretty similar to PostgreSQL, so 
migration between these two isn't too difficult).

So this is a middle ground with other pros and cons than SQLite versus 
PostgreSQL.