Skip to content

Standard Reader

Tag

Database

Articles and publications tagged Database across the Atmosphere.

52articles20publications

Articles

Publications

Redowan's Reflections

Redowan's ReflectionsAug 19, 2026

Postgres as an isolation reference model

Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.

Redowan's Reflections

Redowan's ReflectionsAug 19, 2026

A return to Postgres isolation

Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.

AutotelicAug 8, 2026

To simulate a business

Put the business in a box, then shake it

databasesimulate

AutotelicAug 6, 2026

Content-addressed extension points

could code live with the data, without residing with the data?

Today I LearnedJul 17, 2026

Redowan's Reflections

Redowan's ReflectionsJun 13, 2026

Reading your own writes with WAIT FOR LSN in Postgres 19

PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.

Redowan's Reflections

Redowan's ReflectionsJun 13, 2026

Reading your own writes with WAIT FOR LSN in Postgres 19

PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.

John Beales

John BealesJun 9, 2026

I'm migrating analytics to a new database structure for 4RoadService, it looks like this will take a few days. This should enable faster, better, and more accurate reporting for our customers.

analyticsdatabase

John Beales

John BealesMay 27, 2026

I am now a member of the "Claude code deleted something that it shouldn't have from my database" club! Good thing it was a development database.

agentic developmentai

Ryosuke's Sketchbook

Ryosuke's SketchbookMar 23, 2026

Free Auth and DB using AT Proto

Redowan's Reflections

Redowan's ReflectionsMar 21, 2026

Repositories, transactions, and unit of work in Go

Decoupling business logic from storage in Go, adding transaction support without leaking SQL details, and coordinating atomic writes across multiple repositories using a unit of work.

Redowan's Reflections

Redowan's ReflectionsMar 20, 2026

How do you handle transactions with the repository pattern?

Adding transaction support to a repository interface without leaking storage details.

Redowan's Reflections

Redowan's ReflectionsMar 16, 2026

Do you need a repository layer on top of sqlc?

Decoupling business logic from storage with a small interface in Go.

LedgerMar 12, 2026

On newly created database schemas

If you've just created new schemas and have multiple user roles, make sure to execute these commands.

databasePostgreSQL

Scott Spence

Scott SpenceOct 6, 2025

SQLite Corruption with fs.copyFile() in WAL Mode

I was looking up something on my site for reference (as I usually do when trying to recall a detail) when I noticed the popular posts in the footer weren’t displaying. That’s odd. I’d been working with the database locally recently, so my immediate...

Scott Spence

Scott SpenceJul 13, 2025

Hunting Down 1.3 Billion Row Database Reads

I spent some time this weekend rolling the auth credentials for this site (again) after Claude Code doxed my variables! Anyways, whilst I was doing this I noticed my Turso dashboard had 1.3 BILLION row reads. My database was getting absolutely...

ander.shJun 2, 2025

Reading list week 22

The articles and other content I have found interesting this week, and would recommend you check out!

reading-listdatabase

luminary.blogJun 1, 2025

Decision Tree: DyanamoDB vs Aurora PostgreSQL

Which one should you pick

comparisondatabase

Devtools FM

Devtools FMJun 1, 2025

Peter Pistorius - Redwood SDK

Peter Pistorius discusses Redwood's evolution into a serverless React Server Components framework and his vision for personal software development.

redwoodopen source

subaud

subaudMay 30, 2025

Using psycopg2 with AWS Lambda and CDK: Binary vs Source Solutions

Getting psycopg2 to work in AWS Lambda can be frustrating. This post shows you two reliable solutions - using pre-compiled binaries for simplicity, and building from source with Docker for production workloads.

Devtools FM

Devtools FMMay 25, 2025

Stepan Parunashvili - InstantDB

Stepan Parunashvili unveils InstantDB, a modern Firebase replacement designed to make building local-first applications easier and more powerful.

InstantDBDatabase

subaud

subaudApr 5, 2025

Updating Athena Queries for Enhanced Blog Traffic Analysis

Expanding on our CloudFront log analysis with new Athena queries to differentiate bots vs humans, analyze external referrers, and get detailed bot traffic insights.

subaud

subaudApr 4, 2025

Deep Dive: Building 'alphabetizi.ng'

Exploring the architecture and interesting features of a serverless survey application built with AWS CDK, React, DynamoDB, and Lambda@Edge

Redowan's Reflections

Redowan's ReflectionsJan 12, 2025

Hierarchical rate limiting with Redis sorted sets

Build multi-level rate limiting with Redis sorted sets and Lua. Enforce global and category-specific limits with ZREMRANGEBYSCORE and ZCARD commands.