[Lazarus] More explorations with tiOPF

[Graeme Geldenhuys]

Op 2011-03-15 16:05, Andreas Berger het geskryf:
> - SQLite is faster, MUCH faster, absolutely no comparison.

Honest question. Do you actually have some speed comparisons between 
Firebird and other database, including SQLite? I would really like to 
see those please.

> - SQLite is easier to use. It's especially nice to be able to deploy
> your app and easily create the DB at run-time.

We do this too (deployment and run-time creation) with Firebird - no 
problems at all.


> - SQLite is made for SINGLE application access. So my pascal program
> will always read/write the expected types.

The same database application can easily switch between Firebird 
Embedded and Firebird RDBMS - thus you have a great upgrade path to a 
full blown multi-user system, if you application becomes more popular 
and needs to scale upwards.


> - Firebird embedded does not work in virtual machines when the DB is on
> a network mapped drive. I have tested VMWare, Virtual Box and Virtual
 > PC. (This can also be a plus since I use this fact to inhibit one of 
 > my apps to be run from a virtual box.)

I can't comment on this, but I can't see why not, if you for example 
under Windows map the network share to a permanent drive letter. We have 
done this with MS Access (.mdb database) for years. And MS Access is a 
local database only system too. The other point being, if you database 
needs to live on a remote location, why not simply switch to Firebird 
RDBMS server - get the full multi-user treatment for free.


> - SQLite can be embedded without needing to distribute a DLL. (Although
> I no longer use this feature)

... and Firebird Embedded can share it's dll with multiple applications 
on that same system, reducing the byte size of each database application 
on that system. ;-)


> Firebird is a fantastic DB-engine, but has way too much for most of my
> needs.

I'd rather go with too much features (though I don't see why this is a 
problem, just don't use those features), and a database that keeps your 
data (integrity) in check.



PS:
I would honestly like to see the speed comparisons you have with 
Firebird. I have never seen good comparisons, and the ones I have done 
myself, like comparing Firebird to Postgress - using the exact same 
application, Firebird came out tops (by far). But then again, I have no 
tweaking/admin experience with Postgress - I simply compared speed with 
default installs of each RDBMS in question. Apparently Postgress needs 
lots of tweaking before it performs well. :-/


Regards,
   - Graeme -

-- 
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/