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.
A tutorial on using the $group stage in MongoDB's aggregation pipeline, covering distinct grouping, multiple fields, and accumulator functions with practical examples.
A Microsoft engineer reviews their 2021 professional year, highlighting blogging and presentations on Azure SQL Managed Instance and tech conferences.
A guide to using the $project stage in MongoDB's aggregation pipeline, covering field inclusion, exclusion, and array operations.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at Pyjamas Conf 2021.
Microsoft PM announces a series of public presentations on Azure SQL Managed Instance, covering new features, HA/DR, performance, and monitoring.
An appreciation of PostgreSQL's power, reliability, comprehensive documentation, and disciplined engineering team after 25+ years of development.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at EuroPython 2021.
