LATERAL is Your Friend to Create Local Column Variables in SQL
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
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.