1321
Now that people are considering NOSQL will more people consider no-DB
A memory image replaces database interactions with in-memory data using event sourcing to record persistent changes
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
1322
Data centers contain 90% crap data
We need to talk about the data. Crap data. We’re destroying our environment to create and store trillions of blurred images, half-baked videos, rip-off AI ‘songs’, rip-off AI animations, videos and images, emails with mega attachments, never-to-be-watched-again presentations, never-to-be-read-again reports, files and…
1323
Replacing Elasticsearch with Rust and SQLite (2017)
Caveat: Elasticsearch is a multi-purpose, distributed, battle-tested, schema-free, log and document storage engine. We’ll be replacing it with a single-purpose, relational schema, me-tested, and custom nginx access log storage engine. Knowing that, let’s begin. Find this project on Github After building my home…
1324
Redis is forked
Where do we go from here?
1325
MongoDB 3.4.0-rc3
In the past year and a half, MongoDB has put a good deal of work into improved read safety, enabled by the adoption of their new replication protocol and the WiredTiger storage engine. Dirty reads were addressed in 3.2 by introducing a majority read concern , and stale reads were addressed with the introduction of the…
1326
Thoughts on Time-series Databases
Preetam "recently" blogged about catena , a time-series metric store. There was another blog post about benchmarking boltdb by a Fog Creek engineer, also looking to write a time series database. This is something of a pattern in the Go community, which already boasts seriesly , InfluxDB , and prometheus ; there are…
1327
Why Polars rewrote its Arrow string data type
We have completely rewritten the string/binary data structure we use in Polars.
1328
Roaring bitmaps: what they are and how they work
A detailed primer on Roaring bitmaps explaining what they are, how they're different from traditional bitmaps, and how they work internally.
1329
NoSQL Data Modeling Techniques
NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. This aspect of NoSQL is well-studied both in practice and theory because sp…
1330
Algolia Acquires Search.io
Acquisition creates world’s first and only hybrid search engine combining Keyword and Vector Search in a single API.
1331
Super fast aggregations in PostgreSQL 19
See how PostgreSQL 19 speeds up aggregations by aggregating before joins, with a benchmark showing over 5x faster execution.
1332
1333
1334
Datasette’s new JSON write API: The first alpha of Datasette 1.0
This week I published the first alpha release of Datasette 1.0, with a significant new feature: Datasette core now includes a JSON API for creating and dropping tables and inserting, …
1335
GLM 5.2 is nearly as accurate as a human book keeper
A real quarter of UK SME books, 59 transactions, 68 minutes, $2.73 of tokens — and a VAT return within 7 pence of the human-prepared one.
1336
Visualizing How Developers Rate Their Own Programming Skills
As it turns out, there is no correlation between programming ability and the frequency of Stack Overflow visits.
1337
Causal inference as a blind spot of data scientists
Throughout much of the 20th century, frequentist statistics dominated the field of statistics and scientific research. Frequentist statistics primarily focus on the analysis of data in terms of probabilities and observed frequencies. Causal inference, on the other hand, involves making inferences about…
1338
1339
How I Built Zig-SQLite
Article explaining how to leverage Zig's compile time metaprogramming to build a SQLite wrapper that can type check SQL queries
1340
P99 0 ms* autocomplete for 240M domain names
How Wirewiki's domain-name autocomplete renders suggestions next frame for 99% of keystrokes.
1341
1342
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.
1343
Open-sourcing F14 for memory-efficient hash tables
Hash tables provide a fast way to maintain a set of keys or map keys to values, even if the keys are objects, like strings. They are such a ubiquitous tool in computer science that even incremental…
1344
1345
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.
1346
Postgres as queue
The team I've been working in for the last year or so have had great success using Postgres-as-queue. We've managed to avoid the following:
1347
How much faster is Redis at storing a blob of JSON compared to Postgres?
tl;dr; Redis is 16 times faster at reading these JSON blobs.*
1348
Chronon, Airbnb's ML feature platform, is now open source
A feature platform that offers observability and management tools, allows ML practitioners to use a variety of data sources, while handling…
1349
I don't think Elasticsearch is a good logging system
I’ve been a heavy user of ElasticSearch for coming up 7 years now. During that time I’ve used it for a few main usecases: A Search Engine, An APM Solution (after NewRelic started being stupidly expensive), a backend for Jaeger, and as a log storage system. In all of those usecases I’ve really pushed ElasticSearch to…
1350
Open and portable Postgres-as-a-service. Also available on Hetzner
With Ubicloud PostgreSQL, we are releasing an open and managed PostgreSQL, and cutting your cloud database spend by 3x.