Popular Postgresql Programming Tips
DBD::Pg on MacOS
Chisel Wright
·
0 responses
·
postgres, postgresql, cpanm, dbd
Syntax highlighting using Postgresql and VIM
François Pietka
·
0 responses
·
vim, syntax highlighting, postgresql
Using Hstore to Store Post Tags in Rails 3.
Jordon Bedwell
·
0 responses
·
ruby, rails, hstore, postgresql
Fix PostgreSQL after Homebrew Update (OS X Mavericks & upgrading to PostgreSQL 9.3 from PostgreSQL 9.2)
Trevor Hinesley
·
0 responses
·
homebrew, corrupt, postgresql
PostgreSQL multiple column UNIQUE constraints with NULLs are not UNIQUE
S. Brent Faulkner
·
0 responses
·
sql, unique, constraint, postgresql
Capistrano sync postgresql database
Anton
·
0 responses
·
capistrano, sync, postgresql
Set postgres log level and table space in database.yml
Sascha Hoellger
·
0 responses
·
rails, postgresql
Getting PostgreSQL query explain plans in Rails pre-3.2.x
Wes Gamble
·
0 responses
·
postgresql, explain, query optimization
Delete duplicate rows
Russell England
·
1 response
·
mysql, sql, duplicates, postgresql
How to manage remote Heroku Postgres DB
Andrej Dragisic
·
0 responses
·
heroku, postgres, postgresql
Create “Upcoming birthdays” query in Rails and PostgreSQL?
David Paluy
·
0 responses
·
rails, postgresql
Random epoch time in SQL
Jaco Groenewald
·
0 responses
·
random, date, month, random day in month
How do types affect PosgreSQL query planning
Jordi Pradel
·
0 responses
·
performance, postgresql
reset heroku database
Michał Czyż
·
0 responses
·
heroku, reset, postgresql
PostgreSQL: Exclude private IPs from query
mroach_
·
0 responses
·
postgresql, geoip, ip address, networking
Postgresql Unique K-ordered 64-bit Integer Generator
Anton Sekatski
·
2 responses
·
sql, database, postgresql, plpgsql
Enable Heroku Postgresql autovacuum
Rafael Souza
·
0 responses
·
heroku, postgresql
Setting up PostgreSQL for Ruby on Rails on Linux
Tobias Pfeiffer
·
0 responses
·
ruby, rails, gem, linux
Async PostgreSQL access in Scala with Play and Heroku
Maurício Linhares
·
0 responses
·
scala, async, postgresql
PostgreSQL for WordPress
Simon Koch
·
0 responses
·
sql, plugin, database, postgresql
Debugging PostgreSQL queries with erlang and ChicagoBoss
Eric Cestari
·
0 responses
·
erlang, postgresql, chicago boss, eper
Postgres: Add Sequential PKEY
Cathy Wise
·
0 responses
·
sql, postgresql, databases, quickfix
How to drop all database connections to a PostgreSQL database
Gergo Sulymosi
·
0 responses
·
rails, postgres, rake, postgresql
Using PostgreSQL unaccent in Django 1.7
Daniel Hartmann
·
0 responses
·
python, django, postgresql, unaccent
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.