DuckDB is changing how developers think about analytics. This practical guide takes you from its architecture and SQL capabilities to performance tuning, cloud storage and production deployments. Learn how DuckDB works, where it shines and how to build fast, flexible analytical systems around it.
What if you could build a graph database the way SQLite is built to disappear into an application? This book takes you inside the engine, from storage pages and transactions to traversal, queries and crash recovery. With complete working code, you’ll build a fast, durable embedded graph database from the ground up.
DuckDB has changed how people work with data by bringing fast analytical queries to a lightweight embedded database. Whether you are exploring Parquet files, building data pipelines or embedding analytics into your application, this handbook shows you how to get the most out of DuckDB with practical examples and real-world techniques.
SQLite is everywhere but running it well in production takes more than flipping a few settings. This book goes beyond the basics to show how SQLite really works, then walks through the patterns, tools and tradeoffs behind reliable, high-performance deployments. Packed with practical examples, it's built for engineers who want confidence in production.