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. 300 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
Goodbye, data science
This is more of a personal post than something intended to be profound. If you are looking for a point, you will not find one here. Frankly I am not even sure who the target audience is for this (p…
5
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.
6
One-liner for running queries against CSV files with SQLite
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
7
Things to know about databases
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
8
Just use Postgres for everything
Replace Redis, MongoDB, Kafka & more with PostgreSQL. Reduce complexity, boost development speed. Complete guide with real examples.
9
SQLite Internals: Pages and B-trees
Let's open a hex editor and see what this thing is made of
10
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 …
11
Soft deletion probably isn't worth it
The traditional soft deletion pattern using <code>deleted_at</code> columns leaks into code, curbs the usefulness of foreign keys, and makes data removal difficult. Luckily, there’s an alternative.
12
13
LiteFS
We are building a distributed file system for your SQLite databases. Kinda weird, huh?
14
In MySQL, use “utf8mb4” instead of “utf8” (2016)
Today’s bug: I tried to store a UTF-8 string in a MariaDB “utf8”-encoded database, and Rails raised a bizarre error:
15
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.
16
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.
17
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
18
I found a bug in SQLite
rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I introduced a high-performance write-path into rqlite and, to my great surprise, it exposed a bug in SQLite. The SQLite team quickly addressed the issue but let's take a look at the…
19
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…
20
I put my whole life into a single database
Back in 2019, I started collecting all kinds of metrics about my life. Every single day for the last 2.5 years I tracked over 100 different data types - ranging from fitness & nutrition to social life, computer usage and weather.
21
22
Zq: An easier and faster alternative to jq
Take an in-depth look at the different computational models of zq and jq.
23
Make the “semantic web” web 3.0 again – with the help of SQLite
Before the term was hijacked by crypto-grifters (and, admittedly, a few genuinely neat projects), web 3 (point oh) referred to Tim Berners-Lee's project to promote a standard way to expose and parse metadata on the web. It never took off. In this piece, I'll argue that a breakthrough idea introduced last year by HN…
24
Redis explained
A deep technical dive into all things Redis. Covering various Redis topologies, data persistence and process forking.
25
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…
26
The 12-bit rainbow palette
A palette of twelve colours chosen with consideration for how we perceive luminance, chroma, and hue
27
New JSON query operators in SQLite 3.38.0
SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...
28
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.
29
How the SQLite virtual machine works
Let's look at how SQLite parses, optimizes, and compiles every query that it receives.
30
EdgeDB 2.0
Today we're excited to announce the release of EdgeDB 2.0, the latest version of our graph-relational database.