Announcement and review of 'The Art of PostgreSQL', a book teaching how to replace complex application code with efficient SQL queries.
Announcement for SQLSaturday Lisbon 2019 and Porto 2019, including dates, call for speakers, and workshop topics.
A technical guide on using SQL GROUP BY with window functions to retrieve the first or last value in a group, using a PostgreSQL event table example.
Explains how to correctly use Dapper's IN clause with collection parameters to avoid SQL syntax errors from double parentheses.
A technical guide covering PostgreSQL basics, including schemas, user/role management, and SQL commands for permissions.
A workaround technique for exploding arrays in ksqlDB using manual indexing, simulating EXPLODE/UNNEST functionality.
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 technical guide exploring stream-stream joins in KSQL using orders and shipments data, covering setup, aggregations, and join implementation.
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.
A quick reference guide for using the KSQL REST API, including curl examples for queries, statements, and runtime statistics.
Identifies three common ActiveRecord usage mistakes in Rails that cause unnecessary SQL queries and slow down application performance.
Explains the importance of transactional DDL in SQL for safe and reliable database schema migrations during application upgrades.
A developer continues their Leetcode streak, solving problems in Python and analyzing performance, including sorting arrays by parity and robot movement.
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.
