1
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 23 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
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…
8
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.
9
LiteFS
We are building a distributed file system for your SQLite databases. Kinda weird, huh?
10
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.
11
Give me /events, not webhooks
Learn about the challenges of webhooks for service-to-service notifications. And why an `/events` endpoint is often preferable.
12
Free Postgres databases for small projects
Announcing free Postgres storage on Fly.io.
13
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.
14
How PlanetScale Boost serves SQL queries faster
PlanetScale offers the world’s fastest and most scalable cloud hosting for Vitess, Neki, and Postgres.
15
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).
16
Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.
17
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.
18
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
19
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.
20
Apache Arrow Flight SQL: Accelerating Database Access
This post introduces Arrow Flight SQL, a protocol for interacting with SQL databases over Arrow Flight. We have been working on this protocol over the last six months, and are looking for feedback, interested contributors, and early adopters.
21
It’s fine, Rewind: Revert a migration without losing data
Learn how PlanetScale lets you revert changes to your database after a migration with no downtime and zero data loss.
22
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.
23
Semantic Search with SQLite
txtai is an all-in-one open-source AI framework for semantic search, LLM orchestration and language model workflows