Books

This series of test-driven small coding puzzles lets you code a database from scratch (no dependencies).We'll cover KV storage engines, LSM-Tree indexes, SQL, concurrent transactions, ACID, etc.

This book provides an introduction to the high-level concepts behind query engines and walks through all aspects of building a fully working SQL query engine in Kotlin.

Learn databases from the bottom up by coding your own, in small steps, and with simple Go code (language agnostic).Atomicity & durability. A DB is more than files!Persist data with fsync.Crash recovery.KV store based on B-tree.Disk-based data structures.Space management with a free list.Relational DB on top of KV.Learn how tables and indexes are related to B-trees.SQL-like query language; parser & interpreter.Concurrent transactions with copy-on-write data structures.

A high-performance data access layer must resonate with the underlying database system. Knowing the inner workings of a relational database and the data access frameworks in use can make the difference between a high-performance enterprise application and one that barely crawls.

Unlock the power of DuckDB for modern geospatial analytics. This hands-on guide helps GIS professionals master efficient spatial data management, transforming massive real-world datasets into powerful insights using SQL, Python, and DuckDB’s spatial extension. Full-color print edition is available on Amazon.

Dies ist die top-aktuelle Version dieses Fachbuchs, die am 04.12.2025 im Umfang von 827 Druckseiten erschienen ist. Dieses Buch behandelt die aktuellste Version 10.0 RTM von Entity Framework Core.

Build real-world software by coding a Redis server from scratch.Network programming. The next level of programming is programming for multiple machines. Think HTTP servers, RPCs, databases, distributed systems.Data structures. Redis is the best example of applying data structures to real-world problems. Why stop at theoretical, textbook-level knowledge when you can learn from production software?Low-level C. C was, is, and will be widely used for systems programming and infrastructure software. It’s a gateway to many low-level projects.From scratch. A quote from Richard Feynman: “What I cannot create, I do not understand”. You should test your learning with real-world projects!

Desbloquea el poder de DuckDB para la analítica geoespacial moderna. Esta guía práctica ayuda a los profesionales de SIG a dominar la gestión eficiente de datos espaciales, transformando grandes conjuntos de datos del mundo real en conocimientos valiosos mediante SQL, Python y la extensión espacial de DuckDB. La edición impresa a todo color está disponible en Amazon.

Unlock your SQL skills with "Self-Guided SQL: Build Your SQL Skills with SQLite"! This comprehensive book is designed for both the classroom and self-driven learners who value practice and hands-on experience. Through progressive challenges and repeated exercises, this guide helps you build a solid foundation in SQL using the powerful and popular SQLite database software. With "Self-Guided SQL", you will learn by doing, seeing SQL in action with enough explanation to help you understand what's happening behind the scenes. Every lesson moves you forward and builds on the skills you've previously gained, helping to continually reinforce them. "Self-Guided SQL" will help you take control of your your own education in these versatile and powerful technologies, ensuring that you not only understand SQL concepts but can also apply them confidently and effectively!

A visual guide for understanding Modern Data Pipelines Testing Techniques

这个一个用代码手搓数据库的项目。你可以通过这个项目：学习数据库底层原理和计算机基础。提升技术深度。通过实操来锻炼编程技能。获得一个完整的个人项目。可以用在简历、面试中。项目全面实现了几个最重要的部分：KV 储存引擎。SQL 与关系型数据库。索引与数据结构。虽然范围很广，但是被拆分成了多个小步骤。每个步骤都很简单，最多几十行代码。你会发现，复杂的概念可以从简单的概念演变而来，可以说是从0开始发明数据库。 作者网站上精选了一些类似的资源：程序员如何学习底层技术?可以邮件订阅作者网站。

When your database outgrows simple optimizations, it's time to think bigger. Lift the Elephant goes beyond query tuning to reveal actionable strategies for scaling PostgreSQL, from partitioning to high-availability architectures. Built on lessons from scaling Hubstaff, this is your playbook for navigating the challenges of database growth.

Learn how real databases work by following this practical guide to building your own in a programming language of your choice.Build a language from scratch- Create an interpreter that can parse, type check and run SQL queries. Start with running simple queries and build up to more complex ones.Learn SQL (the fun way) - Gain a deeper understanding of SQL. Cover the order of execution of queries, how SQL uses ternary logic and the techniques that databases use to join and group data efficiently. Compare your implementation with databases such as PostgreSQL, MySQL, SQLite and DuckDB.Improve as a programmer- The perfect project to practice how to structure and refactor code as you grow the feature set of your database server. The 200+ included test cases provide a safety net for refactoring your code, giving you freedom to experiment. Learn computer science topics including creating a recursive descent parser, building a type checker and implementing iterators.

Stop treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

Explore the power of Rust with "Rust Projects: Write a Redis Clone". This hands-on guide takes you through building a Redis-inspired database from the ground up, introducing key programming concepts like TCP connections, the RESP protocol, and concurrency. Following the CodeCrafters challenge, this book gradually builds your skills, making complex topics accessible. Whether you're new to Rust or looking to deepen your understanding, this project-based journey offers practical, real-world insights into modern systems programming. The book contains 40% discount code for CodeCrafters.io!