Benchmark comparing performance of jOOQ's MULTISET emulation vs. other approaches for nesting to-many relationships in SQL queries.
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Explains how to use SQL's NATURAL FULL JOIN to concatenate data from unrelated tables, like actor, customer, and staff, into a single result set.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
A guide to creating and using PostgreSQL triggers for automating data processing tasks, covering types, functions, and examples.
Introducing dsq, a command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other data file formats.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
An appreciation of PostgreSQL's power, reliability, comprehensive documentation, and disciplined engineering team after 25+ years of development.
A product manager discusses five essential skills for product and leadership roles: SQL, Excel, clear communication, storytelling, and prioritization.
A guide to using SQL for efficient data analysis, comparing performance with pandas and demonstrating advanced SQL techniques.
A technical benchmark of the Hydrolix analytics platform on AWS, testing its performance on a 1.1 billion row NYC taxi dataset.
A technical guide on adding LIMIT and OFFSET clause support to the gosql SQL database engine built in Go.
A data scientist's 2020 review, focusing on machine learning projects for healthcare, including mining COVID-19 EHR data and brain signal analysis.
A guide to implementing a simple anomaly detection system using only SQL and basic statistics, aimed at developers.
A guide to translating NHibernate LINQ queries to SQL without executing them, using a custom ToSql() extension method for debugging.
A technical guide on configuring NHibernate to log generated SQL statements to ASP.NET Core's built-in logging system using interceptors.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
Explains how to use Django models, managers, and QuerySets to interact with a database, covering creation, filtering, and deletion.
A guide on using PostgreSQL's FOR loop to generate test data for development and UI testing.
A brief introduction to using Dapper, a popular micro-ORM, for database operations in ASP.NET Core applications.
