Tag: database

To simulate a business

Put the business in a box, then shake it

Content-addressed extension points

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

-

-

-

-

-

CRDT

-

-

-

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.

-

-

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.

Moving beyond fork() + exec()

-

-

-

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.

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.

How do you handle transactions with the repository pattern?

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

Do you need a repository layer on top of sqlc?

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

On newly created database schemas

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

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...

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...

Decision Tree: DyanamoDB vs Aurora PostgreSQL

Which one should you pick

Peter Pistorius - Redwood SDK

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

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.

Stepan Parunashvili - InstantDB

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

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.

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

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.

Predrag Gruevski - Trustfall, Cargo Semver Checks, and the Future of Query-Based Tools

Predrag Gruevski explores Trustfall, a revolutionary query tool that turns anything into queryable data, and cargo-semver-checks for Rust semantic versioning.

Multi-instance PocketBase setup

I’ve been playing around with Hetzner Cloud for a while now, mainly setting up this site on it using Coolify but it got me thinking about using it for other things too. I’ve used PocketBase before for other projects and documented it for use with...

Seed your Supabase database with this simple pattern

Learn how to seed your Supabase database with this simple pattern.

Seed your Supabase database with this simple pattern

Learn how to seed your Supabase database with this simple pattern.

Sabin Adams - Prisma

Developer advocate Sabin Adams dives into Prisma's type-safe ORM magic, exploring schema power, Prisma Accelerate, and the future of database tooling.

Sorting a Django queryset by a custom sequence of an attribute

Sort Django querysets by custom attribute sequences using Case and When expressions for database-level ordering with SQL CASE statements.

Switching between multiple data streams in a single thread

Poll multiple data sources in a single thread using Python generators with itertools.cycle to alternate between infinite data streams efficiently.

Manipulating text with query expressions in Django

Use Django query expressions like Replace, Upper, Lower, Concat, and Substr for efficient database-level text manipulation without fetching data.

Faster bulk_update in Django

Accelerate Django bulk_update operations by 4x using multiprocessing to parallelize database writes across chunked record batches.

Using a Private RDS Instance with Lambda in AWS CDK

How to build a private RDS database and connect to it with an AWS Lambda function using AWS CDK.

Set up a free PocketBase database with Fly.io

I was playing around with Linode recently to try set up a PocketBase instance then I came across this guide on the PocketBase GitHub discussions. The whole thing took around ten minutes and I now have a SQLite database I can read/write to.

Recipes from Python SQLite docs

Practical SQLite recipes for Python: execute statements, batch operations, transactions, row factories, and context managers with sqlite3.

Pick random values from an array in SQL(ite)

Emulate Python's random.choice in SQLite using JSON arrays and the random() function. Populate tables with realistic test data efficiently.

Bulk operations in Django with process pool

Speed up Django bulk operations with ProcessPoolExecutor while preserving signals and hooks that bulk_create/bulk_update bypass.

Automate database backups with AWS Fargate, S3 and CDK

I love how Serverless enables simple solutions to common DevOps tasks: in this article I describe one simple way to automate MongoDB database backups using AWS Fargate, S3, and CDK.

本番DBの複製を Docker を用いてローカルに爆速で構築したい

手元に 本番環境のデータベースと同等のもの が欲しくなるとき、ありますよね？ そんなとき、以下のようなことしちゃってませんか？ 本番環境がすでにあって、それを直接触って修正しちゃってる 良くないと思いつつも、トラブルが起きてから本番環境へ直接対処しちゃってる だいぶ構成が異なるけど XAMPP / MAMP あたりを雑に使ってて、いざ本番に持って行ったらうまく動かない などなど・・・ 本番環境においてトラブルを極力減らすためにも、 手元に本番環境と同等の環境を作るのは超大事 だと思います。 手元にデータベースを用意して、快適に開発 or 制作していきましょう！ 実はコンテナベースですぐ作れる 実は、 コンテナベース（Docker）でさくっと作れる んですよね。 ですが意外と知らない人も多く、情報もそこまでまとまってないように感じたので、 改めてまとめ直してみようと思います。 ちなみに Docker に関しては、 めっちゃ頑張って書いた分かりやすい（と自分では思っている・・・）記事があるんですけど、 あんまり読んでもらえてないみたいでちょっと寂しさ・・・。 Docker 知らない人は読むといいですよ。 Docker 再入門2018 - コンテナ編 Docker 再入門2018 - コマンド編 Docker 再入門2018 - エコシステム編 Docker 再入門2018 - 実践編 以下の手順で進めていきます。 下準備 MySQL で空のデータベースコンテナを作る MySQL で空のデータベースコンテナにアクセスしてみる PostgreSQL でコンテナ作ったりアクセスしてみたり 管理しやすさのため、 Docker Compose でコマンドを書き換える 初期データの用意をする（本番環境から持ってくる） 初期データを投入してみる 上の Docker 記事で触れたような内容も一部重複して出てくるかもしれませんが、 この記事だけさらっと読んでできるようにまとめておきたいと思います。

Renaming Database Constraints with Liquibase