$ lexprog.com

// notes from an old coder -- php, databases, and the occasional rant

// viewing category: PostgreSQL

PostgreSQL tips & tricks

< back to all posts

[May 07, 2026] postgresql

PostgreSQL Full-Text: Custom Dictionaries

PostgreSQL Full-Text: Custom Dictionaries

read -->

[May 02, 2026] postgresql

PostgreSQL XML Data Handling

PostgreSQL XML Data Handling

read -->

[Apr 20, 2026] postgresql

PostgreSQL DISTINCT ON

PostgreSQL DISTINCT ON

read -->

[Apr 13, 2026] postgresql

PostgreSQL Backup and Recovery

PostgreSQL Backup: Tips & Tricks

read -->

[Apr 09, 2026] postgresql

PostgreSQL Extensions for Laravel

PostgreSQL Extensions: Tips & Tricks

read -->

[Mar 13, 2026] postgresql

PostgreSQL LATERAL Joins

PostgreSQL LATERAL Joins

read -->

[Mar 12, 2026] postgresql

PostgreSQL Connections and Pooling

PostgreSQL Connections: Tips & Tricks

read -->

[Mar 06, 2026] postgresql

PostgreSQL Arrays in Laravel

PostgreSQL Arrays in Laravel: Tips & Tricks

read -->

[Jan 18, 2026] postgresql

PostgreSQL Parallel Queries

PostgreSQL Parallel Queries

read -->

[Dec 30, 2025] postgresql

PostgreSQL CTEs: Recursive Queries

PostgreSQL CTEs: Recursive Queries

read -->

════════════════════════════════════════════════════════

<-- 1 2 3 4 5 -->

// showing 1-10 of 41 posts • page 1/5