Part of the Nothing is magic series, where we build database internals from scratch until they stop being magic. Open two psql sessions. Session A: BEGIN; DELETE FROM users; -- deletes all 1 million
Last time we built a connection pool from scratch. This time: how does a database not lose your data when the power dies? You write a row. The database says OK. A millisecond later, someone trips ove
A practical guide to pgrx with a real-world data masking example
Apache Arrow is an in-memory columnar data format optimized for analytical workloads. It enables fast data access, zero-copy reads, and efficient interoperability between systems like Pandas, DuckDB, Polars, and query engines like Apache DataFusion. ...
🚀 Introduction My journey into query engines, databases, and Rust began with curiosity and a passion for systems-level performance. Rust's promise of safety and efficiency drew me in, while databases provided the perfect playground to test its capab...
Intro about Datafusion Apache DataFusion is a Rust-native query engine with a powerful optimizer. One key component of its optimizer is expression simplification, often referred to as the simplify function. In this post, we'll walk through how we imp...
