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.
Picking a baby name with PostgreSQL® and FuzzyStrMatch

Picking a baby name with PostgreSQL® and FuzzyStrMatch

Reactions 1 Comments
6 min read
Python ETL: Creating and automating a pipeline from Mysql to postgresql

Python ETL: Creating and automating a pipeline from Mysql to postgresql

Reactions 3 Comments
5 min read
In One Minute : PostgreSQL

In One Minute : PostgreSQL

Reactions 5 Comments
1 min read
Exact match search deeply nested objects - PostgreSQL

Exact match search deeply nested objects - PostgreSQL

Reactions 2 Comments
2 min read
PostgreSQL unit-11

PostgreSQL unit-11

Comments
1 min read
Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

Reactions 7 Comments
12 min read
Recover and replace win1252 content to utf-8 for a PostgreSQL database

Recover and replace win1252 content to utf-8 for a PostgreSQL database

Comments
1 min read
YugabyteDB Skip Scan aka Loose Index Scan on compound index

YugabyteDB Skip Scan aka Loose Index Scan on compound index

Reactions 1 Comments
5 min read
How to re-sync auto-increment in PostgreSQL

How to re-sync auto-increment in PostgreSQL

Reactions 5 Comments
1 min read
How to find the delta between rows in PostgreSQL