Hacker News with Generative AI: Database Management

PostgreSQL IDE in VS Code (microsoft.com)
We are excited to announce the public preview of the brand-new PostgreSQL extension for Visual Studio Code (VS Code), designed to simplify PostgreSQL database management and development workflows. With this extension, you can now manage database objects, draft queries with intelligent assistance from context-aware IntelliSense and our ‘@pgsql’ GitHub Copilot agent—all without ever leaving your favorite code editor.

PostgreSQL, Database Management, VS Code, Development Tools, IDE

216 points by Dowwie 2 hours ago | 116 comments

OpenAI: Scaling PostgreSQL to the Next Level (pixelstech.net)
At the PGConf.dev 2025 Global Developer Conference, Bohan Zhang from OpenAI shared OpenAI’s best practices with PostgreSQL, offering a glimpse into the database usage of one of the most prominent unicorn companies.

Database Management, PostgreSQL, AI Companies, OpenAI

158 points by thunderbong 8 hours ago | 103 comments

Pg-Schema-Diff – Diffing Postgres Schemas and Generating SQL Migrations (github.com/stripe)
Computes the diff(erences) between Postgres database schemas and generates the SQL required to get your database schema from point A to B with minimal downtime & locks. This enables you to take your database and migrate it to any desired schema defined in plain DDL.

Database Management, PostgreSQL, SQL, Software Development, DevOps

7 points by cube2222 15 days ago | 0 comments

Another look into PostgreSQL CTE materialization and non-idempotent subqueries (shayon.dev)
A few days ago, I wrote about a surprising planner behavior with CTEs, DELETE, and LIMIT in PostgreSQL, a piece I hastily put together on a bus ride.

PostgreSQL, SQL, Database Management, Performance Optimization

5 points by craigkerstiens 19 days ago | 0 comments

Shardines: SQLite3 Database-per-Tenant with ActiveRecord (julik.nl)
There is a pattern I am very fond of - “one database per tenant” in web applications with multiple, isolated users. Recently, I needed to fix an application I had for a long time where this database-per-tenant multitenancy utterly broke down, because I was doing connection management wrong. Which begat the question: how do you even approach doing it right?

Database Management, Software Development, Web Development, ActiveRecord, SQLite

255 points by julik 26 days ago | 74 comments

Introducting dba: The Autonomous AI Agent for Postgres (tembo.io)
We made an autonomous AI Agent that closes the gap between Postgres monitoring and software engineering. We invite you to join the waitlist to try it out.

Artificial Intelligence, Database Management, PostgreSQL, Software Engineering, Open Source

10 points by samaysharma 66 days ago | 1 comments

Adminer: Database management in a single PHP file (github.com/vrana)

Database Management, PHP, Open Source, Tools

86 points by ustad 67 days ago | 34 comments

Handling Database Failures in a Distributed System with RabbitMQ Workers (ycombinator.com)
I have a worker that processes tasks from RabbitMQ and inserts data into a database. The system operates at high scale, handling thousands of messages per second, which makes proper failure handling crucial to avoid overwhelming the system.

Distributed Systems, RabbitMQ, Database Management, Failure Handling, High Performance

11 points by yakirbitan 78 days ago | 7 comments

Using high bandwidth PCIe 5 SSDs in databases (springer.com)

Database Management, Hardware, Performance

6 points by electricshampo1 110 days ago | 1 comments

Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website) (pgroll.com)

PostgreSQL, Databases, Database Management, DevOps, Zero-Downtime

262 points by todsacerdoti 163 days ago | 52 comments

Migrating billions of records: moving Cloudflare DNS database while it's in use (cloudflare.com)
According to a survey done by W3Techs, as of October 2024, Cloudflare is used as an authoritative DNS provider by 14.5% of all websites.

Cloud Computing, DNS, Database Management, Operations, Technology

5 points by programd 190 days ago | 0 comments

Cash App migrated 400TB of data to PlanetScale's cloud (planetscale.com)
Cash App's move to PlanetScale resulted in streamlined database operations, improved performance, and reduced operational overhead.

Cloud Computing, Database Management, Software, Fintech, Case Study

50 points by mschoening 192 days ago | 14 comments

Migrating billions of records: moving our active DNS database while it's in use (cloudflare.com)
According to a survey done by W3Techs, as of October 2024, Cloudflare is used as an authoritative DNS provider by 14.5% of all websites.

DNS, Cloud Computing, Database Management, Engineering, Networking

16 points by mikece 206 days ago | 0 comments

Nuance: Preventing Schema Migrations from Causing Outages (citystoragesystems.com)
At CloudKitchens, we reviewed all database-related outages over the last few years and found that roughly 80% were caused by schema management issues.

Database Management, Software Development, Cloud Computing

14 points by LaserToy 225 days ago | 1 comments

Compiling and running sqlite3-rsync from a branch (simonwillison.net)
Today I heard about the sqlite3-rsync command, currently available in a branch in the SQLite code repository. It provides a mechanism for efficiently creating or updating a copy of a SQLite database that is running in WAL mode, either locally or via SSH to another server.

Database Management, SQLite

63 points by tosh 230 days ago | 15 comments

Database Migrations in Kubernetes (packagemain.tech)
In the era of microservices and Kubernetes, managing database migrations has become more complex than ever. Traditional methods of running migrations during application startup are no longer sufficient.

Kubernetes, Database Management, Microservices

5 points by arguflow 233 days ago | 0 comments

Many small queries are efficient in SQLite (sqlite.org)

Database Management, SQLite, Performance

87 points by tosh 268 days ago | 80 comments

Postgres Psql: Settings, Presets, Echo, and Saved Queries (crunchydata.com)

Postgres, Database Management, SQL, Configuration

9 points by craigkerstiens 305 days ago | 0 comments

DB Browser for SQLite (Windows, macOS, and Most Versions of Linux) (sqlitebrowser.org)

Database Management, Software, Operating Systems

411 points by punnerud 319 days ago | 68 comments

LedgerStore Supports Trillions of Indexes at Uber (uber.com)