Read my latest article: 8 things I look for in a Ruby on Rails app (posted Thu, 06 Jul 2017 17:59:00 GMT)

Localization with Rails and PostgreSQL, part 1

Posted by Wed, 30 Nov 2005 18:36:00 GMT

1 comment Latest by highstatesmanship@gmail.com Wed, 28 Jun 2006 04:43:44 GMT

One of the client projects that PLANET ARGON is working on requires that it work in about 20 different languages. Jeremy has been investigating different plugins for Rails to help us accomplish this. He came across Globalize.

Globalize is a Ruby on Rails plugin designed to support multilingual applications. It’s under the MIT License, same as Ruby on Rails.

Locale.set( 'en-US' )
d = Diet.find( 1 ) 
d.name -> "Vegetarian"

... we want to pull back the German version. No, it doesn’t translate it for you.. just pulls back another version of the object with the desired locale.

Locale.set( 'de-DE' )
d = Diet.find( 1 ) 
d.name -> "Vegetarier"

Pretty cool, right?

Well, we’re primarily working with PostgreSQL and the Globalize plugin didn’t pass tests with it. That’s now fixed as I found out from Jeremy that he was given COMMIT rights to the Globalize plugin and it now passes all tests against PostgreSQL!

We’ll keep you updated on how well it works as we dig deeper into using it. :-)

Interviewed by CRN regarding Oracle, MySQL, and PostgreSQL

Posted by Sun, 13 Nov 2005 03:49:00 GMT

I was interviewed by CRN regarding my personal thoughts on how the release of Oracle Express might compete with MySQL and PostgreSQL.

Read the short article…

Oracle Express… {yawn}

PostgreSQL 8.1 was released!

Posted by Thu, 10 Nov 2005 00:21:00 GMT

Just a quick announcemnet:

Yesterday, the PostgreSQL team released version 8.1. Take a peak at the latest changes and enhancements.

Yes, we’re offering PostgreSQL 8.1 Hosting and Support for it now at PLANET ARGON. :-)

Interview with CD Baby

Posted by Wed, 02 Nov 2005 22:25:00 GMT

Last month I conducted an interview with Derek Sivers and Jeremy Kemper of CD Baby… this is the result.

Migrating from MySQL to PostgreSQL in 60 seconds (with Rails)

Posted by Sat, 29 Oct 2005 19:23:00 GMT

I do quite a few MySQL to PostgreSQL migrations for clients of PLANET ARGON and over the years I have gone through different methods of handling this procedure. Typically, it involved exporting data, re-importing it through some shell script that does its best to take into consideration the slight differences between the two databases.

While working on a recent project that was to be migrated from MySQL to PostgreSQL, but after some Refactoring had been done to the code base. I had been meaning to spend a few hours coming up with some simplified process of taking data from MySQL and replicating it to a new PostgreSQL database, while maintaining referential integrity.

My original idea was to build a script that referenced two seperate databases and then copied data out and inserted it into the new db after performing a few data changes. This seemed like too much work and I knew that I should be able to harness the power of Ruby and Rails in my process. My next thought? RailsFS.

In a perfect world, I would mount one instance of the application with a mysql database and another with a postgresql database… and just copy the yaml files to the postgresql and bam, it’d work, right? Well, it doesn’t quite work that way. So, I ruled out that idea.

Then I had another idea. I would build a task in my Rakefile that… imported each of those YAML files into PostgreSQL!

We can now type in the following commands:

This first creates my PostgreSQL database tables using Migrations.
rake migrate VERSION=1

then…

rake mysql2pgsql
mysql2pgsql runs…and approx 60 seconds later, I had an exact copy of the MySQL database in PostgreSQL. But wait! PostgreSQL has SEQUENCES… so I then run:
rake migrate VERSION=2

...and my SEQUENCES are ALTER’d.

Yes, I will post some code in the near future. But all I am doing is basically running through all the YAML files that are available from RailsFS and adding them into the new database. It automatically figures out the model name…and is fairly generic at the moment. However, I’d like to spend a bit more time stress-testing it before I post it. :-)

I want to try to work on a RailsFS-less version as well so that I can run this on my PowerBook.

Until next time… have fun!

PLANET ARGON 2.0 Release Candidate

Posted by Tue, 25 Oct 2005 18:10:00 GMT

We finally found a way to sneak in some extra time to finish up the first phase of our new website. Allison and I are excited to announce the launch of new PLANET ARGON website, www.planetargon.com.

What Powers It?

Ruby on Rails and PostgreSQL!

What Has Changed?

For starters, we have a new design. Hopefully the information that you are seeking is easier to navigate to and the order process is a bit easier too. Aside from that, we’ve made just minor changes to our hosting offerings to reflect the needs of our customers. I’ll touch on that shortly.

ReEmphasize The Small Stuff

We first started offering Rails hosting to the public at the beginning of February. In just a week we’ll have nine full months of experience under our belts. Our customers have been a huge influence on the type of services we offer, and the level of support that comes with it. It was out of my own desire to have a web host that allowed for bleeding-edge technology that lead me to start my own hosting company… so that I could turn around and offer other developers, like myself, the same service, without the time commitment of managing your own server and the price tag that goes along with it.

Our Customers are Awesome!

No really, they are. We recently setup an RSS aggregator of some of our hosting customers that run blogs (many of them are running Typo). We call this site, Inhabitants of PLANET ARGON. (inhabitants.planetargon.com) Check it out!

More Space!

We’ve spent some time really looking over our hosting plans and wanted to give them a make-over that reflects the requests of our customers and potential customers. We’ve increased the disk space on the first three of our shared-hosting plans, and lowered the price on the fourth. Take a peek.

Some of our prices have gone up (with the increase in disk space), but our Level 1 plan still starts as low as $11.25/month. This can get you rolling on Rails using PostgreSQL and/or MySQL! :-)

Typo Hosting

We started offering affordable blog hosting last year. Then Typo took off, and none of the other blog software packages were being requested! We have dropped all the PHP blogging applications from our offerings and are now offering Typo Hosting exclusively. For $3/month, you can have your own pre-installed Typo blog!

FREE RAILS HOSTING!

Well, sort of. If you sign up by midnight (PST) on October 31st, you will receive 1 FREE Month for every 6 month account and 2* FREE Months* for every year! (Blogs too)

We’re Not Just a Hosting Company

PLANET ARGON was started as a web development and consulting company, and it still is!

Who Is Allison?

Allison is the Creative Director here at PLANET ARGON. Existing customers of ours know about her… but she’s kept a low profile up until now. She is a ninja in the ways of project management, clean design, and has been known to have a tab open in her browser to the Ruby on Rails API. Expect to hear more from (and about) her in the near future.

For more information, see: http://www.planetargon.com

Older posts: 1 2 3 4 5 6