A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
Datasette 1.0a32 bugfix release fixes INSERT...RETURNING queries and base_url issues for exploring and publishing data.
Datasette 1.0a32 bugfix release: fixes INSERT...RETURNING queries and base_url issues for the open-source data exploration tool.
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.
Guide on integrating Dremio data lakehouse with OpenAI Codex CLI for querying, building data apps, and generating analytics code.
A guide to integrating GitHub Copilot with Dremio's data platform to enable AI-assisted SQL generation, data pipeline creation, and application development.
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.
Argues against placing business logic in stored procedures, advocating for keeping it in the application layer for better maintainability and scalability.
A tutorial on using Dremio's AI_CLASSIFY SQL function to categorize data like customer sentiment and support tickets directly within a data lakehouse.
Tutorial on using Dremio's AI_COMPLETE SQL function to generate product summaries, marketing copy, and translations directly within a data pipeline.
Tutorial on using Dremio's AI_GENERATE SQL function to extract structured data from unstructured text like emails and contracts.
Explains how a semantic layer enforces data governance by embedding policies directly into the query path, ensuring consistent metrics and access control.
A SQL expert details the strategy for designing an interactive conference session on solving query performance differences between development and production databases.
