'Lite' Databases (Re: sqlite3 and dates)

[Chris Angelico]

On Sat, Feb 21, 2015 at 8:17 AM, Paul Rubin <no.email at nospam.invalid> wrote:
> Ben Finney <ben+python at benfinney.id.au> writes:
>> I don't know of a free-software concurrent RDBMS which can be considered
>> lighter than that. (No, MySQL doesn't count; its concurrency is
>> *unreliable* and it commonly loses data silently. Don't use MySQL.)
>
> I thought they fixed MySQL transactions years ago, with the InnoDB
> engine.  For some reason it's not the default, so you have to turn it on
> explicitly: is there more to it than that?

Even if you use InnoDB for all of _your_ tables, the system catalog
tables will all be MyISAM. So it's possible to lose critical metadata.

ChrisA