#sql (27)
- Mastering Dolt: A Zero-to-Advanced Guide to Version-Controlled SQL
Embark on a comprehensive journey to master Dolt, the Git-for-data SQL database, from foundational concepts to advanced production practices, with practical steps and engaging challenges.
- Introduction to Dolt: Git for Your Data
Discover Dolt, the world's first Git-compatible SQL database. Learn to version control data like code, track changes, and collaborate efficiently.
- Setting Up Dolt and Your First Data Commit
Learn to install Dolt, initialize your first version-controlled SQL database, and make your initial data commit, understanding the core Git-for-Data paradigm.
- Tracking Data Changes: Diffs, Logs, and History
Explore how Dolt tracks every data and schema change. Learn to use `dolt diff`, `dolt log`, and time travel queries to audit, debug, and analyze your database's complete history.
- Time Travel Queries and Data Rollbacks
Master Dolt's time travel queries and data rollback features to navigate database history, audit changes, and safely undo mistakes.
- Resolving Data Merge Conflicts
Learn how to detect, understand, and resolve data merge conflicts in Dolt, leveraging its Git-for-Data capabilities for robust database version control.
- Branching and Merging Data: Collaborative Workflows
Explore Dolt's Git-for-Data branching and merging capabilities for collaborative database development, including conflict resolution and practical PostgreSQL-style data examples.
- Collaborative Data Management with Dolt Remotes and DoltHub
Learn how to enable collaborative data management with Dolt remotes and DoltHub, mastering data synchronization, sharing, and team workflows for versioned SQL databases.
- Evolving Your Schema: Versioned Migrations
Learn how Dolt revolutionizes database schema evolution with Git-like versioning, branching, and merging for robust, collaborative, and auditable migrations.
- Project: Building a Versioned Inventory System with Doltgres
Learn to build a versioned inventory system using Doltgres, applying Git-for-Data concepts like commits, branching, and time travel to PostgreSQL-style business data for auditing and collaboration.
- Dolt Under the Hood: Architecture and Performance
Dive deep into Dolt's unique architecture, understanding its Git-like storage model, SQL engine, and how these impact performance and scalability for versioned data.
- Advanced Dolt Workflows for Analytics, AI/ML, and Debugging
Readers will learn to apply Dolt's advanced features for reproducible data analytics, versioning AI/ML datasets, and debugging complex data changes across environments.
- Project: Enterprise Financial Transactions Platform
Build a production-grade financial transactions platform using Dolt for version control, audit trails, and collaborative data management, integrating advanced Git-for-Data workflows and CI/CD.
- Implement Git-like Version Control in SQL with Dolt
Learn to apply Git-like version control, branching, and merging to SQL databases using Dolt, mastering schema evolution and production practices.
- Why Your LLM Doesn't Always Need a New Vector Database
Learn how many AI systems can effectively use existing traditional databases for better data integrity, cost-efficiency, and operational familiarity.
- Stoolap Practical Field Guide
Embark on a comprehensive journey to master Stoolap, a modern embedded SQL database, from the ground up, with practical steps and engaging challenges for developers and data engineers.
- Accelerating Queries with Parallel Execution
Discover how Stoolap leverages parallel execution to significantly accelerate complex SQL queries, enhancing performance for both transactional and analytical workloads in embedded applications.
- Understanding Stoolap's Cost-Based Query Optimizer
Learn how Stoolap's cost-based query optimizer intelligently plans queries, interpret EXPLAIN output, and design schemas to achieve optimal database performance.
- Build a Hybrid OLTP/OLAP Analytics Dashboard with Stoolap
Readers will learn to build an analytics dashboard leveraging Stoolap's HTAP features for real-time data ingestion and complex analytical queries.
- Setting Up Your Stoolap Development Environment
Get started with Stoolap by setting up your Rust development environment, adding Stoolap as a dependency, and running your first embedded SQL queries.
- Stoolap's Storage Engine and Query Pipeline Internals
Understand Stoolap's storage engine, MVCC, and query pipeline to design efficient schemas and write better queries for OLTP, OLAP, and vector search.
- Stoolap: Define, Query, and Manage Data with Basic SQL
You will understand Stoolap's relational data model and apply fundamental SQL operations to define, manipulate, and query data.
- Welcome to Stoolap: A New Generation Embedded Database
Discover Stoolap, a modern embedded SQL database built with Rust, and learn how its unique features like MVCC, parallel execution, and vector search redefine embedded data management.
- Database Query Optimization & Concurrency Control
Learn to diagnose slow database queries, apply indexes, understand transaction isolation, and mitigate concurrency issues for improved application performance.
- Project: Optimizing a Database Table Column
Learn how to optimize a database table column using OpenZL's format-aware compression in this step-by-step tutorial.
- Data Governance and Security with Unity Catalog
Learn how to use Unity Catalog for centralized data governance and security on Databricks.
- Liquibase Learning Guide: From Beginner to Expert
Learn Liquibase from beginner to expert, covering database change management with practical examples and best practices.