A quote from D. Richard Hipp about how SQL replaced COBOL programmers for data queries, changing programming jobs.
A developer shares Django features they enjoy while building backend-focused websites with SQL and HTML, including query builders and template filters.
Explores active analytics loops for AI agents that proactively monitor, investigate, and act on data anomalies beyond passive chat.
Techniques for achieving partition pruning in PostgreSQL when filtering by non-partition key columns.
A 2026 playbook for migrating proprietary data warehouses to open lakehouses using zero-copy metadata translation and staged modernization.
How to speed up test suites by avoiding SQL migrations in tests, achieving a 2x performance boost.
Explores how ClickHouse powers real-time analytics for AI agents, with ingestion patterns, event loop architecture, and production use cases.
A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
Troubleshooting a GraphQL deployment error in Microsoft Fabric caused by mismatched stored procedure result sets.
Datasette 1.0a32 bugfix release: fixes INSERT...RETURNING queries and base_url issues for the open-source data exploration tool.
Datasette 1.0a32 bugfix release fixes INSERT...RETURNING queries and base_url issues for exploring and publishing data.
Explains why joining tables across modules in a modular monolith creates hidden database coupling, undermining architecture.
Explores how dbt Fusion, a Rust-based rewrite of dbt Core, transforms analytics engineering by treating SQL as first-class code with AST parsing and static analysis.
A developer explains how Claude Code convinced them to simplify SQL JOINs by moving filters from ON to WHERE clauses for better readability.
Explains how to simplify ANTI JOIN queries using jOOQ syntax and implicit join paths.
Explains why JOIN USING in SQL can cause errors when schemas evolve, recommending JOIN ON for production queries.
Explains Apache Iceberg metadata tables for querying table internals using SQL, covering snapshots, files, manifests, partitions, and practical use cases.
Learn how to fetch data from Datasette into Google Sheets using importdata(), named functions, and Google Apps Script.
A daily tech reading list covering SQL's resurgence, AI agent productivity, CI/CD at scale, Go for backend, and more industry insights.
A guide to connecting Dremio's data lakehouse platform with Claude Code, enabling the AI coding agent to query live data and build data applications.
