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.
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 vom 04.03.2026 auf dem Stand .NET 10.0.3 und Entity Framework Core 10.0.3.
Built for the curious, this isn’t your average programming book—it’s nearly 500 pages of hands-on mentorship beyond coding, fusing core skills in Elixir, Ecto, and SQLite with business experience and R&D tenacity. Think of it as a $500 course distilled into one powerhouse resource, with tons of learning-by-doing, in a single project. Acquire hard skills in Elixir and database modeling with Ecto's migrations, changesets, and more, re-imagining a classic database that millions around the world have used before for learning. By fearlessly ditching the "happy path", this immersive, exploratory, memorable, project-based tutorial helps you confidently tackle real-world projects with Elixir and Ecto.
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.
"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.
This book offers a fantastic, hands-on approach to learning all about PostgreSQL's newest features, optimization techniques, and high availability solutions. It's perfect for database administrators of all experience levels!In this, book, you will discover workable answers to common problems, regardless of whether you are managing databases in simple localized settings or massive enterprise-level empires.
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!
Entwickler:innen haben heute eine Vielzahl von Optionen, wenn es um die Wahl einer Datenbank für ihre Anwendung geht. Dieses Buch gibt einen Überblick über Datenmodelle, Konzepte zur Skalierung und Betriebsformen – von relationalen Systemen über dokumenten- und graphbasierte Ansätze bis hin zu Zeitreihen- und Vektordatenbanken. Es bietet Hilfestellung bei der Auswahl und Einordnung für unterschiedliche Anwendungsszenarien.
Stop building fragile AI wrappers and start engineering production-ready SaaS architectures. Master the AI-native stack, from pgvector pipelines to secure multi-tenant deployments. Bridge the gap between a prototype and a scalable business with deep-dive engineering. The ultimate blueprint to build software that scales from user zero to one million.
‘Grip op data’ biedt een kennismaking met data gedreven werken, data management, databases en SQL. Het wordt aangeboden als combinatiepakket: dit leerboek, een online cursusomgeving en een databank met voorbeelden van datatoepassingen, datamodellen en data gedreven werkwijzen.
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.