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.
Is the database working as expected?

Is the database working as expected?

90
Comments 22
1 min read
Using SQlite or PostgreSQL with Express

Using SQlite or PostgreSQL with Express

6
Comments
9 min read
Setting up distributed database architecture with postgresql

Setting up distributed database architecture with postgresql

41
Comments 1
6 min read
📚 Awesome links from dev.to and around the web #2

📚 Awesome links from dev.to and around the web #2

44
Comments
2 min read
Yak Shaving My Way To Hacktoberfest - Day 2

Yak Shaving My Way To Hacktoberfest - Day 2

6
Comments
7 min read
Ora2pg - a free tool for Oracle migrate to Postgres

Ora2pg - a free tool for Oracle migrate to Postgres

8
Comments 1
2 min read
PostgreSQL Connection Pooling: Part 1 – Pros & Cons

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

51
Comments
6 min read
#SQL30 Day 16: Dev Badges

#SQL30 Day 16: Dev Badges

7
Comments
4 min read
Postgres, Docker and Windows

Postgres, Docker and Windows

8
Comments 1
2 min read
A simple script for Postgres database export and import

A simple script for Postgres database export and import

6
Comments
2 min read
Yum Install Postgres 11 client

Yum Install Postgres 11 client

6
Comments
1 min read
#SQL30 Day 14: UFO Sightings

#SQL30 Day 14: UFO Sightings

7
Comments
2 min read
How to query with PostgreSQL wildcards like a Pro

How to query with PostgreSQL wildcards like a Pro

37
Comments 4
10 min read
CRUD application with Express and PostgresSQL in 10 steps

CRUD application with Express and PostgresSQL in 10 steps

8
Comments 2
28 min read
Rails: migration: Adding a unique Index and deleting Duplicates

Rails: migration: Adding a unique Index and deleting Duplicates

18
Comments 1
4 min read
#SQL30 Day 12: Greatest Discount

#SQL30 Day 12: Greatest Discount

6
Comments
3 min read
Creating indexes in PostgreSQL isn't always idempotent

Creating indexes in PostgreSQL isn't always idempotent

7
Comments
1 min read
#SQL30 Day 11: Soft Deletes

#SQL30 Day 11: Soft Deletes

8
Comments
3 min read
Manipulating arrays with PostgreSQL

Manipulating arrays with PostgreSQL

15
Comments 2
3 min read
#SQL30 Day 10: Random Sampling

#SQL30 Day 10: Random Sampling

7
Comments 1
3 min read
Generate dummy data with Postgres

Generate dummy data with Postgres

6
Comments 2
2 min read
#SQL30 Day 8: Deleting Duplicates

#SQL30 Day 8: Deleting Duplicates

9
Comments
3 min read
Upgrading PostgreSQL

Upgrading PostgreSQL

8
Comments
7 min read
Scaling Postgres DB for better performance - per aspera ad Citus

Scaling Postgres DB for better performance - per aspera ad Citus

13
Comments 1
8 min read
#SQL30 Day 6: Supermarket Sales

#SQL30 Day 6: Supermarket Sales

6
Comments 1
3 min read
loading...