We don't really do anything tricky with PostgreSQL. We're not using any of the full-text search features (we're using Thinking Sphinx for that). Because we're not doing anything particularly tricky with Postgres, we just treat it like any other database - and Rails just works with it.
When we first started the application, we had plans to use some more advanced features (full-text, triggers, etc). But when we deployed, our hosting provider didn't support the latest version of PG, so we had to down grade, loosing some of the full-text features that we wanted. Oh! I almost forgot, we do actually do one tricky thing. We wrote a plpgsql function that made it easier for us to find locations within a certain radius. create or replace function km_between_lat_long( lat1 numeric, long1 numeric, lat2 numeric, long2 numeric ) returns numeric language 'plpgsql' as $$ declare x numeric = 69.1 * (lat2 - lat1); y numeric = 69.1 * (long2 - long1) * cos(lat1/57.3); begin return sqrt(x * x + y * y * 1.61); end $$; Thats pretty much the *only* thing we are doing tricky. At the time of writing the function, I dont think MySQL had very good support for functions like this. -- *Keith Pitt* Web: http://www.keithpitt.com Twitter: @keithpitt Skype: keithpitt Phone: +61 432 713 987 2010/6/3 Anders Østergaard Jensen <[email protected]> > Hello there, > > It is definitely interesting to see how people choose PostgreSQL in the > Rails environment over other commercial DBMS'es. I would be very interested > in seeing how you guys maintain your PostgreSQL data especially with > migrations. Personally, I find it hard to integrate migrations properly with > PostgreSQL's great but specialised functionality that does not transfer > easily to other databases (e.g. full text search). > > I am a partner in a company, Meeho!, developing an online document > management, CRM, and project management web application with the same name. > Most of the code is written in Ruby on Rails and -- like your project -- > lots of Javascript. The backend is written in PostgreSQL and a Java EE > application performing the heavy duty tasks. > > <shameless marketing> > Visit http://www.meeho.net/ for more information. :) > </shameless marketing> > > On Thu, Jun 3, 2010 at 12:51 PM, Keith Pitt <[email protected]> wrote: > >> Hi All, >> >> My company released our latest and greatest Rails app and I thought >> you guys might be interested: >> >> 50and.com >> >> <marketing_jargon>"Meeting new people can be difficult and daunting in >> this age group so we have provided a safe, secure and friendly way to >> meet like minded people you can connect with. 50and is a safe, >> supportive and simple mature dating and networking site for senior >> singles looking for over 50 dating or just mature people looking to >> make new friends."</marketing_jargon> >> >> It uses Rails 2.3.5 & PostgreSQL. It uses *alot* of unobtrusive >> javascript on the internal pages. It actually uses the rails.js (the >> jQuery version, of course) thats bundled with Rails 3. >> >> Some key things you may (or may not) be interested in: >> >> - Used RSpec & Cucumber for Testing >> - Using http://scoutapp.com/ for application monitoring >> - IE6-8 compatible (yes, I know, it hurts me too) >> - Thinking Sphinx for location searching >> >> Would love your feedback if you have some time to have a look. >> >> Cheers, >> >> Keith >> (the "Tap to Start" guy) >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby or Rails Oceania" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<rails-oceania%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/rails-oceania?hl=en. >> >> > > > -- > Best regards, > > Anders Oestergaard Jensen > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<rails-oceania%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rails-oceania?hl=en. > -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rails-oceania?hl=en.
