A faster way to copy SQLite databases between computers
I store a lot of data in SQLite databases on remote servers, and I often want to copy them to my local machine for analysis or backup.
weeklyfoo #83 / 2025-05-05sqlitedatabases
📰 databases
A Gentle Introduction to Using a Vector Database
In which we learn how to build a simple vector database using Pinecone and OpenAI embeddings, and discover it was way easier than we might have expected.
weeklyfoo #67 / 2025-01-13databases
Analyzing Database Trends Through 1.8 Million Hacker News Headlines
I used camelAI with a ClickHouse database of every HN story to do all analysis. You can use it for free with no login here to explore the data interactively yourself.
weeklyfoo #94 / 2025-07-21aidatabases
Announcing Multigres
Build a Database in 3000 Lines with 0 Dependencies
Database Fundamentals
Gotchas with SQLite in Production
Read the seven gotchas if you’re thinking about using sqlite.
weeklyfoo #42 / 2024-07-22sqlitedatabases
How I Dropped the Production Database on a Friday Night
The case for moving fast and breaking things (before your competitors kill you)
weeklyfoo #90 / 2025-06-23databasesincidents
Introducing Netflix’s Key-Value Data Abstraction Layer
Migrating billions of records
Moving our active DNS database while it’s in use
weeklyfoo #57 / 2024-11-04cloudflaredatabasesmigration
The future of Postgres?
Things I Wished More Developers Knew About Databases
What I Wish Someone Told Me About Postgres
Why I Always Use PostgreSQL Functions For Everything
I’m tending between (1) I should consider this, and (2) there’s a reason not to overuse database functions.
weeklyfoo #48 / 2024-09-02databases