-
SQLite is a remarkably good solution to most of these problems, if deployed correctly.
For your main line-of-business database? Of course not. But a deployment of rqlite[0] for your service workers in a read-heavy workload? cuts out a round-trip out of the VM, mocking is trivial, there's a lot to like there.
[0]: https://github.com/rqlite/rqlite
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
>Each tier is either easy to reason about scaling out horizontally except for the database.
Vitess [1], A database clustering system for horizontal scaling of MySQL, or Planetscale [2] which is the SaaS version. Of course everything is good on paper until you run into edge cases. But I am convinced within this decade scaling problem or hassle will be a thing of the past for 95% of us.
[1] https://vitess.io
[2] https://www.planetscale.com
-
embedded-database-spring-test
A library for creating isolated embedded databases for Spring-powered integration tests.
and now as easy as adding `@AutoConfigureEmbeddedDatabase`
https://github.com/zonkyio/embedded-database-spring-test
also helps with having it verify all your database migrations as well