Abhinay Kumar abhinaykumar

Migrating a Rails project from MySQL to PostgreSQL

This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.

No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!

I chose [pgloader][1] because it's extremely fast. YMMV.

Replace mysql2 gem with pg in Gemfile.
Update config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.

Command: heroku pg:backups capture -a [app_name]

Command: curl -o latest.dump `heroku pg:backups public-url -a [app_name]`

####################################################################################

You have two full days to implement a solution
You can use any (fairly) mainstream object oriented language of your choice, so long as your solution builds and runs on linux. You should be fine if you favour, say, Java, Ruby, Python or Javascript.
Please ensure that you follow the syntax and formatting of both the

message.video.open do |file|
  system '/path/to/virus/scanner', file.path
  # ...
end

	require 'digest'
	require 'base64'
	require 'cgi'
	require 'uri'
	require 'time'
	require 'openssl'
	require 'json'
	require 'active_support/security_utils'

	SHARED_SECRET = 'sup3rs3cr3t!!'

	HTTP status code symbols for Rails

	Thanks to Cody Fauser for this list of HTTP responce codes and their Ruby on Rails symbol mappings.

	Status Code Symbol
	1xx Informational
	100 :continue
	101 :switching_protocols
	102 :processing

	[alias]
	recent = "!git for-each-ref --sort=-committerdate refs/heads/ --format='%(committerdate:short) %(refname:short)' \| head -n 10"
	co = checkout
	cob = checkout -b
	coo = !git fetch && git checkout
	br = branch
	brd = branch -d
	brD = branch -D
	merged = branch --merged
	st = status

	$(document).on('page:change', function() {
	var $productContainer = $('#product-container');

	if ($productContainer.length) {
	setInterval(fetchProducts, 500);
	}

	function fetchProduct() {
	// some ajax code
	}