3541
A Case for Upserts
Some thoughts on why upserts are necessary to write reliable web applications.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3542
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.
3543
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,
3544
3545
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.
3546
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
3547
3548
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.
3549
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…
3550
3551
3552
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.
3553
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…
3554
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.
3555
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…
3556
Valkey achieved one million RPS 6 months after forking from Redis
Maximize the performance of your hardware with memory access amortization
3557
3558
The Way Server-Side Analytics Should Be
Explore technical topics, solutions, and resources for building with Twilio – and beyond.
3559
3560
PostgresBench: A Reproducible Benchmark for Postgres Services
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
3561
3562
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.
3563
3564
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.
3565
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...
3566
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 ...
3567
The technology behind preview photos
Visit the post for more.
3568
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:
3569
3570
How big are our embeddings now and why?
Embedding sizes and architectures have changed remarkably over the past 5 years