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.
Build AI agents that truly remember, reason, and act—entirely on user devices. Move beyond prompt engineering to create autonomous systems with graph-based memory using SQLite and LibSQL. Learn to implement hypergraphs, metagraphs, and vector search for privacy-first AI that scales to millions of entities. From personal knowledge graphs to production mobile apps, master the three pillars of agent autonomy: tools, memory, and reasoning. Real code, working examples, battle-tested in production. The future of AI is local, private, and in your hands.
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.
Dies ist die top-aktuelle Version dieses Fachbuchs vom 04.03.2026 auf dem Stand .NET 10.0.3 und Entity Framework Core 10.0.3.
Transform chaos into order with Phoenix Product Codex: a thrilling, real-world journey of building a production-ready REST API for product data management using Elixir and Phoenix, born from the requirements of a family-run business facing a government mandate for electronic invoicing. Learn to craft and deploy a thoughtfully-designed, business-driven solution that already serves as the Single Source of Truth for two companies, while also mastering domain modeling, database design, and more in the process. No toy examples or databases here, but actual software that delivers real impact.
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.
Libérez la puissance de DuckDB pour l’analytique géospatiale moderne. Ce guide pratique aide les professionnels du SIG à maîtriser une gestion efficace des données spatiales, en transformant d’énormes jeux de données réels en informations exploitables grâce au SQL, à Python et à l’extension spatiale de DuckDB. Une édition papier couleur est disponible sur Amazon.
Learn how to install, configure, and use the MonetDB analytical database on Ubuntu Linux. This practical guide walks through real examples and command-line workflows, helping you quickly understand how MonetDB works and how to use it effectively for analytical SQL workloads.
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.
Most organizations do not suffer from a lack of data. They suffer from late data.Mobile and no-code platforms have changed how quickly truth enters enterprise systems—but many experienced IT leaders still feel something important has shifted.This book explains what actually changed, what did not, and how to extend enterprise discipline safely into modern mobile workflows.
"It’s 3 AM, your database just hit 500 connections, and everything has ground to a halt. Do you know why?"Most database outages aren't mysterious—they are architectural. Stop treating PostgreSQL as a black box and start understanding the mechanical "why" behind the engine. PostgreSQL Internals Mastery: Volume I is a modular deep dive designed for senior engineers who need to bridge the gap between writing SQL and architecting high-performance systems. From the process-per-connection model to the groundbreaking Asynchronous I/O (AIO) features of PostgreSQL 18, learn the internals that separate database architects from administrators. Don't just tune knobs; understand the machine.
Learn graph databases the hands-on way — no servers, no setup, no fluff.Hands-On LadybugDB Cypher takes you from your first MATCH to complex recursive queries, shortest-path algorithms, and real-world AI agent graphs — all running locally in under a minute. 27 chapters. One evolving project. Every Cypher concept you need. Start querying graphs today.
The software that's managing your data shouldn't be a mystery. MySQL is the most popular open source database and powers WordPress, Drupal, Joomla, Magento and more. You don't have to be a professional database designer to understand and make use of its tools. MySQL Explained provides a clear and accessible step-by-step tutorial that will enable you to understand how your data is being stored and even design your own custom applications!
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!