Rails on PostgreSQL : Rails apps using PostgreSQL in production

Comment on Rails apps using PostgreSQL in production by alex@alexkane.net

2009-09-17T16:45:37+00:00

I’m about to launch a PostgreSQL powered rails app, will post the URL when it’s launched.

Comment on Rails apps using PostgreSQL in production by Tom Copeland

2009-09-17T17:03:00+00:00

@alex, cool, sounds good!

Comment on Rails apps using PostgreSQL in production by Marc Tremblay

2009-09-17T20:06:47+00:00

We have a Rails + PostgreSQL application, currently in closed beta, at http://screenlight.tv

Comment on Rails apps using PostgreSQL in production by Nathen Harvey

2009-09-18T08:09:04+00:00

VisualCV - http://www.visualcv.com is on PostgreSQL

Comment on Rails apps using PostgreSQL in production by Tom Copeland

2009-09-18T09:48:52+00:00

@nathen, @marc, thanks guys! Any technical details you can add? Replication solutions, full text search, any oddities you ran into, anything like that would be appreciated!

Comment on Rails apps using PostgreSQL in production by Ryan Heneise

2009-10-01T15:43:09+00:00

Donor Tools (www.donortools.com) has been happily running on PostgreSQL in production for over a year.

Comment on Rails apps using PostgreSQL in production by Exchange

2010-09-30T02:33:23+00:00

It depends on the projected scale of your web application. For relatively small databases, MySQL is fine and is slightly faster for simple selects, etc. Once your database gets large however, MySQL hits a wall where PostgreSQL just keeps on driving through it.

As long as you’re using ActiveRecord for your middleman, it won’t matter what database you use, as it builds Standards Compliant SQL Statements, which will work on both databases. As soon as you specify any triggers, stored procedures, etc, you’ll be stuck with one database.

I personally prefer PostgreSQL, but that’s just because I was never a big fan of MySQL.