Popular Postgresql Programming Tips
Hierarchical data in postgres
Chris Farmiloe
·
4 responses
·
postgres, postgresql, ltree
Start and Stop PostgreSQL manually on Mac OS X
Carlo Mallone
·
0 responses
·
postgresql, postgres, server
Use IN instead of ANY in PostgreSQL
Michał Czyż
·
6 responses
·
performance, postgresql
Rails 4 & the PostgreSQL Array data type
Stuart Liston
·
11 responses
·
active record, postgres, array, postgresql
Things I learned while writing a Dockerfile
Murphy Randle
·
7 responses
·
tip, sudo, gotcha, postgresql
Install PostgreSQL 9.2 on OS X Mountain Lion
Phil Cohen
·
16 responses
·
ruby, rails, osx, macports
Make postgres default to UTF8
katy lavallee
·
2 responses
·
postgresql
Backup and restore a postgresql database using commandline
Saji Nediyanchath
·
0 responses
·
backup, restore, postgresql
PostgreSQL with docker on OS-X
eranga bandara
·
0 responses
·
osx, postgresql, boot2docker, docker
Dump PostgreSQL without owner and privileges
Bartłomiej Danek
·
0 responses
·
postgresql, linux server administration
Install Postgresql on Mountain Lion
Andrey Deryabin
·
7 responses
·
homebrew, postgresql
Backup and recover a Postgres DB using wal-e
Daniel Alejandro Gaytán Valencia
·
1 response
·
daniel-g, wal, wal-e, postgresql
Improve case-insensitive queries in Postgres using smarter indexes
Mike Hall
·
1 response
·
postgres, database, indexes, postgresql
Advanced Rails Indexing: WHERE clause (postgresql)
Kurtis Rainbolt-Greene
·
2 responses
·
rails, activerecord, indexing, postgresql
Incremental backups for PostgreSQL
Bartłomiej Danek
·
1 response
·
s3, aws, bash, postgresql
Pause and resume hot_standby replication on Postgres database
Cristóbal Castillo
·
0 responses
·
postgres, database, replication, postgresql
PostgreSQL: Flatten hierarchy in one query
mroach_
·
0 responses
·
postgresql, pgsql, recursive cte, hierarchy
Automated PostgreSQL install and configuration with PowerShell
Stefan Prodan
·
0 responses
·
powershell, postgresql
Reset heroku postgres database
Abraham
·
1 response
·
rails, heroku, rake, deploy
Rails rake tasks to dump & restore PostgreSQL databases
Nathan Hopkins
·
0 responses
·
ruby, rails, postgresql
Calculating Median in PostgreSQL
Gefei
·
0 responses
·
sql, aggregation, postgresql, median
SQLZOO - Learn and practice SQL
Filly
·
0 responses
·
mysql, sql, oracle, databases
simple full text search using postgres on rails
Greg Osuri
·
2 responses
·
ruby, rails, activerecord, postgresql
Consider subqueries instead of joins
Hannes Georg
·
1 response
·
mysql, sql, postgresql
Recent Activity
TIL: Postgres: Partial Index On Boolean Field Tp
bennycwong
·
rails, activerecord, postgresql, boolean
Create “Upcoming birthdays” query in Rails and PostgreSQL?
David Paluy
·
rails, postgresql
PostgreSQL: Exclude private IPs from query
mroach_
·
postgresql, geoip, ip address, networking
PostgreSQL: Flatten hierarchy in one query
mroach_
·
postgresql, pgsql, recursive cte, hierarchy
Pg-promise and case sensitivity in column names
Newest
Postgresql
protips
lakesare
·
js, pg-promise, postgresql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#
Coderwall Dev Community
Explore the all-time favorite tutorials, design patterns and engineering guides that thousands of readers keep sharing and coming back to, year after year.
These proven techniques, reusable code samples, programming tips and vibe coding habits earned their place through steady views and member likes.
Each entry here is still useful today, covering programming languages, frameworks and workflows that stay relevant long after they were first published.
Whether you're new to a tech stack or an experienced engineer refreshing your skills, start with the most useful tips our dev community members recommend and build on solid, well-tested coding knowledge.