901
Do you really need foreign keys?
Foreign keys are a bit like that well-intentioned friend who insists on double-checking everything you do. They’re often recommended as a must-have for enforcing referential integrity checks in your database.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
902
Trying chDB, an embeddable ClickHouse engine
A lightweight in-process SQL OLAP engine, powered by ClickHouse.
903
Build a search engine, not a vector DB
Don’t confuse embeddings with memory. To build effective RAG, start with a search engine, not just a vector database.
904
Jepsen: MySQL 8.0.34
MySQL needs little introduction. Over the last 28 years it has become one of the most widely deployed SQL databases. MySQL is primarily used for online transaction processing (OLTP) workloads, but is also deployed as a part of OLAP and queuing systems.
905
PostgreSQL 16 Bi-Directional Logical Replication
Introduction In this blog, we'll be going over some more advanced topics new in Postgres 16. Having some experience with Linux, Postgres, and SQL is necessary as we'll not only be going over these new features but also how to implement them. This blog was written using PostgreSQL 16 (Development Version) running on…
906
Transaction Isolation in Postgres
Ever dealt with glitches in a SaaS platform where your actions don't seem to sync up? That's often a transaction isolation issue in databases. Lets talk about transaction isolation and how they work in Postgres, so you can write reliable and performant code with minimal headache.
907
Moving from relational data to events
Knock knock? Who’s there? It’s me, Oskar, the end is near, did you know that? Ah, you know it but don’t know how to proceed? Let’s talk about the end of the CRUD world…
908
RAG to Riches
Today I will be regaling you with tales of marvelous cherry-picked new developments in AI, from Sam Altman's recent Uno Reverse incident to bear spraying job-hungry engineers.
909
Database Fundamentals
The fundamental problems a database engineer thinks about in the shower
910
Fly Postgres, Managed by Supabase
A managed Postgres offering developed by Supabase and Fly.io
911
Open and portable Postgres-as-a-service. Also available on Hetzner
With Ubicloud PostgreSQL, we are releasing an open and managed PostgreSQL, and cutting your cloud database spend by 3x.
912
Zero downtime Postgres upgrades
How we upgraded from Postgres 11.9 to 15.3 with zero downtime
913
The new local data stack: Integrating Dagster, dbt and DuckDB
Lean and efficient MDS experience: Delivers better software engineering practices to the data ecosystem with the new local MDS stack comprised of Dagster, dbt and DuckDB which offers better developer productivity by enhancing testability of the E2E pipeline.
914
Text Editor Data Structures: Rethinking Undo
Undo and redo have been a staple operation of text editors probably since the first typo was ever made, yet there has not been a lot of innovation around refining the idea of what undo and redo could be. Let’s explore what I mean…
915
916
917
918
Databases are the endgame for data-oriented design
For the first SpacetimeDB blog post, I’d like to clear up some confusion that I’ve seen arise in discussions about SpacetimeDB and address some general misperceptions about databases. My sense is tha…
919
JSONB has landed
JSONB is a rewrite of the SQLite JSON functions that, depending on usage patterns, could be several times faster than the original JSON functions. This enhancement has now landed on trunk .
920
The challenges of supporting foreign key constraints
Today, PlanetScale launched support for foreign key constraints. This article covers some of the behind-the-scenes technical challenges we had to overcome to support them.
921
Forecasts need to have error bars
Richard Rosenfeld in the most recent Criminologist published a piece about forecasting national level crime rates. People complain about the FBI releasing crime stats a year late, academics are wor…
922
A new approach to domain ranking
This is a very brief post announcing a fascinating discovery. It appears to be possible to use the cosine similarity approach powering explore2.marginalia.nu as a substitute for the link graph in an eigenvector-based ranking algorithm (i.e. PageRank). The original PageRank algorithm can be conceptualized as a…
923
Pipeworld: Spreadsheet Dataflow Computing (2021)
Now for something completely different. In the spiritual vein of One Night in Rio: Vacation photos from Plan9 and AWK for multimedia, here is a tool that is the link that ties almost all the projec…
924
Accidental database programming
Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like…
925
926
S3 Express Is All You Need
The future of modern data infrastructure is object storage.
927
Antirez' tiny JSON selector library
Salvatore Sanfilippo, aka antirez released a telegram bot library in C recently. While I'm not at all interested in a telegram bot library, I always like to read Salvatore's code, which is uniformly superb.
928
My favorite database shirts
Andy reviews his favorite NoSQL and NewSQL database shirts.
929
River: A fast, robust job queue for Go and Postgres
Introducing River, a Postgres-based job queue designed for resilience and correctness through strong transactional guarantees.
930
