Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
An introduction to LiteDB, a lightweight, serverless NoSQL document database for .NET, exploring its features, use cases, and differences from SQL databases.
Explains pagination concepts, formulas, and implementation in C#/SQL, comparing it to infinite scrolling for efficient data loading.
Explains how to use EF Core Query Splitting to solve performance issues like Cartesian Explosion in database queries.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
A tutorial on implementing full-text search in Django applications using PostgreSQL's built-in search capabilities.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
A guide on using jOOQ and Testcontainers to write integration tests for database stored procedures in Java, replacing manual JDBC calls.
Explains why offset-based pagination is inefficient for large datasets and introduces faster cursor/keyset pagination techniques for server-side APIs.
Explains how to use jOOQ to call stored procedures from Java, highlighting benefits over raw JDBC for type safety and maintainability.
A technical guide explaining how to use the $sort stage in MongoDB's aggregation pipeline, covering single/multi-field sorting, case sensitivity, and memory limits.
Analysis of the new DynamoDB paper, covering product-level insights and technical improvements for the managed NoSQL database service.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
Discusses a bug where DatabaseMailUserRole prevents SQL Server from starting after patching, based on MVP and customer reports.
Explores common concurrency challenges in software development, using a URL shortener example to demonstrate solutions with minimal locking.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at PyCon Italia 2022.
Explores various data fetching methods in jOOQ, including iterable, single-record, and resourceful fetching techniques.
A former Heroku PM shares the story and vision behind Heroku Postgres, reflecting on its development and future possibilities.
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Benchmark comparison of SQLite in Go using the cgo-based mattn/go-sqlite3 package versus the pure-Go modernc.org/sqlite translation.
