241
How we upgraded our 4TB Postgres database
Last fall, we migrated our 4TB Postgres database from version 9.6 to version 13 with minimal downtime. Here is how we did it (gotchas included).
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
242
CockroachDB 2.0 Performance Makes Significant Strides
Learn which performance metrics matter, why to demand benchmark TPC-C results under serializable isolation, and how CockroachDB 2.0’s performance compares to 1.1.
243
ClickHouse as an alternative to Elasticsearch for log storage and analysis
In 2018, I've written an article about Clickhouse, this piece of content is still pretty popular across the internet, and even was translated a few times. More than two years have passed since, and the pace of Clickhouse development is not slowing down: 800 merged PRs just during last month!
244
245
Building a distributed time-series database on PostgreSQL
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.
246
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.
247
Announcing the data.gov archive
The Library Innovation Lab is growing knowledge and community by bringing library principles to technological frontiers.
248
A new JSON data type for ClickHouse
We’re excited to introduce our new and significantly enhanced JSON data type, purpose-built to deliver high-performance handling of JSON data. Our core engineer, Pavel Kruglov, dives into how we built this feature on top of ClickHouse's columnar storage.
249
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.
250
SQLite 3.32
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
251
Turbopuffer: Fast search on object storage
Inaugural blog post about the development of turbopuffer, a search engine that uses object storage and SSD caching for cost-effective, low latency search. This post describes into the motivation behind its creation, its unique architecture, and how it significantly reduces costs for large-scale vector searches…
252
253
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.
254
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
255
PostgreSQL Features to Try
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
256
Postmortem of database outage of January 31
Postmortem on the database outage of January 31 2017 with the lessons we learned.
257
258
Litestream VFS
Query your SQLite database any time, anywhere
259
Things we learned running Postgres 13
Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.
260
261
Limbo: A complete rewrite of SQLite in Rust
we forked SQLite with the libSQL project. What would it be like if we just rewrote it?
262
Postgres LISTEN/NOTIFY actually scales
How we optimized Postgres LISTEN/NOTIFY-backed data streams to 60K writes per second on a single Postgres server, with millisecond-scale latency.
263
How to Corrupt a SQLite Database File
An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. The recovery process is fully…
264
265
You might not need a CRDT
Cloud infrastructure for teams that develop, train, and serve AI applications at scale.
266
Graph-Powered Machine Learning at Google
Posted by Sujith Ravi, Staff Research Scientist, Google ResearchRecently, there have been significant advances in Machine Learning that enable comp...
267
268
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…
269
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
270
Publishing with Apache Kafka at The New York Times
This post covers how Apache Kafka and its Streams API are used for storing and processing all the articles ever published by The New York Times