Converting Rails apps from MySQL to PostgreSQL

Submitted by Christoph Olszowka 2010-12-31 13:44:00 UTC
Source:  http://railsonpostgresql.com/2010/10/20/converting-rails-apps-from-mysql-to-postgresql

Referenced projects

Ruby on Rails

Ruby on Rails is a full-stack web framework optimized for programmer happiness and sustainable productivity. It encourages beautiful code by favoring convention over configuration.

Rubygem rails

Total Downloads
34266872
Releases
190
Current Version
4.1.0
Released
2014-04-08 00:00:00 UTC
First Release
2004-10-25 04:00:00 UTC

Github rails/rails

Watchers
20812
Forks
7365
Development activity
Very active
Last commit
2014-02-16 18:01:09 UTC
Contributors
2188
Issues

mysql

This is the MySQL API module for Ruby. It provides the same functions for Ruby programs that the MySQL C API provides for C programs. This package is offered as gem for easy installation using RubyGems. It wraps unmodified tmtm's mysql-ruby extension into a proper gem. Please note that tmtm (Tomita Mashahiro) has deprecated development of this extension and only update it for bug fixes.

Rubygem mysql

Total Downloads
4889542
Releases
8
Current Version
2.9.1
Released
2013-02-16 00:00:00 UTC
First Release
2004-10-20 04:00:00 UTC

Github luislavena/mysql-gem

Watchers
33
Forks
10
Development activity
Inactive
Last commit
2013-05-10 15:08:44 UTC
First commit
Top contributors
Contributors
4
Issues

pg

Pg is the Ruby interface to the {PostgreSQL RDBMS}[http://www.postgresql.org/]. It works with {PostgreSQL 8.4 and later}[http://www.postgresql.org/support/versioning/]. A small example usage: #!/usr/bin/env ruby require 'pg' # Output a table of current connections to the DB conn = PG.connect( dbname: 'sales' ) conn.exec( "SELECT * FROM pg_stat_activity" ) do |result| puts " PID | User | Query" result.each do |row| puts " %7d | %-16s | %s " % row.values_at('procpid', 'usename', 'current_query') end end

Rubygem pg

Total Downloads
9076567
Releases
39
Current Version
0.17.1
Released
2013-12-19 00:00:00 UTC
First Release
2008-01-28 08:00:00 UTC
×

In order to continue, you must be signed in using your Github account.

If you're signing in using this account for the first time Github will ask for your permission to give access to your public user data to the Ruby Toolbox.

Although the Github Authorization page does not mention it, the request includes read-only access to your verified email address (user:email OAuth scope). This is neccessary so there's a way to notify you about comments, information about your accepted project edits and the like. You can review your notification settings on your account page once you're signed in.