Re:Sqlite – Most Deployed Database in the World
by baldfat on Sunday December 23, 2018 @11:03PM
(#18750243)
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.
[ Parent
| on HN ]
Re:Sqlite – Most Deployed Database in the World
by thisgoodlife on Monday December 24, 2018 @01:10AM
(#18750702)
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.
Re:Sqlite – Most Deployed Database in the World
by wenc on Monday December 24, 2018 @12:36AM
(#18750580)
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.
Re:Sqlite – Most Deployed Database in the World
by solarkraft on Monday December 24, 2018 @02:06PM
(#18753689)
> This is by design.
Oh god, why?