31
Redis adopts dual source-available licensing
Developers love Redis. Unlock the full potential of the Redis database with Redis Enterprise and start building blazing fast apps.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 350 posts.
32
My finetuned models beat OpenAI's GPT-4
Finetunes of Mistral, Llama3 and Solar LLMs are more accurate for my test data than OpenAI’s models.
33
ISO 8583: The language of credit cards
Discover the inner workings of ISO 8583, the global standard for credit card transaction messaging. Learn how it powers payment processing across networks and explore its structure, fields, and real-world applications.
34
DuckDB Doesn't Need Data to Be a Database
One of the many enjoyable things about databases is that they generally try to separate how data is represented internally (say on disk) from how it is used. To the point that it has become the norm to not even store the data on the same hardware that is running the queries.
35
36
How Meta trains large language models at scale
As we continue to focus our AI research and development on solving increasingly complex problems, one of the most significant and challenging shifts we’ve experienced is the sheer scale of co…
37
7 Databases in 7 Weeks for 2025
7 databases to explore in 2025.
38
Jepsen: Datomic Pro 1.0.7075
Datomic is a general-purpose database intended for systems of record. In many ways, Datomic is unusual. At any instant in time, the state of the database is represented by a set of [entity, attribute, value] ( EAV ) triples, known as datoms . Each datom declares that some entity (like a person) has a particular…
39
FireDucks: Pandas but Faster
Introduction My main background is a hedge fund professional, so I deal with finance data all the time and so far the Pandas library has been an indispensab...
40
Fun facts about SQLite
Some of the interesting and insane facts I learned about SQLite
41
MVCC – the part of PostgreSQL we hate the most (2023)
As much as Andy loves PostgreSQL, there is one part that is terrible and causes many headaches for people. Learn what it is and why it sucks.
42
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.
43
44
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…
45
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?
46
47
Postgres.new: In-browser Postgres with an AI interface
Introducing postgres.new, the in-browser Postgres sandbox with AI assistance.
48
DuckDB as the New jq
Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.
49
Databases and why their complexity is now unnecessary
This post is not going to be about what’s wrong with individual databases. There are so many databases and so many individual API issues, operational problems, and arbitrary limitations that it wou…
50
Rearchitecting: Redis to SQLite
Learn how we approached migrating our Wafris v1 client based on Redis to a new faster, easier to use SQLite architecture.
51
Common DB schema change mistakes in Postgres
Common DB schema change mistakes and how to avoid them in PostgreSQL development.
52
In Search of a Faster SQLite
Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.
53
B-Trees and Database Indexes
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
54
Visualizing Ext4
What does ext4 look like?
55
The Great Migration from MongoDB to PostgreSQL
How Infisical migrated from MongoDB to PostgreSQL.
56
A Canadian payroll dependency chart
Unfortunately, like most aspects of the tax system, this steadily increases in complexity, and this year with the Canada Pension Plan including not just "base" premiums and "additional" premiums but also "second additional premiums", I needed to rewrite my spreadsheet from scratch; and also very unfortunately, the…
57
The "missing" graph datatype already exists. It was invented in the '70s
This post is a response to/inspired by The Hunt for the Missing Data Type ( HN ) by Hillel Wayne. I suggest reading his article first.
58
pg_timeseries: Open-source time-series extension for PostgreSQL
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
59
Migrating Uber's ledger data from DynamoDB to LedgerStore
This week, we'll dive into how we migrated Uber’s business-critical ledger data to LedgerStore. We'll detail how we moved more than a trillion entries (making up a few petabytes of data) transparently and without causing disruption, and we'll discuss what we learned during the migration.
60
Google's new pipe syntax in SQL
A new paper from Google Research describing custom syntax for analytical SQL queries that has been rolling out inside Google since February, reaching 1,600 "seven-day-active users" by August 2024. A …