A guide on integrating Asyncpg with FastAPI and Air for direct PostgreSQL database access, bypassing heavier ORMs like SQLAlchemy.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
A detailed comparison of Django ORM features across PostgreSQL, SQLite, MariaDB, MySQL, and Oracle databases, highlighting support and limitations.
A guide on integrating PostgreSQL stored procedures and functions with EF Core for complex queries and performance-critical operations.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
A guide to using a PowerShell script with Ollama and the Qwen 2.5 model to perform AI-assisted code reviews on PostgreSQL database migration scripts.
PostgreSQL 19 adds new random() functions for generating random dates and timestamps, useful for creating test data.
Explores how PostgreSQL and its extensions can replace many modern tech stack components like Redis, Elasticsearch, and Kafka, simplifying architecture.
Demonstrates a 6x speedup for analytics queries using EDB Postgres Distributed's new analytics engine compared to the standard Postgres engine.
A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
A guide to setting up asynchronous PostgreSQL operations with SQLModel and FastAPI, including code examples for async engines and sessions.
A technical guide on setting up a single-node EDB Postgres Distributed (PGD) cluster on Ubuntu, including installation and verification steps.
Explains the difference between restart_lsn and confirmed_flush_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Explains the difference between confirmed_flush_lsn and restart_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Explains a new PostgreSQL 19 feature that displays Memoize planner estimates in EXPLAIN output to help debug query plan choices.
A tutorial on automating PostgreSQL performance debugging in Rails using LLMs and the Model Context Protocol (MCP) with a Slack bot interface.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
A talk on implementing semantic search in a web service using Python, Django, PostgreSQL, and open-source AI tools, presented at EuroPython 2025.
Best practices for managing PostgreSQL replication slots to prevent WAL bloat and ensure reliable CDC pipelines in production.
Best practices for managing PostgreSQL replication slots to prevent WAL bloat and ensure reliable CDC pipelines in production.
