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.
Mindless Meals - A JavaScript and Rails API App

Mindless Meals - A JavaScript and Rails API App

41
Comments 10
4 min read
Performance Review: AWS RDS Postgres vs Digital Ocean Postgres

Performance Review: AWS RDS Postgres vs Digital Ocean Postgres

8
Comments
3 min read
The True Guide to True and False in PostgreSQL

The True Guide to True and False in PostgreSQL

10
Comments
2 min read
Using SQlite or PostgreSQL with Express

Using SQlite or PostgreSQL with Express

6
Comments
9 min read
Is the database working as expected?

Is the database working as expected?

90
Comments 22
1 min read
Ora2pg - a free tool for Oracle migrate to Postgres

Ora2pg - a free tool for Oracle migrate to Postgres

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

Setting up distributed database architecture with postgresql

39
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
PostgreSQL Connection Pooling: Part 1 – Pros & Cons

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

51
Comments
6 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
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

17
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

13
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
Faster CSV export with Django & Postgres

Faster CSV export with Django & Postgres

10
Comments 1
2 min read
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

7
Comments
11 min read
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

6
Comments 1
3 min read
#SQL30 Day 3: Weather Data

#SQL30 Day 3: Weather Data

20
Comments 4
5 min read
Keep it simple stupid: Building full text search across all your tools with Postgres

Keep it simple stupid: Building full text search across all your tools with Postgres

83
Comments 6
8 min read
#SQL30 Day 1: Wildfires

#SQL30 Day 1: Wildfires

46
Comments 8
2 min read
#SQL30 Day 2: Stock Price Variance

#SQL30 Day 2: Stock Price Variance

8
Comments 5
3 min read
How to upgrade PostgreSQL from 11 to 12

How to upgrade PostgreSQL from 11 to 12

27
Comments 5
2 min read
PostgreSQL Foreign Data Wrappers

PostgreSQL Foreign Data Wrappers

19
Comments
5 min read
Tricksy Little Postgres Query Planner

Tricksy Little Postgres Query Planner

14
Comments 2
4 min read
Which Is the Best PostgreSQL GUI? 2019 Comparison

Which Is the Best PostgreSQL GUI? 2019 Comparison

12
Comments 1
12 min read
NodeJS & PostgreSQL: ORM Overview

NodeJS & PostgreSQL: ORM Overview

41
Comments 2
2 min read
NodeJS & PostgreSQL: How To Connect Our Database To Our Simple Express Server (with an ORM)

NodeJS & PostgreSQL: How To Connect Our Database To Our Simple Express Server (with an ORM)

39
Comments 3
3 min read
NodeJS & PostgreSQL: How To Connect Our Database To Our Simple Express Server (without an ORM)

NodeJS & PostgreSQL: How To Connect Our Database To Our Simple Express Server (without an ORM)

23
Comments
3 min read
PostgreSQL: How To Connect Two Tables (Joins)

PostgreSQL: How To Connect Two Tables (Joins)

11
Comments
3 min read
PostgreSQL: How To Update & Delete Data

PostgreSQL: How To Update & Delete Data

7
Comments
2 min read
PostgreSQL: How To Create Some Basic Queries

PostgreSQL: How To Create Some Basic Queries

10
Comments
3 min read
PostgreSQL: How To Read From & Write To Our Table

PostgreSQL: How To Read From & Write To Our Table

8
Comments
2 min read
PostgreSQL: How To Create Our First Table

PostgreSQL: How To Create Our First Table

20
Comments
2 min read
PostgreSQL: How To Setup Our Installed PostgreSQL

PostgreSQL: How To Setup Our Installed PostgreSQL

12
Comments
2 min read
How to create a React Native app with PostgreSQL and GraphQL: Part 1

How to create a React Native app with PostgreSQL and GraphQL: Part 1

78
Comments
11 min read
PostgreSQL: What is it & How To Install it

PostgreSQL: What is it & How To Install it

29
Comments
1 min read
Tricks for Postgres and Docker that will make your life easier

Tricks for Postgres and Docker that will make your life easier

39
Comments
4 min read
Handling IP addresses using PostgreSQL

Handling IP addresses using PostgreSQL

5
Comments
1 min read
Dynamically generating SQL queries using Node.js

Dynamically generating SQL queries using Node.js

122
Comments 26
6 min read
How to store large JSON in PostgreSQL with Rails Attributes API

How to store large JSON in PostgreSQL with Rails Attributes API

10
Comments 2
1 min read
Solving Issues in PostgreSQL. (Lessons in Debugging)

Solving Issues in PostgreSQL. (Lessons in Debugging)

13
Comments 3
4 min read
Managing High Availability in PostgreSQL – Part III: Patroni

Managing High Availability in PostgreSQL – Part III: Patroni

11
Comments
17 min read
So you put an escaped string into a JSON column...

So you put an escaped string into a JSON column...

37
Comments 9
1 min read
Using Postgres Enum Type in Rails

Using Postgres Enum Type in Rails

41
Comments 5
3 min read
Postgres Trigram indexes VS Algolia

Postgres Trigram indexes VS Algolia

21
Comments 2
3 min read
Dump and Restore PostgreSQL Tables

Dump and Restore PostgreSQL Tables

9
Comments
2 min read
Getting Started with Sequelize and Postgres

Getting Started with Sequelize and Postgres

108
Comments 28
6 min read
Charm City Postgres

Charm City Postgres

5
Comments 1
1 min read
loading...