1
Postgres IDE in VS Code
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL...
2
The DuckDB Local UI
The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.
3
Working on databases from prison
How Preston Thorpe went from a prison cell and a college program to a full-time database engineering role at Turso, working on the SQLite rewrite in Rust.
4
Supabase MCP can leak your entire SQL database
Indirect prompt injection through support-ticket data lets an MCP-enabled assistant cross trust boundaries and query private tables with Supabase’s privileged service role.
5
Stop syncing everything
Discover Graft, an open-source transactional storage engine built to solve the challenges of syncing data at the edge. Inspired by lessons from SQLSync, Graft enables lazy, partial, and strongly consistent replication—allowing edge applications to sync only the data they need, exactly when they need it.
6
Backblaze Drive Stats for 2024
The 2024 Year End Drive Stats Report is here. See the the latest annualized failure rates and data insights for the Backblaze drive fleet.
7
Jepsen: Amazon RDS for PostgreSQL 17.4
AWS’s Sergey Melnik, along with HN commenters matashii and Ants Aasma, have identified the cause of Long Fork in PostgreSQL clusters. As described a 2013 mailing list post , the order in which a PostgreSQL primary makes transactions visible is determined by an in-memory lock. Secondaries, however, make transactions…
8
9
How we decreased GitLab repo backup times from 48 hours to 41 minutes
Learn how we tracked a performance bottleneck to a 15-year-old Git function and fixed it, leading to enhanced efficiency that supports more robust backup strategies and can reduce risk.
10
The Anthropic Economic Index
Announcement of the new Anthropic Economic Index and description of the new data on AI use in occupations
11
Postgres LISTEN/NOTIFY does not scale
Learn why Postgres LISTEN/NOTIFY doesn't scale for high-throughput use cases and what architectural alternatives Recall.ai uses in production.
12
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O
Postgres 18 introduces Asynchronous I/O (AIO) that can dramatically improve read performance, especially in the cloud. Learn how these changes and the new io_method setting work and see why our benchmark results show that io_uring is the recommended setting for maximizing I/O performance in Postgres 18 over the…
13
Kafka is Fast – I'll use Postgres
Why you should just use Postgres instead of Kafka for small-scale message queuing and pub-sub patterns. Benchmarks and practical tests included.
14
Getting AI to write good SQL
Learn about text-to-SQL techniques like context building and table retrieval, LLM-as-a-judge, and LLM prompting and post-processing.
15
Advent of Code 2024 in pure SQL
A blog by and for database architects.
16
Litestream: Revamped
Bringing in what we learned from LiteFS
17
Jepsen: NATS 2.12.1
NATS is a popular streaming system. Producers publish messages to streams , and consumers subscribe to those streams, fetching messages from them. Regular NATS streams are allowed to drop messages. However, NATS has a subsystem called JetStream , which uses the Raft consensus algorithm to replicate data among nodes…
18
Litestream v0.5.0
Same Litestream goodness but better, faster, stronger
19
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)
Boost PostgreSQL full-text search speed by 50x with simple optimizations. Use VectorChord-BM25 to accelerate and better BM25 ranking in postgres.
20
OrioleDB Patent: now freely available to the Postgres community
Supabase is explicitly making available a non-exclusive license of the OrioleDB patent to all OrioleDB users in accordance with the OrioleDB license.
21
Personal data storage is an idea whose time has come
Data Ownership as a conversation changes when data resides primarily with people-governed institutions rather than corporations.
22
23
Databricks acquires Neon
Databricks agrees to acquire Neon, a serverless Postgres database company, to bring speed and flexibility to production workloads.
24
SQLite concurrency and why you should care about it
SQLite is a powerful database engine, but due to its design, it has limitations that should not be overlooked.
25
Announcing the data.gov archive
The Library Innovation Lab is growing knowledge and community by bringing library principles to technological frontiers.
26
SQLite JSON at full index speed using generated columns
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.
27
Postgres Just Cracked the Top Fastest Databases for Analytics
Databricks offers a unified platform for data, analytics and AI. Build better AI with a data-centric approach. Simplify ETL, data warehousing, governance and AI on the Data + AI Platform.
28
Instant SQL for results as you type in DuckDB UI
Type, see, tweak, repeat! Instant SQL is now in Preview in MotherDuck and the DuckDB Local UI. Bend reality with SQL superpowers to get real-time query results as you type. | Reading time: 8 min read
29
Litestream VFS
Query your SQLite database any time, anywhere
30
SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale
Learn why SQLite-on-the-server fits hyper-scale systems when each tenant gets an isolated database with local reads, durable storage, and simple…