Leanpub Header

Skip to main content

Filters

Category: "Databases"

Books

  1. Spatial Data Management with DuckDB
    From SQL Basics to Advanced Geospatial Analytics
    Qiusheng Wu

    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.

  2. Moderne Datenzugriffslösungen mit Entity Framework Core 10.0
    Datenbankprogrammierung / Objekt-Relationales Mapping mit C# in .NET 10.0
    Dr. Holger Schwichtenberg

    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.

  3. Code a database in 45 steps (Go)
    a series of test-driven small coding puzzles
    Lowram Eepson

    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.

  4. Gestión de Datos Espaciales con DuckDB
    Desde los Fundamentos de SQL hasta el Análisis Geoespacial Avanzado
    Qiusheng Wu

    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.

  5. Build Your Own Database in Go From Scratch
    From B+tree to SQL in 3000 lines
    build-your-own.org

    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.

  6. A visual guide for understanding Modern Data Pipelines Testing Techniques

  7. Lift the Elephant
    Scaling PostgreSQL Beyond Query Optimization
    Alex Yarotsky

    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.

  8. Vector Databases
    powering modern AI applications
    Jitin Kayyala

    Building a chat feature over your product docs? You need a vector database.Adding recommendations to your app? Vector database.Searching 100 million images by visual similarity? Definitely a vector database.Yet most engineers stumble into these projects unprepared. They don't understand the trade-offs between IVF, HNSW, and Product Quantization. They pick the wrong similarity metric. They scale the wrong way.This book is the missing manual. It covers:The mathematics of embeddings and why they workHow to choose the right algorithm for your latency and accuracy constraintsDeep dives into Pinecone, Milvus, Weaviate, Qdrant, and ChromaBuilding production RAG systems that actually workIndustry case studies from Spotify to JPMorgan Chase20+ ready-to-run recipes for common scenarios

  9. Rust Projects - Write a Redis Clone
    Explore asynchronous programming with the actor model using Rust and Tokio
    Leonardo Giordani

    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!

  10. Thinking in PostgreSQL
    A field guide to PostgreSQL for MySQL engineers
    Nick Vyzas

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

  11. Build a Database Server
    Learn how real databases work by following this practical guide to building your own
    Chris Zetter

    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.

  12. No Description Available
  13. No Description Available
  14. Master the essential developer tools and techniques in Business Central! This comprehensive guide covers five critical MB-820 exam topics: Try Functions and Collectible Errors for robust error handling, RAD.json for rapid development cycles, Snapshot Debugging for production troubleshooting, Entitlements and Permission Sets for security architecture, and extending Application Areas for customized user experiences. Learn from real Microsoft code examples and prepare to pass your certification with confidence.

  15. Master data presentation and analysis in Business Central! This comprehensive guide covers everything from report objects and layouts (RDLC, Word, Excel) to report extensions for customization without modifying base code. Learn about queries for optimized data retrieval, processing-only reports, request pages, and the report substitution pattern. Dive deep into real-world examples from the Base Application with practical exercises. Whether you're preparing for MB-820 certification or building professional reporting solutions, this is your definitive reference for Business Central reporting.