SQLite over MySQL?

[Bruce Van Allen]

Hey John (or anyone else),

On 2011-06-17, John Delacour wrote:
I'm afraid I can't advise since I can't stand MySQL and find life much easier 
with SQLite.

This aroused my curiosity because I have to switch some Perl 
programs written long ago with various flat-file data tables 
accessed via howe-brew parsing to something more transferable. 
None of my uses has more than a few hundred thousand records, 
and most have far fewer.

Would you care to say a bit more about your preference? Do you 
use the Perl DBI with SQLite? If something that reflects your 
views can be read elsewhere, please point.

CAUTION: I'm not interested in enflaming a huge debate about the 
merits and demerits of these and other database systems, their 
developers, companies that "own" them, etc. Just a bit of 
practical curiosity...

Thanks.


   - Bruce

_bruce__van_allen__santa_cruz_ca_