1
I'm all-in on server-side SQLite
Ben Johnson has joined Fly.io
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 175 posts.
2
Health insurers just published close to a trillion hospital prices
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
3
Free Postgres databases for small projects
Announcing free Postgres storage on Fly.io.
4
Learn Postgres at the Playground – Postgres compiled to WASM running in browser
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
5
SQLite Internals: Pages and B-trees
Let's open a hex editor and see what this thing is made of
6
PostgreSQL 15
**October 13, 2022** - The PostgreSQL Global Development Group today announced the release of [PostgreSQL 15](https://www.postgresql.org/docs/15/release-15.html), the latest version of …
7
8
LiteFS
We are building a distributed file system for your SQLite databases. Kinda weird, huh?
9
A database for 2022
we moved from etcd to SQLite for a simpler, more scalable database solution. Learn about Litestream, live replication, and lessons learned.
10
I analyzed hospital price lists so you didn't have to
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
11
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
12
SQLite in the browser with WASM/JS
WebAssembly , a.k.a. WASM, is a standard defining a low-level programming language suitable (A) as a target for cross-compilation from many other languages and (B) for running via a virtual machine in a browser. Designed with scriptability via JavaScript in mind, it provides a way to compile C code (among others) to…
13
Zq: An easier and faster alternative to jq
Take an in-depth look at the different computational models of zq and jq.
14
Postgres 15 improves UNIQUE and NULL
Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…
15
The case for JPEG XL
The recent decision by Chrome developers to no longer support JPEG XL has sent a ripple through the developer community and is a bit premature given the relative newness of the image format.
16
How the SQLite virtual machine works
Let's look at how SQLite parses, optimizes, and compiles every query that it receives.
17
EdgeDB 2.0
Today we're excited to announce the release of EdgeDB 2.0, the latest version of our graph-relational database.
18
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).
19
You might not need a CRDT
Cloud infrastructure for teams that develop, train, and serve AI applications at scale.
20
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
21
Friendlier SQL with DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
22
23
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.
24
Postgres Full Text Search vs. the Rest
Comparing one of the most popular Postgres features against alternatives
25
26
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
27
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
28
Scaling our spreadsheet engine from thousands to billions of cells
Causal has joined Lucanet to deliver Extended Planning and Analysis (xP&A) as part of the Lucanet CFO Solution Platform. Make smarter planning decisions with unified real-time insights across financial and operational planning.
29
Tips for a Healthier Postgres Database
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
30
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.