151
We cut our Mongo DB costs by 90% by moving to Hetzner
We moved MongoDB Atlas off AWS and onto self-hosted Hetzner boxes — 90% cost cut, no performance loss. Here's the setup, the Ansible, and what broke.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
152
153
SQLite concurrency and why you should care about it
SQLite is a powerful database engine, but due to its design, it has limitations that should not be overlooked.
154
Using the expand and contract pattern for schema changes
In this article, we introduce the expand and contract pattern to help migrate data and clients to a new schema.
155
Use DuckDB-WASM to query TB of data in browser
The Library Innovation Lab is growing knowledge and community by bringing library principles to technological frontiers.
156
PlanetScale Offering $5 Databases
Introducing the $5 PlanetScale plan.
157
Replacing EBS and Rethinking Postgres Storage from First Principles
Fluid Storage reimagines block storage like EBS with zero-copy forks, true elasticity, and sync replication. Built for the age of agents.
158
Kafka is Fast – I'll use Postgres
Why you should just use Postgres instead of Kafka for small-scale message queuing and pub-sub patterns. Benchmarks and practical tests included.
159
A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec
What happens when you give a distributed SQL engine a trillion-row dataset? GizmoEdge crushed the Coiled challenge with a 1,000-worker cluster on Azure.
160
JupyterGIS breaks through to the next level
Launched in June 2024, JupyterGIS was introduced as a collaborative, web-based GIS environment built on the JupyterLab framework. Its objective is to
161
162
Is Postgres read heavy or write heavy?
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
163
Are hard drives getting better?
After 13 years, the data is clear—the bathtub curve does not apply to hard drives. And, more importantly, hard drives are failing less and lasting longer.
164
Exploring PostgreSQL 18's new UUIDv7 support
Exploring what's interesting about UUIDv7 support using a demo crab store.
165
Benchmarking Postgres 17 vs. 18
Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17.
166
Scaling request logging with ClickHouse, Kafka, and Vector
How we solved request logging at scale by moving from MariaDB to ClickHouse, Kafka, and Vector after our deprecated database engine couldn't keep up with billions of monthly requests.
167
Personal data storage is an idea whose time has come
Data Ownership as a conversation changes when data resides primarily with people-governed institutions rather than corporations.
168
Which table format do LLMs understand best?
We benchmarked 11 data formats, including markdown tables, JSON, CSV, YAML, XML, and more, to see which LLMs understand best. We found surprising accuracy and token cost trade-offs.
169
Litestream v0.5.0
Same Litestream goodness but better, faster, stronger
170
TigerBeetle is a most interesting database
This read goes behind the scenes of how TigerBeetle came to be, the incredibly novel software they’ve built, and all of the wacky, wonderful things that make them so special.
171
What’s New in PostgreSQL 18 – a Developer’s Perspective
PostgreSQL 18 features that change how application developers write and ship code.
172
Windows ML is generally available
The future of AI is hybrid, utilizing the respective strengths of cloud and client while harnessing every Windows device to achieve more. At Microsoft, we are reimagining what’s possible by bringing powerful AI compute directly to Windows devices,
173
PostgreSQL 18 Released
The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the world's most advanced …
174
SedonaDB: A new geospatial DataFrame library written in Rust
Apache Sedona is a cluster computing system for processing large-scale spatial data. Sedona extends existing cluster computing systems, such as Apache Spark, Apache Flink, and Snowflake, with a set of out-of-the-box distributed Spatial Datasets and Spatial SQL that efficiently load, process, and analyze large-scale…
175
PlanetScale for Postgres is now GA
PlanetScale for Postgres is now generally available.
176
Download responsibly
This month we’ve ramped up the infrastructure behind the download server, and downloads should now be available earlier and faster. There’s also a small technical change in that requests for a “…latest” file will now be answered with a HTTP redirect to the specific latest version (see previous blog post).
177
UUIDv7 Comes to PostgreSQL 18
PostgreSQL 18 adds native support for UUIDv7. A timestamp-based UUID variant that plays nicely with btree indexes. Here's what that means for you.
178
TernFS – An exabyte scale, multi-region distributed filesystem
XTX Markets is a leading algorithmic trading firm which uses state-of-the-art machine learning technology to produce price forecasts for over 50,000 financial instruments across equities, fixed income, currencies, commodities and crypto. It uses those forecasts to trade on exchanges and alternative trading venues, and…
179
Optimizing ClickHouse for Intel's ultra-high core count processors
Intel's latest processor generations are pushing the number of cores in a server to unprecedented levels. For analytical databases like ClickHouse, ultra-high core counts represent a huge opportunity and a complex challenge.
180
Vector database that can index 1B vectors in 48M
Discover why we built Vectroid, a serverless vector database that delivers exceptional accuracy and low latency without compromising on cost. Learn about our approach to solving the traditional tradeoffs between speed, accuracy, and cost in vector search.