3541
Overview of Consistency Levels in Database Systems
Database systems typically give users the ability to trade off correctness for performance. We have spent the previous two posts in this s...
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3542
A Case for Upserts
Some thoughts on why upserts are necessary to write reliable web applications.
3543
Average is all you need
LLMs will make more of your average stuff. And that's OK. Here's how average SQL beats fancy attribution models when your agent writes the queries.
3544
How multi-disk failures happen
Having seen this failure mode happen a couple times now, it's time to share. Yes, Virgil, multi-disk failures DO happen during RAID rebuilds. I have pictures, so it MUST be true!First,
3545
3546
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.
3547
Getting Started with Event Sourcing in Postgres
In a previous post we explored how our application tracks sent emails. We set things up to update or insert a record for each email with the current state (delivered, dropped, etc). In this post we'll look at an alternative data model where we'll store each event as its own record and then roll up t
3548
3549
How Quid uses deep learning with small data
Enhance your consumer & market intelligence knowledge with our resource library. Discover the role of Generative AI in transforming the digital landscape.
3550
Unbalanced reads from SSDs in software RAID mirrors in Linux
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
3551
3552
3553
Using the linear distance operator in Postgres 12 to find the closest match
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
3554
SQLite's Use of Tcl (2017)
The design of SQLite was inspired by the design of TCL, both in the way it handles datatypes and in the formatting of its source code. The index use case for SQLite was in a Tcl/Tk application for an industrial company. From its inception, SQLite has always depended heavily on TCL. These days, SQLite no longer uses…
3555
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.
3556
Announcing pqR: A faster version of R
pqR — a “pretty quick” version of R — is now available to be downloaded, built, and installed on Linux/Unix systems. This version of R is based on R-2.15.0, but with many performance im…
3557
Valkey achieved one million RPS 6 months after forking from Redis
Maximize the performance of your hardware with memory access amortization
3558
3559
The Way Server-Side Analytics Should Be
Explore technical topics, solutions, and resources for building with Twilio – and beyond.
3560
3561
PostgresBench: A Reproducible Benchmark for Postgres Services
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
3562
3563
How to Build Your Distributed Database
Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.
3564
3565
Firefly – Full Text Search Engine for Dropbox
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
3566
What the SATs Taught Us about Finding the Perfect Fit
On the Stitch Fix Algorithms team, we’ve always been in awe of what professional stylists are able to do, especially when it comes to knowing a customer’s si...
3567
LocalForage: Offline Storage, Improved
Web apps have had offline capabilities like saving large data sets and binary files for some time. You can even do things like cache MP3 files. Browser technology can store ...
3568
The technology behind preview photos
Visit the post for more.
3569
Kurdish Parentheses on OpenStreetMap, Three Ways
While making a proposal to update Noto fonts for OpenStreetMap tiles, which fixes an issue with Kurdish labels using ڵا , I noticed a street with mismatched parentheses and was anticipating a deep dive into the tile renderer. But the actual problem was somewhere else:
3570