Barry Frost

This is Barry Frost’s personal website.

Tagged #postgresql

Recursive SQL Queries with PostgreSQL


Real upsert for PostgreSQL 9.5+ and Rails 5+ / ActiveRecord 5+. Uses ON CONFLICT DO UPDATE.


PostgREST serves a fully RESTful API from any existing PostgreSQL database.


PostgreSQL GUI Tool for Mac OS X

Scaling PostgreSQL Performance Using Table Partitioning

Screencast: using ruby to add schema-less data to PostgreSQL

With hstore you can add schema-less data to PostgreSQL. This allows you to store model attributes without creating separate database columns. Watch how to do this using the activerecord-postgres-hstore gem.

“The easiest way to run PostgreSQL on the Mac”

Setting up PostgreSQL for Ruby on Rails development on OS X


PostGIS adds support for geographic objects to PostgreSQL for geographic information systems (GIS)


Robby on Rails : Installing Ruby on Rails and PostgreSQL on OS X, Second Edition

Rails and Scaling with Multiple Databases

in PostgreSQL

Install Ruby, Rails, and PostgreSQL on OSX

In particular, on a new MacBook.

Oracle vs MySQL vs PostgreSQL

Performance Tuning PostgreSQL : Django performance tips

Also relevant for pretty much all websites/apps

PostgreSQL: What's New in 8.1


“PostgreSQL + Compatibility + Scalability”

PostgreSQL SQL Syntax and Use

Faster Inserts with PostgreSQL