DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Smart Search in PostgreSQL: How to Perform Fast and Accurate Searches with Full-Text Search and GIN Indexing

Smart Search in PostgreSQL: How to Perform Fast and Accurate Searches with Full-Text Search and GIN Indexing

18
Comments 10
4 min read
How simultaneously swapping unique IDs in Postgres

How simultaneously swapping unique IDs in Postgres

4
Comments
2 min read
Level 3: Building the Database Foundation with Rust + PostgreSQL

Level 3: Building the Database Foundation with Rust + PostgreSQL

Comments
1 min read
flyway implementation

flyway implementation

Comments
3 min read
Database Migration: Safely Managing Dev and Production Environments

Database Migration: Safely Managing Dev and Production Environments

Comments
4 min read
10 Common Supabase Security Misconfigurations (and How to Fix Them)

10 Common Supabase Security Misconfigurations (and How to Fix Them)

1
Comments
6 min read
SeaORM 2.0: New Entity Format

SeaORM 2.0: New Entity Format

1
Comments
9 min read
How to Backup and Restore a Single PostgreSQL Table with pg_dump

How to Backup and Restore a Single PostgreSQL Table with pg_dump

1
Comments
5 min read
BetterStructureSql - Clean Database Schema Dumps for Rails (Beta)

BetterStructureSql - Clean Database Schema Dumps for Rails (Beta)

8
Comments
5 min read
Database ID Design: Choosing ID Methods and Primary Key Strategies

Database ID Design: Choosing ID Methods and Primary Key Strategies

Comments
4 min read
DevPill 6 - SQLC: how to scaffold your database code

DevPill 6 - SQLC: how to scaffold your database code

Comments
1 min read
🧱 Lesson 5  - Working with PostgreSQL (Multi-Database Setup)

🧱 Lesson 5  - Working with PostgreSQL (Multi-Database Setup)

Comments
3 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Schema Design with Supabase: Partitioning and Normalization

Schema Design with Supabase: Partitioning and Normalization

1
Comments
5 min read
Top 5 Ways to Speed Up pg_dump on Large PostgreSQL Databases

Top 5 Ways to Speed Up pg_dump on Large PostgreSQL Databases

2
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.