On: Strict Tables – Column type constraints in SQLite - Draft

[electrum]

The H2 embedded database has compatibility modes for other databases, which seems helpful for testing, but ends up being incompatible in various ways for anything non-trivial. You end up fighting the compatibility and skipping useful native features of the target database, while still not having confidence that the code works on the target database.

We now use the awesome Testcontainers library (available for multiple languages) that makes it easy to launch the real database in a Docker container. Testing applications against multiple databases is now trivial.

[justinclift → electrum]

Thanks, that's interesting and a really useful data point. :)