Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
Modern Data Practice and the SQL Tradition
This made it to the Hacker News front-page too: some very interesting comments there
ORM is an anti-pattern
ORM looks great early in a project but breaks down as complexity grows, forcing you to learn SQL anyway. Relations aren't objects. Either use NoSQL for object-like data or write a model layer with real SQL. ORM's abstraction is leaky, its efficiency poor, and the alternatives are better.
Why SQLite is so great for the edge
Everyone already knows that SQLite is great. This article makes the praise much more specific though — it explains why we, the developers of libSQL, think that SQLite is a great choice for bringing your data to the edge.
You don't need ML/AI, you need SQL
On Software, life and everything in-between
Analyzing Analytics (Featuring: The FBI)
Recently while conducting some research, I found myself down the path of Google Analytics ID's as well as other analytics services. I was investigating ways to not only identify varying analytics code in sites, but to correlate them with ot…
Movable tree CRDTs and Loro's implementation
This article introduces the implementation difficulties and challenges of Movable Tree CRDTs when collaboration, and how Loro implements it and sorts child nodes. The algorithm has high performance and can be used in production.
Zero-latency SQLite storage in every Durable Object
Kenton Varda introduces the next iteration of Cloudflare's Durable Object platform, which recently upgraded from a key/value store to a full relational system based on SQLite. For useful background on …
How RocksDB Works
Over the past years, the adoption of RocksDB increased dramatically. It became a standard for embeddable key-value stores.
Prisma Postgres – Runs on bare metal and unikernels
At Prisma, we believe that deploying a database should be as simple as adding a new page in Notion. Today, we are excited to share the first milestone towards this vision: Prisma Postgres® gives developers an always-on database with pay-as-you-go pricing, thanks to our unique architecture design.
Erasure Coding for Distributed Systems
An overview of erasure coding, its trade-offs, and applications in distributed storage systems.
Comparison – R vs. Python: head to head data analysis
R vs Python — which is better for data analysis and data science? Compare the two languages side by side for an objective answer!
Parquet: An efficient, binary file format for table data
Quicker, but also more convenient
Google Cloud Firestore NoSQL database is in GA
The Cloud Firestore database is a NoSQL, serverless solution for mobile and web application development -- now generally available globally.
Trademark Actions Against the PostgreSQL Community
The PostgreSQL Core Team and the PostgreSQL Community Association of Canada (PGCAC) wish to provide clarification on the ownership and …
Exploring PostgreSQL 18's new UUIDv7 support
Exploring what's interesting about UUIDv7 support using a demo crab store.
The MongoDB hack and the importance of secure defaults
There’s a widespread attack on insecure MongoDB installs that has resulted in over 28,000 databases being held ransom. This post explains the hack, how to protect yourself and what can we learn from it.
GraphRAG is now on GitHub
GraphRAG, a graph-based approach to retrieval-augmented generation (RAG) that significantly improves question-answering over private or previously unseen datasets, is now available on GitHub. Learn more:
Julia: Faster than Fortran, cleaner than Numpy
I'm super enthusiastic about Julia after running this comparison of Julia vs Numpy vs Fortran, for performance and code simplicity.
Moving Away from UUIDs (2018)
If you need an unguessable random string (for a session cookie or access token, for example), it can be tempting to reach for a random UUID, which looks like this: 88cf3e49-e28e-4c0e-b95f-6a68a785a…
PostgreSQL 11.3 and 10.8
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.3, 10.8, …
Postgres is eating the database world
PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database…
Monarch: Google’s Planet-Scale In-Memory Time Series Database
These paper reviews can be delivered weekly to your inbox , or you can subscribe to the Atom feed . As always, feel free to reach out on Twitter with feedback or suggestions!