Skip to content

DEV Community

# postgres

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Oct 14 '19

Rails: migration: Adding a unique Index and deleting Duplicates

#rails #postgres #uniqueindex

4 min read

zchtodd

Oct 14 '19

#SQL30 Day 12: Greatest Discount

#challenge #sql #database #postgres

3 min read

zchtodd

Oct 13 '19

#SQL30 Day 11: Soft Deletes

#challenge #sql #database #postgres

3 min read

Oct 12 '19

Manipulating arrays with PostgreSQL

#postgres #data #sql #database

3 min read

zchtodd

Oct 12 '19

#SQL30 Day 10: Random Sampling

#challenge #sql #database #postgres

3 min read

Oct 12 '19

Generate dummy data with Postgres

#postgres #database #sql #data

2 min read

zchtodd

Oct 10 '19

#SQL30 Day 8: Deleting Duplicates

#challenge #sql #database #postgres

3 min read

Oct 8 '19

Upgrading PostgreSQL

#opennms #postgres #upgrade

7 min read

Darko Zivanovic for DEVersity

Oct 8 '19

Scaling Postgres DB for better performance - per aspera ad Citus

#database #postgres #rails #scalability

8 min read

zchtodd

Oct 8 '19

#SQL30 Day 6: Supermarket Sales

#challenge #sql #database #postgres

3 min read

Oct 7 '19

Faster CSV export with Django & Postgres

#django #postgres #csv #orm

2 min read

ScaleGrid for ScaleGrid

Oct 7 '19

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

#postgres #database #sql #cloud

11 min read

zchtodd

Oct 7 '19

#SQL30 Day 5: Hierarchies

#challenge #sql #database #postgres

3 min read

zchtodd

Oct 5 '19

#SQL30 Day 3: Weather Data

#challenge #sql #database #postgres

5 min read

Oct 3 '19

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

#ruby #postgres #rails #search

8 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.