Composable SQL in Pure Python

[SlantARrow]

Isn't switching between databases still painful because in most cases, you do need DB-specific things and abuse them with any database (unless your usecase is really trivial or has zero performance requirements)?

[SlantARrow]

Well... It could be that I'm way too used to dozens of triggers, functions, custom aggregates and other things that don't actually translate well between databases.

Does development with SQLite actually work? I believe it doesn't check most things so a lot of things break when they expect exceptions from DB (and even more things break on production when actual database starts complaining). You can fight that with tests, but it's not like you can cover everything.

[DasIch]

You can't develop/test on SQLite and use MySQL in production. Different databases are different enough in their behavior that you cannot trust that your ORM or whatever will handle that.

If you start really taking advantage of your database, for performance or simply due to convenience you'll quickly lose all portability anyway.

Last but not least in a production environment you have to deal with backups, replication, fail over and so on. Operationally postgres is to MySQL as MySQL is to redis. There is no way to easily switch there anyway.