2191
Postgres full-text search is Good Enough (2015)
When you have to build a web application, you are often asked to add search. The magnifying glass is something that we now add to wireframes without even knowing what we are going to search.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
2192
2193
2194
Unreasonable Effectiveness of SQL
Read Couchbase engineering tutorials, product news, and customer stories on AI agents, Capella, vector search, mobile sync, and real-time analytics.
2195
SQLite Archive Files (2018)
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
2196
Machine Learning Engineer Guide: Feature Store vs. Data Warehouse
The feature store is a data warehouse of features for machine learning (ML)....
2197
We are building data breach machines and nobody cares
A few weeks ago, my longstanding friend and colleague Curt Cunning mentioned to me that he was slogging through Nietzsche, which bespeaks his incredible will to power through things that are unpleasant (one of the many things that makes him an exceptional engineer). In any case, it lead me to revisit some of his work…
2198
DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
We are releasing DuckDB version 1.5.2, a patch release with bugfixes, performance improvements, and support for the DuckLake 1.0 lakehouse format.
2199
A type-safe, realtime collaborative Graph Database in a CRDT
Open-source TypeScript property graph database from codemix.
2200
Scaling Kafka at Honeycomb
See how Honeycomb reduced Kafka cost by a total of 87% per megabyte/sec of throughput w/ AWS’s new Amazon EC2 lm4gn instance family and Confluent Tiered Storage.
2201
Amazon releases 51-language dataset for language understanding
MASSIVE dataset and Massively Multilingual NLU (MMNLU-22) competition and workshop will help researchers scale natural-language-understanding technology to every language on Earth.
2202
Gcloud storage: Faster data transfers for Cloud Storage
gcloud CLI enables super-fast data transfers into Cloud Storage and delivers a consistent CLI experience across all Google Cloud services.
2203
Datomic and Content Addressable Techniques
Datomic and Content Addressable Techniques: An Ultimate Data Wonderland
2204
How to better calculate churn rates
According to Andreessen Horowitz, this number is one of the top 16 metrics to measure a SaaS startup by. Well, sorry Andreessen, and sorry Horowitz, but this just isn't right.
2205
2206
Backblaze Drive Stats for 2025
Backblaze's 2025 Year-End Drive Stats Report provides an in-depth analysis of hard drive failure rates for Q4, the full year, and lifetime performance across its data center fleet.
2207
2208
2209
2210
Google’s S2, geometry on the sphere, cells and Hilbert curve
Update - 05 Dec 2017: Google just announced that it will be commited to the development of a new released version of the S2 library, amazing news, repository can be found here. Google's S2 library is a real treasure, not only due to its capabilities for spatial indexing but also because it is a library that
2211
OpenZFS vs. Btrfs and other file systems (2017)
Michael Dexter returns to update his blog post on the different file systems and details some key developments that are unfolding. He covers what's being added to these respective file systems: OpenZFS, Btrfs, and bcachefs. Michael Dexter has invested his volunteer time and career in Open Source hypervisors and file…
2212
The Dutch benefits scandal: a cautionary tale for algorithmic enforcement
On January 15, the Dutch government was forced to resign amidst a scandal around its child-care benefits scheme. Systems that were meant to detect misuse of the benefits scheme, mistakenly labelled over 20,000 parents as fraudsters. More crucially, a disproportionate amount of those labelled as fraudsters had an…
2213
2214
EdgeDB is now Gel and Postgres is the future
EdgeDB is now Gel. New identity, renewed focus on delivering the best PostgreSQL data platform in the world.
2215
Does anyone run Postgres without PgBouncer?
Almost every notable managed Postgres provider bundles a connection pooler, giving us a strong hint that connection management is a product problem rather than a user problem.
2216
Scalability, but at what cost? (2015)
Michael Isard, Derek Murray, and I recently sent in a HotOS submission (it’s not blind, so no harm talking about it, we think). The subject is hinted at from...
2217
CVE-2019-9193: Not a Security Vulnerability
There is widespread mention in the media of a security vulnerability in PostgreSQL, registered as [CVE-2019-9193](https://nvd.nist.gov/vuln/detail/CVE-2019-9193). The PostgreSQL Security Team …
2218
Modern SQL: With – Organize Complex Queries
The WITH clause adds named subqueries to SQL queries. WITH is also known as Common Table Expression (CTE).
2219
CockroachDB 1.1 Released: Production Made Easy
CockroachDB 1.1 includes support for faster migrations from legacy databases, simplified cluster management, and improved performance.
2220
Positron, a New Data Science IDE
We are excited to introduce Positron , a free, next-generation Integrated Development Environment (IDE) for data science by Posit PBC. Positron brings the spectrum of exploration and production work together in one environment so you can move from ideation to insight to application without switching context…