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.
Explores whether setting JDBC Statement.setFetchSize(1) for single-row queries improves performance, with benchmark results across databases.
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 guide to quickly install ClickHouse on macOS using a one-line shell command and demonstrates its use for converting CSV data to Parquet.
Explains performance issues with OFFSET in database pagination and introduces keyset pagination as a more efficient alternative.
Explains jOOQ's API for managing nested transactions, comparing it to JDBC defaults and Spring's @Transactional behavior.
A talk on leveraging PostgreSQL's advanced features within Django web framework for more powerful database-driven applications.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
A talk summary on leveraging PostgreSQL's advanced features within Django projects, presented at PyCon Sri Lanka 2022.
Author previews their upcoming SQL Managed Instance presentations at the SQLBits 2022 conference, highlighting new features and demos.
