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/
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
