DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
ElastiCache vector search: hybrid search from Lambda

ElastiCache vector search: hybrid search from Lambda

Comments
19 min read
Ten hand-written Room migrations and exportSchema = false: auditing an Android app's database history

Ten hand-written Room migrations and exportSchema = false: auditing an Android app's database history

1
Comments
9 min read
Rent Folio: why our landlord app calculates rent status instead of storing it

Rent Folio: why our landlord app calculates rent status instead of storing it

Comments
4 min read
What Happens When You Build a Database for One Job Only?

What Happens When You Build a Database for One Job Only?

Comments
14 min read
Why We Built a Zero-Backend Habit Tracker Using Local SQLite and Raw CSV Exports Tags: #localfirst, #sqlite, #mobiledev, #privacy

Why We Built a Zero-Backend Habit Tracker Using Local SQLite and Raw CSV Exports Tags: #localfirst, #sqlite, #mobiledev, #privacy

Comments
2 min read
ORA-03113 After the Connection Sat Idle: The Firewall Forgot It

ORA-03113 After the Connection Sat Idle: The Firewall Forgot It

1
Comments 1
11 min read
📝 How to Use SQLite in Python (Without Installing a Database Server)

📝 How to Use SQLite in Python (Without Installing a Database Server)

Comments
2 min read
Duck: DuckDB for Swift. Powerful SQL inside iOS and macOS apps

Duck: DuckDB for Swift. Powerful SQL inside iOS and macOS apps

Comments
13 min read
Tests pass but the agent dropped a column: what a green diff can still contain

Tests pass but the agent dropped a column: what a green diff can still contain

Comments 1
3 min read
notes on learning the streaming side of the warehouse

notes on learning the streaming side of the warehouse

1
Comments
6 min read
Your leaderboard is ranking luck: 3,736 models, 46,284 graded calls, and a split-half correlation of 0.04

Your leaderboard is ranking luck: 3,736 models, 46,284 graded calls, and a split-half correlation of 0.04

Comments
7 min read
Why Your Streaming Pipeline Lies About Latency: Event Time vs. Processing Time

Why Your Streaming Pipeline Lies About Latency: Event Time vs. Processing Time

Comments
6 min read
supa_audit is archived. Here's a maintained audit log for Supabase.

supa_audit is archived. Here's a maintained audit log for Supabase.

Comments
3 min read
Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

Comments
27 min read
My first SQL lesson learned the hard way

My first SQL lesson learned the hard way

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.