[Apache][PHP4] Cannot load /etc/httpd/modules/libphp4.so into server: libpq.so.2.1: cannot open shared object file: No such file or directory

Fixing libpq.so.2.1 not found on Apache + PHP4 by symlinking the PostgreSQL library into /lib.

[Ruby on Rails] Solution for 'An error occurred while installing pg (1.4.5), and Bundler cannot continue.' [macOS Edition]

How to fix pg gem install errors on macOS by installing libpq with Homebrew and updating PATH.

[CircleCI 2.0] Rails 5.x + Webpacker Configuration Job Setup Method for Running Rspec Tests

A working config.yml for running Rspec on Rails 5.x + Webpacker on CircleCI 2.0's free plan, with notes on the gotchas.

Free PostgreSQL GUI Tool 'Postico' is User-Friendly on macOS

We compared free PostgreSQL GUI tools available on macOS and summarized the features and user experience of each. Postico particularly felt user-friendly.

[Heroku] How to Configure heroku-postgresql:dev

How to install the heroku-postgresql:dev add-on and promote it as the primary DATABASE_URL.

Heroku PostgreSQL Version Check Method and Command: heroku pg:info

Use heroku pg:info to confirm the version of Heroku PostgreSQL your app is running.

Summary of Commonly Used Commands and Flow for Web App Development with Heroku + Ruby on Rails 3.2

Commands and workflow for building and deploying a Rails 3.2 app to Heroku's Cedar stack, end to end.

[Rails] How to Redo db:migrate to Heroku's Default PostgreSQL

Three ways to force db:migrate to run again on Heroku when rake db:reset is not available.

[MacOS] How to Uninstall All Versions of PostgreSQL ~ Homebrew Edition

Using brew uninstall --force to remove every Homebrew-installed PostgreSQL version on macOS, plus cleaning up the data directory.

[MacOS] Steps to Install PostgreSQL with Homebrew

Installing PostgreSQL on macOS via Homebrew — initdb, launchd auto-start, PGDATA, and a non-superuser account.

Building a Cloud-DB-Free Todo App with Next.js + PGlite and Deploying to Vercel

I built a Todo app with PGlite running in-browser Postgres and persisting to IndexedDB using Next.js 16, then deployed it to Vercel.

[Oracle] DESCRIBE Command to Check Table Definition

Oracle DESCRIBE plus the equivalent table-definition commands for MySQL and PostgreSQL.

[Oracle] Displaying Table List

Listing user tables in Oracle, MySQL, and PostgreSQL, side by side.

[PostgreSQL][8.0.4] Sequence Function Arguments are text Type, not regclass Type (ERROR: cannot cast type text to regclass)

Fixing the PostgreSQL 8.0.4 'cannot cast type text to regclass' error in nextval.

[PostgreSQL] The Convenient COALESCE Function That Returns the First Non-NULL Argument

Using PostgreSQL's COALESCE function to substitute a default value when a column or aggregate returns NULL.

[PostgreSQL] ERROR: Cannot insert a duplicate key into unique index

Quick note on PostgreSQL's duplicate-key error when INSERT hits a UNIQUE constraint.

[PostgreSQL] How to Output Tables to CSV

Two ways to export a PostgreSQL table to CSV: interactive psql commands and a one-liner `psql -c` invocation.

[PostgreSQL] Configuration for Connecting from Other PCs

Configuring `listen_addresses` and pg_hba.conf so PostgreSQL accepts connections from other hosts.

[PostgreSQL] ERROR: missing FROM-clause entry for table

Handling the missing FROM-clause error in PostgreSQL, and what changed with add_missing_from in 9.0.

[PostgreSQL] ERROR: must be owner of extension plpgsql

Resolving `must be owner of extension plpgsql` on pg_dump import by granting the role superuser privileges.

[PostgreSQL] Check table permissions when ERROR: permission denied for ~ error occurs

Fixing PostgreSQL's permission denied error by checking table privileges with `\z` and running GRANT.

[PostgreSQL] ERROR: language "plpgsql" does not exist

Fixing PostgreSQL's missing plpgsql language by loading it with the `createlang` command.

[PostgreSQL] postmaster.opts is Auto-generated, So Editing It is Pointless

Notes on why editing postmaster.opts is pointless — it's regenerated on restart, so the startup script needs to change.

Got Library not loaded: libreadline error when running psql, so I ran brew upgrade postgresql

How I fixed a psql libreadline error with brew upgrade postgresql and pg_upgrade.

Steps to Create Ruby on Rails 5 and Deploy to Heroku

End-to-end steps for spinning up a Rails 5 app and deploying it to Heroku with Heroku Postgres.

[Rails] Correspondence Between ActiveRecord and DB Data Types

A quick reference for how ActiveRecord column types map to native PostgreSQL and MySQL types.

[Rails] Solving the 'rake aborted! no such file to load -- pg' Error with rake db:migrate Command

Fix `rake db:migrate` failing with `no such file to load -- pg` by swapping sqlite3 for pg in your Gemfile.

Rate Limit Storage Selection: PostgreSQL vs Redis

Comparing PostgreSQL and Redis as storage for rate limiting. We explain our decision to choose PostgreSQL based on the YAGNI principle, considering current rate limit settings and existing API request flow.

[Ruby] How to Change the Display Format of Time Objects

A quick note on using Time#strftime to format Ruby Time objects into arbitrary display strings.