3001
NumPy-style broadcasting in Futhark
A high-performance and high-level purely functional data-parallel array programming language that can execute on the GPU and CPU.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
3002
Supabase Vault is now in Beta
A Postgres extension to store encrypted secrets and encrypt data.
3003
3004
3005
Visualizing Your Ruby Heap
In a previous post, I wrote a bit about how Ruby objects are laid out in memory. Today we’ll use that information to write a program that will allow us to take a Ruby heap dump and visualize the layout and fragmentation of that heap. Ruby Object Layout Recap Just as a recap, Ruby objects are fixed width. That is…
3006
Visualizing every job in the world
A visualization of every single job in the world (or at least in the EU)
3007
WAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups
How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.
3008
Datomic: this is not the history you're looking for
In this post, I'll describe some common pitfalls regarding the use of the 'time-travel' features of Datomic ( db.asOf() , db.history() , :db/txInstant ).
3009
The trouble with timestamps
Some folks have asked whether Cassandra or Riak in last-write-wins mode are monotonically consistent, or whether they can guarantee read-your-writes, and so on. This is a fascinating question, and leads to all sorts of interesting properties about clocks and causality.
3010
Riak CS is Now Open Source
Riak's cloud storage software is now open source.
3011
Decomposing Transactional Systems
Every transactional system must execute, order, validate, and persist transactions.
3012
UK Address Oddities (2018)
A few of my previous blog posts have been about quirks in the UK postal address system. As a result of these posts being moderately popular, people have contacted me to tell me about other such quirks. This pleases me greatly – I like quirks.
3013
Qdrant, the Vector Search Database, raised $28M in a Series A round
Qdrant is an Open-Source Vector Search Engine written in Rust. It provides fast and scalable vector similarity search service with convenient API.
3014
3015
What’s Wrong with Bayes
My problem is not just with the methods—although I do have problems with the method—but also with the ideology.
3016
DeWitt and Stonebraker's "MapReduce: A major step backwards" (2009)
In January 2008 David DeWitt and Michael Stonebraker published an article criticising MapReduce. As far as I can find, the article is no lon...
3017
3018
Which vector database should I use? A comparison cheatsheet
Semantic search and retrieval-augmented generation (RAG) applications require systems to be able to save lots of embedding vectors…
3019
3020
3021
Improving Postgres text search speed
CharityAPI.org improved our Postgres response time so that searches initiated via our API were 760% faster without adding an additional tool like Elastic Search. This is how we did it.
3022
MySQL now shows its thread names at OS level for better troubleshooting
Starting from v8.0.27, the MySQL daemon shows its thread names at the OS level too, for better troubleshooting. The MySQL 8.0.27 release notes say this: To assist monitoring and troubleshooting, the Performance Schema instrumentation is now used to export names of instrumented threads to the operating system. This…
3023
Why use Paxos instead of Raft?
TLDR: Neon separates storage and compute, substituting the PostgreSQL persistency layer with a custom-made distributed storage written in Rust. Due to this separation, some nodes don’t have persistent disks. The original Raft paper works only with uniform nodes, but Paxos variants support proposers without storage and…
3024
The Multiple SQLite Problem
If your app makes use of two separate instances of the SQLite library, you can end up with a corrupted SQLite data file.
3025
Four billion messages an hour: benchmarking Deepstream throughput
A realtime server for the modern web
3026
Optimization tricks in Python: lists and tuples
An overview of optimization tricks for lists and tuples
3027
Finding MongoDB instances without any authentication
I would like to take a moment to discuss databases. Most people use Shodan to find devices that have web servers, but for a few years now I've also been crawling the Internet for various database software. I usually mention this during my talks and I've tried to raise awareness
3028
PlanetScale Scaler Pro
See how Scaler Pro combines the best of our current plans for companies of all sizes while enabling you to grow with the best database for serverless.
3029
World `countries` – database table for MySQL
So today, I was buzzing around and searching for a `countries` table script that I could use in MySQL database. As you can imagine, it wouldn’t make any sense to add all world countries into …
3030
Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.