A technical guide for upgrading PostgreSQL from version 14 to 15 on Ubuntu 23.04, including commands and troubleshooting steps.
A talk on implementing full-text search in Django using only PostgreSQL, presented at PyCon US 2023.
A tutorial on converting flat data into hierarchical structures using SQL, Java, and the jOOQ library's new features.
A talk on leveraging PostgreSQL's advanced features within Django web framework for more powerful database-driven applications.
A technical guide on importing and visualizing FlixBus's European GTFS transit data in PostgreSQL using pgRouting for route planning.
Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.
A technical guide on using ClickHouse to export PostgreSQL data to Parquet format for faster loading into Google BigQuery.
Investigates unexpected WAL growth in an idle Postgres database due to an inactive replication slot, with analysis and solution.
Investigates unexpected WAL growth and disk space consumption in an idle Postgres database due to an inactive logical replication slot.
![Ultimate Guide: How To Use Prisma With NestJS [2022]](https://alldevblogs.blob.core.windows.net/thumbs/article-a00d05aa41e9-full-b5a8fe54.webp)
A step-by-step tutorial on integrating Prisma ORM with a NestJS backend, including database setup, CRUD operations, and testing.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
A talk on implementing full-text search using Django and PostgreSQL, avoiding complex external search engines.
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.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
A talk on leveraging PostgreSQL's advanced features within Django projects, presented at PyCon Italia 2022.
A technical guide on extracting Monaco's road network from OpenStreetMap, importing it into PostgreSQL/PostGIS, and rendering it with a tile server.
A tutorial on building a distributed PostgreSQL proof-of-concept using external libraries for SQL parsing, wire protocol, Raft consensus, and storage.
Explores efficient database strategies for fetching large view counts on social platforms, avoiding costly SELECT COUNT(*) operations.
