Op 2011-03-15 15:49, Sven Barth het geskryf:
While the type-safety can potentially lead to problems when non-Pascal systems access the database as well, I wouldn't describe SQLite (btw: only one "L" ;) ) as half-baked. It was a decision of the developers to allow this (although one might argue how they came to such a decision...).
Which such decisions, I'll always call them half-backed. I was trying to find the original MySQL article I was reading the other day that show that HUGE flaw with data integrity, then I came across another website listing about 20 other huge flaws of MySQL. Some where quite ridiculous, like inserting data, but when reading that data back, the values have changed because of overflow issues etc.. Your data has NO guaranteed to be safe in MySQL - probably why it is so popular for toy projects like websites [where data clearly has no great valuable].
As I said, I don't know SQLite, but if they do similar stupid things like MySQL, then they are no good to me either.
Nevertheless SQLite has its usage, because it is so small (to be fair: I don't know the size of the Firebird embedded lib), so it's suited very
Firebird Embedded uses a +-200KB lib (if I remember correctly). That's pretty small, and it can be shared between many apps because it's not compiled into each executable.
Firebird (and it's parent Interbase) has been around for year, is proven technology; has rather big clients like the US Military etc. We have put Firebird though it's paces (like power interruptions, broken network links etc), and the data always came out reliable.
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
