[Lazarus] More explorations with tiOPF

[Graeme Geldenhuys]

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/