A developer shares their experience and lessons learned from giving a technical talk at the online EuroPython 2020 conference.
A talk on implementing full-text search using only Django and PostgreSQL, presented at EuroPython 2020.
A guide on using PostgreSQL's FOR loop to generate test data for development and UI testing.
Introducing DBCore, a tool that generates a complete REST API and admin interface from a PostgreSQL or MySQL database schema.
A guide to automating PostgreSQL database backups using scripts and AWS S3 for secure, reliable cloud storage.
A guide on using pg_dump and pg_restore to backup and restore a PostgreSQL database, crucial for data protection in DevOps.
Tutorial on configuring a Django blog application to use PostgreSQL for production, including installation, setup, and fixture management.
A step-by-step tutorial for installing and setting up PostgreSQL on MacOS using Homebrew, including database creation and server management.
A technical guide for upgrading PostgreSQL from version 11 to 12 on Ubuntu 20.04, including commands and troubleshooting steps.
A tutorial on using the Fluent ORM framework with PostgreSQL in Vapor 4 for server-side Swift development.
A beginner's tutorial on setting up PostgreSQL for use with the Fluent 4 ORM in Vapor, covering installation, user/database creation, and basic management.
A tutorial on building a minimal REST API in Java using Jersey and JOOQ with PostgreSQL, avoiding heavy reflection.
A guide on using a pre-built Django template to quickly set up a Django application with features like user authentication, Docker, and testing.
A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
An interview discussing the importance of PostgreSQL extensions and how they transform it from a relational database into a versatile data platform.
A tutorial on setting up a minimal Django REST API microservice using Docker, PostgreSQL, and Gunicorn for development.
A talk on building a web service with Django and PostgreSQL to manage and aggregate YouTube channel revenue data via Google's APIs.
A guide to tuning PostgreSQL's autovacuum feature, covering internals, configuration, and providing a sample Docker setup.
Announcement and review of 'The Art of PostgreSQL', a book teaching how to replace complex application code with efficient SQL queries.
A technical guide on using SQL GROUP BY with window functions to retrieve the first or last value in a group, using a PostgreSQL event table example.
