Tag: postgres

PostgreSQL: An Ultimate Toolkit to Execute Data With A Positive Outcome

by Kirk Haines, posted in Database, General, Optimization, Postgresql

The Problem I have been working on an application that, at it's heart, stores a large amount of data that is organized primarily through the use of a foreign key and a timestamp field. The table's own primary key is UUID based, combining the foreign key with a UUID for the individual record itself, and … Continue reading PostgreSQL: An Ultimate Toolkit to Execute Data With A Positive Outcome

Steps Of Migrating The Legacy Database To New Heroku Postgress 9.1

by Sameer Tilak, posted in Ruby on Rails, Tutorials

Recently Heroku released new version of postgres 9.1 with new price plans. A notice was send to all users to migrate from there existing share database to new planes released with Postgres 9.1. In these new plans concept of limit on using free shared database is changed from db size (5 MB) to limit on … Continue reading Steps Of Migrating The Legacy Database To New Heroku Postgress 9.1

Getting started with rails 3 & postgres database

by sandipransing, posted in Ruby on Rails

>Rails 3 Installationsudo gem install rails -v3.0.4postgres as db installationbr/$ sudo apt-get install postgresqlRails 3 App with postgres as database$ rails new pg -d postgresbundle installationIt will install dependency gems & postgres adapter for db connectionbundle installHere by default 'postgres' database user gets created while installation but i recommend to create new db user with … Continue reading Getting started with rails 3 & postgres database