Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
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…
So, you want to deploy on the edge?
Application developers often deploy their apps into a single area, generally represented by a handful of AZs in a single region. No matter where their …
Julia Computing Granted $600k by Moore Foundation
As data-driven research becomes more mainstream, the need for efficient and powerful scientific computing tools increases. To help meet this need, the Gordon an…
Introducing Workers KV
In 1864 British computer pioneer Charles Babbage described the first key-value store to be used as part of his Analytical Engine.
RethinkDB 1.16: cluster management API, realtime push
The 1.16 release is a precursor to the upcoming 2.0 release, and is the biggest RethinkDB release to date with over 300 enhancements . This release includes two exciting new features: a comprehensive API for large cluster management, and realtime push functionality that dramatically simplifies the development of…
Spark as a Compiler: Joining a Billion Rows per Second on a Laptop
Discover how Apache Spark can join a billion rows per second on a laptop, showcasing its powerful data processing capabilities.
How rqlite is tested
rqlite is a lightweight, open-source, distributed relational database written in Go, and built on SQLite and Raft. With its origins dating back to 2014, its design has always prioritized reliability, and quality. The robustness of rqlite is also a testament to its disciplined testing strategy: after more than 10 years…
Amazon Machine Learning – Make Data-Driven Decisions at Scale
Today, it is relatively straightforward and inexpensive to observe and collect vast amounts of operational data about a system, product, or process. Not surprisingly, there can be tremendous amounts of information buried within gigabytes of customer purchase data, web site navigation trails, or responses to email…
Reverse-Engineering Xkcd's 'Frequency'
About a week ago, Randall Munroe published Frequency , the 1331st entry in his xkcd webcomic series. Unlike most xkcd comics, it's animated — actually, 5-by-10 grid of animated GIFs. Each describes a scenario (e.g., "one birth," or "someone locks their keys in their care") and blinks at the scenario's purported…
Machine Learning Algorithms Cheat Sheet
Machine learning is a subfield of artificial intelligence (AI) and computer science that focuses on using data and algorithms to mimic the way people learn, progressively improving its accuracy. This way, Machine Learning is one of the most interesting methods in Computer Science these days, and it'
Neki – Sharded Postgres by the team behind Vitess
Sharded Postgres by the team behind Vitess
SQLite 3.42.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
Migrating 1200 databases from MySQL to Postgres
Once Upon a Time there was a company called Base7Booking that by the beginning of 2016 it was supporting around 1200 databases on MySQL 5...
Transformer – Spreadsheet
Make your own AI by hand ✍️ exercises
YC Stats
We get asked (a lot) for statistics on the YC portfolio about valuation and fundraising. Although these are very imperfect indicators of success, here they are. All of these companies actually went through a YC batch and got their start with us (e.g. we do not include Quora). Also, the YC application for the next…
Valkey Turns One: Community fork of Redis
Valkey is not only thriving, but now outperforming Redis 8.0 in real world benchmarks.
How I slashed a SQL query's runtime with two Unix commands
I was trying to run a simple join query on MariaDB (MySQL) and its performance was horrendous. Here’s how I cut down the query’s run time from over 380 hours to under 12 hours by executing part of it with two simple Unix commands.
A major Postgres upgrade with zero downtime
Right before Christmas we discovered that our Aurora Postgres instance needed a major version upgrade. This covers how we made the upgrade with zero seconds of downtime.
What is a database transaction?
What are database transactions and how do SQL databases isolate one transaction from another?
Better RAG Results with Reciprocal Rank Fusion and Hybrid Search
Optimize your support with Assembled's Hybrid Search. Learn how we enhance RAG results using Reciprocal Rank Fusion for accurate, relevant answers.
We made Postgres writes faster, but it broke replication
Exploring LSM tree implementation in PostgreSQL for better write performance.
PostgreSQL query performance bottlenecks
PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I'll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.
Detecting LLM-Generated Texts with “Classical” Machine Learning
.admonition { margin: .75em 0; padding: .6rem; overflow: hidden; font-size: 12px; page-break-inside: avoid; border-left: .3rem solid #42b983; border-radius: .3rem; box-shadow: 0 0.1re