451
I analyzed chord progressions in 680k songs
And the results surprised me
New
The latest blog posts to take off on Hacker News. 4,224 posts.
452
SQLite transactions and virtual tables
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables.
453
An intro to DeepSeek's distributed file system
Personal website for some random tidbits I work on
454
Kaggle and the Wikimedia Foundation are partnering on open data
Kaggle is hosting Wikimedia Enterprise's beta release of structured data in both French and English. Kaggle is home to a vast trove of open and accessible data, with mor…
455
Arroyo (YC W23) has been acquired by Cloudflare
Arroyo has been acquired by Cloudflare to bring serverless SQL stream processing to the Cloudflare Developer Platfrorm, integrated with Queues, Workers, and R2. The Arroyo Engine will remain open-source and self-hostable.
456
Colossus for Rapid Storage
Colossus’s performance comes from its stateful protocol, which plays a pivotal role in the new Rapid Storage offering launched at Google Cloud Next '25.
457
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)
Boost PostgreSQL full-text search speed by 50x with simple optimizations. Use VectorChord-BM25 to accelerate and better BM25 ranking in postgres.
458
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…
459
My Browser WASM't Prepared for This. Using DuckDB, Apache Arrow and Web Workers
by Przemyslaw Maciolek
460
A year of Rust in ClickHouse
This story is about how ClickHouse supports Rust components in the C++ code base and the challenges we had to overcome.
461
Database Protocols Are Underwhelming
If you’ve been in this trade for a while, you have probably seen dozens of debates on the merits and problems of SQL as a relational database query language. As an ORM maintainer, I have a few gripes with SQL, but overall it is workable, and anyway, it has so much inertia that there’s no point fantasizing about a…
462
Cursed Excel: "1/2"+1=45660
Explore Excel's bizarre date/time quirks—like “1/2”+1=45660—and how Quadratic fixes legacy issues with a modern approach to datetimes and spreadsheet logic.
463
Stop syncing everything
Discover Graft, an open-source transactional storage engine built to solve the challenges of syncing data at the edge. Inspired by lessons from SQLSync, Graft enables lazy, partial, and strongly consistent replication—allowing edge applications to sync only the data they need, exactly when they need it.
464
Turso SQLite Offline Sync Public Beta
Turso Offline Sync is now in public beta. Write to local SQLite databases offline at file speed, then sync push and pull with Turso Cloud when reconnected.
465
A glitch in an online survey replaced the word 'yes' with 'forks'
Dating back to at least early 2023, a bizarre and alarming technical glitch started popping up in some organizations’ online surveys and forms.
466
MySQL transactions per second vs. fsyncs per second (2020)
Just wondering how many transactions or writes per second MySQL can handle? While it depends on many factors, fundamentally, about as many transactions as MySQL can commit to disk per second. A modern disk can do ~1000 fsyncs per second , but MySQL will group multiple writes with each fsync. An okay rule-of-thumb…
467
468
Preview: Amazon S3 Tables and Lakehouse in DuckDB
We are happy to announce a new preview feature that adds support for Apache Iceberg REST Catalogs, enabling DuckDB users to connect to Amazon S3 Tables and Amazon SageMaker Lakehouse with ease.
469
Selective async commits in PostgreSQL – balancing durability and performance
Safely leverage PostgreSQL's asynchronous commit for significant performance gains
470
Decrypting encrypted files from Akira ransomware using a bunch of GPUs
I recently helped a company recover their data from the Akira ransomware without paying the ransom. I'm sharing how I did it, along with the full source code. Update: since this article was written, a new version of Akira ransomware has appeared that can't be decrypted with this method The c
471
In S3 simplicity is table stakes
From simple object storage to sophisticated table management, builders have always shaped S3's evolution. Andy Warfield discusses why making complex systems simple remains our north star at AWS.
472
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...
473
The DuckDB Local UI
The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.
474
Wyvern's Open Satellite Feed
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
475
476
You might not need Redis
Redis is arguably the most well regarded tech of all. But many times you do not need Redis. Here are 3 examples from my last 3 jobs.
477
The program is the database is the interface
That transfer to John Smith isn't covered by any of the tagging rules. So I select the date, switch to the editor window and paste the date into the date->tag definition:
478
Polars Cloud: The Distributed Cloud Architecture to Run Polars Anywhere
We introduce Polars Cloud, the distributed cloud architecture to scale and run Polars anywhere.
479
Optimistic Locking in B-Trees
CedarDB is a database system that delivers unmatched performance for transactions and analytics, from small writes to handling billions of rows. Built on cutting-edge research to power today’s tools and tomorrow’s challenges.
480
Postgres Just Cracked the Top Fastest Databases for Analytics
Databricks offers a unified platform for data, analytics and AI. Build better AI with a data-centric approach. Simplify ETL, data warehousing, governance and AI on the Data + AI Platform.