Source: PlanetScale Blog
Transactions are fundamental to how SQL databases work. Trillions of transactions execute every single day, across the thousands of applications that rely on SQL databases.
A transaction is a sequence of actions that we want to perform on a database as a single, atomic…
User Transactions: Escaping Autocommit By default, SQLite runs in autocommit mode. Every non‑SELECT statement is wrapped in its own transaction: !Autocommit tr...
Overview This chapter from Designing Data‑Intensive Applications explores different database models and strategies for structuring application data. Understand...
Today’s Quiet but Important SQL Day No new tables. No fancy joins. Just learning how to ask better questions of the data I already have. The lesson was all abo...
Shape of the Data, and How It Changes Relational shines when: - Relationships are complex and matter e.g., orders, customers, invoices. - Queries need joins, g...
