Databases

• ACID - (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps.

Resources

• A future for SQL on the web - sqlite in web, faster than IndexedDB
• PlanetScale – Database for Developers, (HN) - seems like a super cool piece of technology, will definitely keep an eye on it 👍
  • MySQL compatible, serverless, encryption at rest and more
  • pretty generous free tier
  • branching - branch is created from the main database schema, allows changes and can be later merged into main
  • non-blocking schema changes - DB schema can be changed without downtime or locking
• Hosting SQLite databases on Github Pages
• Dragonfly - Redis alternative
• Things You Should Know About Databases - The basic database concepts explained from indexes to ACID properties.
• Presto - distributed sql query engine for big data
• The DynamoDB paper
• Common DB schema change mistakes
• Real-World Engineering Challenges #6: Migrations
• From Postgres to Amazon DynamoDB
• How Discord Stores Trillions of Messages
• Database Fundamentals #databases
• Use the index, Luke! - a guide to database performance for developers
• Postgres Language Server
• Turning the database inside-out
• Build a Database in 3000 Lines with 0 Dependencies
• Databases in 2024: A Year in Review