Barry Frost

This is Barry Frost’s personal website.

Tagged #postgresql

postgrest

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

PSequel

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.

Postgres.app

“The easiest way to run PostgreSQL on the Mac”

Setting up PostgreSQL for Ruby on Rails development on OS X

PostGIS

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

INFORMATION_SCHEMA Support in MySQL, PostgreSQL

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

jacobian.org : Django performance tips

Also relevant for pretty much all websites/apps

PostgreSQL: What's New in 8.1

EnterpriseDB

“PostgreSQL + Compatibility + Scalability”

PostgreSQL SQL Syntax and Use

Faster Inserts with PostgreSQL

SQL Relay

Persistent database connection pooling

dAlchemy | End to End Unicode Web Applications in Python

…including some useful tips for PostgreSQL/Python/Unicode