A camp for @database technologists and their frens.
New York, NY
Joined April 2016
- Tweets111
- Following70
- Followers293
- Likes241
ORMs still have a role for migrations, schema declaration, and some higher-level patterns. But for writing & typing queries, the wombo-combo of raw SQL + compiler-integrated inference is the shizzle.
Database Camp retweeted
Database safety is criminally under discussed. The databases are recursively self improving with ACID transactions. Database makers must be regulated
This is a very cool trick, if you don't already know it.
When using psql, append `\gset` to a query, and after execution, it stores each column as a psql variable. Use the variables in the same session.
The column name (or alias) becomes the variable name. Integer and boolean values are referenced with `:varname`. String values need `:'varname'` (the single quotes make them safe to interpolate into SQL literals).
Object storage is great for cheap durable archival, but a poor fit as the commit path for low-latency OLTP (high PUT latency + cost for small writes)
What’s missing is a public, reusable primitive that adds low-latency durable appends (SSD quorum / 1 RTT) & cheap async archival
There is a lot of hype around putting the WAL on object storage.
However, for low-latency systems, e.g. OLTP databases, object storage is a suboptimal primitive for the WAL:
(1) PUTs are expensive for small WAL writes [bytes/$].
(2) Object stores are optimized for throughput, not latency, with write latencies often around 10-50 ms.
Because every transaction must wait for its WAL record to become durable, every transaction inherits that latency.
This points to a missing storage primitive.
In our (@maxikuschewski @melhindiCS @viktor_leis) latest accepted research paper at VLDB, we looked at how to close that gap.
Database Camp retweeted
PostgreSQL 19 wins the AI era 🐘
Not because it’s trendy. Because AI agents need more than a database. They need programmable infra:
→ Database-per-agent
→ Agent-safe permissions
→ MCP + database tools
→ pgvector + hybrid search
→ Ephemeral databases
→ OAuth + workload identity
→ Graph + SQL queries
The AI era doesn’t need another vector database.
It needs one programmable database that can power the entire agent stack.
PostgreSQL is becoming that database.
nitter.gq/alxshp/status/20847096…
PostgreSQL 19 makes INSERTs up to 2× faster 🚀
PG 19 introduces a fast path that can check the referenced unique index directly, avoiding the heavier SPI query path.
Result:
→ Faster foreign-key validation
→ Less overhead per inserted row
→ Up to 2× better INSERT performance with foreign keys
→ Bigger gains during bulk ingestion
Your schema stays the same.
Your constraints stay intact.
The database simply does less work.
Same INSERT. Same integrity. Nearly twice the speed.
nitter.gq/alxshp/status/20829040…
onatm.dev/2026/07/16/homesca… (Assuming the Universe is already invented.) 🍎🥧
Database Camp retweeted
If you are writing complex nested subqueries, you might be better off using CTEs (common table expressions) to improve the readability!
CTE enables you to define a query and treat its output as a new table, allowing you to organize your queries in a hierarchical structure.
Database Camp retweeted
we’re about to release a feature that I think is a big deal for postgres
we created a rust framework to query external databases/warehouses from inside postgres. it’s about to get streaming support :
"The DrizzleORM discourse looks like developers nitpicking edge cases, but Drizzle is winning adoption because its type inference is good enough that AI coding assistants can generate correct code without human supervision."
ctolunchnyc.substack.com/p/c… @DrizzleORM
Inaugural State of Open Source Database Management Report:
try.percona.com/state-of-ope…
Yet another licensing rabbit hole: github.com/liquibase/liquiba… 🐇🕳️
It’s DuckDB release day!
DuckDB v1.4.1 → the first LTS bugfix release
duckdb.org/2025/10/07/announ…
Database Camp retweeted
POV: you're about to find out why senior devs spend weeks/months on database design.
Today I wrote 1000+ lines of code using @prisma . And literally it takes only 3hr to design the database. Now I am exhausted and I think I deserve some goodies
Database Camp retweeted
Supabase allows you to generate embeddings right there within the edge functions.
No external dependencies!
Database Camp retweeted
supabase's MCP server is the 3rd most-used in cursor over the last 4 weeks
nitter.gq/ericzakariasson/status…
Database Camp retweeted
Imagine having database devtools in your browser. 🔥
With @tan_stack 🤝@DrizzleORM you can do just that!