Navigating the Volcano: Efficient Query Processing in Graph Databases The Volcano iterator model, a cornerstone of relational database query execution since its introduction in the early 1990s, op...

Packaging Graphs: A Tale of Two Sparse Cousins Everyone knows tar files! Perfect for shuttling data between filesystems like ext4 and xfs, preserving structure, ownership, and timestamps for seaml...

This post is inspired by a recent VLDB paper about database normal forms from Couchbase people. Relational Database 101 In the 1970s, a fellow named Edgar F Codd made a bunch of rules so you coul...

Introduction Graphs form the backbone of modern information retrieval and knowledge-based decision systems. Drawing from recent breakthroughs in large language models, we can now design storage sy...

I asked a leading AI what the principles should be. Response in the appendix. To me the response came across as designed to reassure humans that AI will not displace/destroy them. It’s exactly wha...

How should we approach the art of programming? Is it a disciplined practice of mastering a language and meticulously crafting code line by line, or is it fundamentally an iterative journey of trans...

Improving DuckDB DevX DuckDB, an in-process SQL database, has been gaining traction since its development began in 2018, with a significant surge in interest starting in 2022 according to Google T...

Fquery meets SQLModel Keep your Graphs and dataclasses and make them even more powerful with SQLModel and DuckDB! Fquery started as a graph query engine for nested JSON objects (think jq) that’s i...

React for Entities and Business Logic Introduction Object models have been a cornerstone of software development for decades, providing a foundation for writing business logic in various programm...

A Universal Knowledge Graph Schema I’ll keep this one short. There have been a bunch of controversies around wikipedia and it’s lack of viewpoint diversity and undue influence of state level actor...