1
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 36 posts.
2
I'm all-in on server-side SQLite
Ben Johnson has joined Fly.io
3
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.
4
Quirks, Caveats, and Gotchas in SQLite
The SQL language is a "standard". Even so, no two SQL database engines work exactly alike. Every SQL implementation has its own peculiarities and oddities, and SQLite is no exception to this rule.
5
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
6
The top programming languages
Explore the top programming languages on GitHub—and what languages are growing the fastest.
7
Surprises in the Bitcoin blockchain and how they are stored (2014)
Every Bitcoin transaction is stored in the distributed database known as the Bitcoin blockchain. However, people have found ways to hack ...
8
Laion-5B: A new era of open large-scale multi-modal datasets
We present a dataset of 5,85 billion CLIP-filtered image-text pairs, 14x bigger than LAION-400M, previously the biggest openly accessible image-text dataset…
9
Just use Postgres for everything
Replace Redis, MongoDB, Kafka & more with PostgreSQL. Reduce complexity, boost development speed. Complete guide with real examples.
10
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.
11
LiteFS
We are building a distributed file system for your SQLite databases. Kinda weird, huh?
12
Modeling Starlink Capacity
Prior attempts to calculate Starlink’s potential for service have been theoretical. We simulate based on the actual constellation.
13
Simple declarative schema migration for SQLite
At my company we use a small SQLite database. We define the schema in a single file with SQL CREATE TABLE statements. If we add tables, columns, or indexes, our application will create them automatically the next time it starts up.
14
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:
15
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.
16
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.
17
Give me /events, not webhooks
Learn about the challenges of webhooks for service-to-service notifications. And why an `/events` endpoint is often preferable.
18
Free Postgres databases for small projects
Announcing free Postgres storage on Fly.io.
19
UUIDs are popular, but bad for performance (2019)
MySQL UUIDs are still very popular despite a majority of posts warning against their usage. Learn what UUIDs are and why they are very bad for MySQL performance.
20
How PlanetScale Boost serves SQL queries faster
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
21
PostgreSQL used fsync incorrectly for 20 years (2019) [video]
About a year ago the PostgreSQL community discovered that fsync (on Linux and some BSD systems) may not work the way we always thought it is, with possibly disastrous consequences for data durability/consistency (which is something the PostgreSQL community really values).
22
ULIDs and Primary Keys
Not all non-sequential primary keys are created equal, the ULID format is a fantastic substitute for the typical UUIDv4 choice.
23
Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.
24
Revisiting the principles of data-oriented programming
Principles of Data-Oriented Programming. Benefits and costs of Data-Oriented Programming. DOP vs OOP. DOP vs FP.
25
Supabase Wrappers: A framework for building Postgres foreign data wrappers
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
26
I almost failed to search a 37 GB text file in under 1 millisecond
... in which we check if your password has been compromised in many inconvenient ways, in a tale of destruction, obsession, and self-discovery.
27
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
28
Postgres full-text search: A search engine in a database (2021)
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.
29
Datasette’s new JSON write API: The first alpha of Datasette 1.0
This week I published the first alpha release of Datasette 1.0, with a significant new feature: Datasette core now includes a JSON API for creating and dropping tables and inserting, …
30
Reddit’s database has two tables (2012)
Steve Huffman talks about Reddit’s approach to data storage in a High Scalability post from 2010. I was surprised to learn that they only have two tables in their database.