Hacker News with Generative AI: Database Management

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 19 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 21 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 35 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 54 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 59 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 62 days ago | 0 comments

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

Database Management, SQLite, Performance

87 points by tosh 97 days ago | 80 comments

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

Postgres, Database Management, SQL, Configuration

9 points by craigkerstiens 134 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 148 days ago | 68 comments

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