News for hackers. Stuff that matters.
Re:Migrating Facebook to MySQL 8.0 by astrange on Thursday July 22, 2021 @06:22PM (#27925076)
That would be an ORM or something similar, I think. It's not realistic unless you're always testing with two databases from the start, because their implementation details leak through.

It can be useful if your program is simple enough to work with both MySQL and SQLite, but often you should just stick with one DB and get to use all its features.

Re:Migrating Facebook to MySQL 8.0 by davecanderson on Friday July 23, 2021 @04:33AM (#27928510)
[ServiceStack OrmLite][1] does just that, all our development is done locally using SQLite but then deployments use MySQL. We do fall into the 'program is simple enough' category though.

[1]: https://github.com/ServiceStack/ServiceStack.OrmLite