991
Introduction to vector similarity search (2022)
Learn what vector search is and the metrics pertinent to decide the distance (or similarity) between objects.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
992
Etcd v3: increased scale and new APIs
No single cloud fits all. Explore how we build a more flexible future with hybrid cloud.
993
Moving our warehouse off DuckDB
We moved our warehouse product off DuckDB and DuckLake onto our own flavor of Trino and a new open table format, HogLake. Here's what broke at scale and why.
994
995
996
PostgreSQL Performance on Raspberry Pi
Have you ever wondered how well PostgreSQL performs on a Raspberry Pi 3B ? Oh. You haven't? Oh well, I asked myself that question and put it to the test. This post covers how I used pgbench to answer this question and the results of what I found.
997
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
998
Difference between running Postgres for yourself and for others
At Ubicloud, our managed cloud service enables us to run PostgreSQL for others. We open sourced our implementation, so we thought this was a good opportunity to talk about its features. This blog post summarizes features commonly available in a managed service. It also describes interesting differences between running…
999
When an SQL Database Makes a Great Pub/Sub
We explore how databases be used as effective Pub/Subs in Go, demonstrating how SQL's unique features can enhance message-driven applications.
1000
How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design
A discussion of aggregation in PostgreSQL and how it integrates with the design of Timescale’s hyperfunctions.
1001
1002
DuckDB 0.8
The DuckDB team is happy to announce the latest DuckDB release (0.8.0). This release is named “Fulvigula” after the Mottled Duck (Anas Fulvigula) native to the Gulf of Mexico. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many…
1003
1004
1005
Building AI agents to query your databases
In the world of AI agents, the ability to understand and analyze structured data is a game-changer. While large language models excel at understanding natural...
1006
Tips for a healthier Postgres database (2021)
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
1007
Chess in SQL
What if I told you SQL could play chess? No JavaScript, no frameworks - just pure SQL rendering a full chess board in your browser.
1008
PostgreSQL Schema Design
The Postgres database is rich with features well beyond that of any other
1009
Pg_later: Asynchronous Queries for Postgres
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
1010
DuckDB 1.0.0
The DuckDB team is very happy to announce that today we’re releasing DuckDB version 1.0.0, codename “Snow Duck” (anas nivis).
1011
Pyroscope and Grafana Phlare join together
We’re happy to announce that Pyroscope, the company behind the open source continuous profiling project of the same name, is now part of Grafana Labs.
1012
1013
Redis Anti-Patterns
Learn to dodge common Redis pitfalls like large keys and hot keys. Boost both your performance and stability. Try it today.
1014
Building ClickHouse Cloud from scratch in a year
Have you ever wondered what it takes to build a serverless software as a service (SaaS) offering in under a year? In this blog post, we will describe how we built ClickHouse Cloud from the ground up
1015
Can you use autoregressive diffusion to generate market data?
The following is part of a series of posts about 2026 summer intern projects – for more, see “What the interns have wrought, special jumbo 2026 edition”
1016
1017
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
1018
LogDevice: a distributed data store for logs
Visit the post for more.
1019
pg_duckdb: Splicing Duck and Elephant DNA
Introducing the DuckDB + Postgres Extension: You can have your analytics and transact them too with pg_duckdb by DuckDB Labs, MotherDuck, Hydra, Neon and Microsoft. | Reading time: 8 min read
1020
PostgreSQL B-Tree index deduplication
PostgreSQL 13 development is coming along nicely, Postgres 13 Beta3 was released on 8/13/2020 . The Postgres Beta 1 and 2 releases were released in May and June 2020. One of the features that has my interest in Postgres 13 is the B-Tree deduplication effort. B-Tree indexes are the default indexing method in Postgres…