A developer explores Transposit, a platform providing a SQL interface to interact with multiple APIs, and attempts to rebuild a complex GitHub bot using it.
A guide to optimizing Django dashboard performance using SQL grouping sets for advanced aggregation, including a cautionary note.
An article arguing that SQL is one of the most valuable and enduring technical skills across various roles like engineering and product management.
A guide to implementing a simple CQRS pattern using raw SQL and Domain-Driven Design (DDD) principles in a .NET Core REST API application.
Identifies three common ActiveRecord usage mistakes in Rails that cause unnecessary SQL queries and slow down application performance.
A database expert reviews their 2018 speaking engagements and blog output, focusing on Columnstore Indexes, Graph Databases, and Batch Execution Mode.
Explains a performance pitfall with Common Table Expressions (CTEs) in PostgreSQL versions 11 and earlier, showing how they can disable query optimization.
A reflection on the challenges and principles of organizing a truly independent tech conference, focusing on community over self-promotion.
Introducing an R package for complex survey analysis using SQL databases via dplyr/dbplyr, with a focus on hexagonal binning algorithms.
A technical guide on enabling and locating MySQL query logs for debugging and monitoring database activity.
Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.
Summary of major database trends in Fall 2017, including SQL's resurgence, cloud pricing wars, IBM's renaming controversy, and new releases.
A practical guide outlining essential tools, skills, and practice methods for beginners to start a career in data science.
Explores the various uses of the DISTINCT keyword in PostgreSQL, including DISTINCT ON, with practical SQL examples.
An overview of Postgres Foreign Data Wrappers (FDWs), explaining how to connect and query external data sources directly from PostgreSQL.
A technical guide on using Google BigQuery to analyze GitHub pull request data, including SQL queries for repository statistics.
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
A developer shares 10 essential PostgreSQL features and tips for 2016, including CTEs, performance tuning, and configuration.
A detailed overview of key new features in PostgreSQL 9.5, including Upsert, grouping sets, and pg_rewind.
Explores how MongoDB's BI Connector pushes SQL WHERE clauses and projections down to the database as an aggregation pipeline for efficient querying.
