On: Sqlite – Most Deployed Database in the World

[baldfat]

I love sqlite. It is far to under used. It scales incredibly well and if you out grow you can easily move it into a different dB system.

[thisgoodlife → baldfat]

No. In reality, it's incredibly hard to migrate any database to another database. Even if you have high test coverage, there can be some corner cases bite you later. Hack, simply a version upgrade can have all kinds of problems.

[wenc → baldfat]

There is a way that it does not. It is flexibly typed so you can insert a string into an integer column. This is by design.

This also means you’ll run into trouble when you try to move it to most SQL databases which are strongly typed.

[solarkraft → wenc]

> This is by design.

Oh god, why?