Migrating from MySQL to PostgreSQL

 4th December 2008 by Chris

Along with the migration that I have done from SVN to Git and deploying my projects using Capistrano recipes, I was also faced with one task that was not very easy. I had to move my MySQL databases to PostgreSQL.

Why move?

Well, I gave it a thought, and I feel that I am now more comfortable with using Rails with PostgreSQL. Another factor is that I've already used MySQL in my early programming days and seemed fit for small scale projects. Since I have been dealing more and more with bigger databases, I'm getting the hang of using PostgreSQL over MySQL. It didn't really have to be very technical, but the simple preference mattered much.

Read the rest of this entry

Category: Database Tags:  0 Comments »
Unfuddling
Hi, I've been busy you know. wink If you don't know yet, this site and my blog codes are hosted in . I recently moved to Git and found that they have support for private Git repositories. Below are details of my last git push.

Maricris S. Nonato on 14 Feb
Commit: 48fe3652ffb644af13f4a5651f9d80474b09f622

Adding new ad image for Pledgie campaign - campaign image for coderkitty fundraising
Twitter
  • have you seen a chinese owl? i can't get this image out of my head: http://bit.ly/czilyD.. 2010-03-12
  • i just said this earlier before i got my mail from GodWhisper and it matches! http://bit.ly/b2ZWsy.. 2010-03-12
  • i don't like it when you start a business and all you think about is how to earn fast 2010-03-12
  • i am not inspired. i feel like there are monkeys at my back 2010-03-12
  • RT @crypticmess: RT @ihatequotes: Behind every untrusting woman is the guy who taught her to be that way. -Claudia Cardinale #ihatequotes 2010-03-11
  • @redbaks hahaha.. thanks! i'm up to it anyway! smile 2010-03-11
  • my mom is preventing me from doing work.. distracting me by offering fruits. sigh.. 2010-03-11
  • while creating mockups, i even find myself thinking in partials.. hmm.. too much ROR 2010-03-11
  • RT @makieduardo: "Keep me safe, O God... for in you I take refuge." (Psalm 16:1) 2010-03-11
  • @packetlog Philosophies of India? That wasn't in my list, but if you think its worth the read, then why not?! smile 2010-03-11
  • i'm on a voyage to read over 1101 books! smile 2010-03-10
  • @nightdreamer vampires? lol. i don't even like them as much as a commoner.. wink whoops! not to pull on any string there! tongue 2010-03-10
  • why is it that i find myself attracted more to classic novels?? 2010-03-10
  • @codinghorror lol. i'd love to see that happen tongue 2010-03-10
  • @gregmoreno had a look at that a long time ago. isn't it expensive though? or is it worth it? 2010-03-10
  • it took 3 yrs for Kindle to be introduced globally.. i wonder how long i have to wait for Nook sad 2010-03-09