(first of all, sry about my english) Ive been studing postgres and mysql, and they have theirs pros and cons.
For me postgresql pros: - Im using OLAP, dont have alot of data today, but its growing, and is very intensive query, everyone say that postgresql is better on complex queries. - pl/ruby, this can help offloading somes intensive operations from application to databse, and programming in ruby :) (very, very, very nice!) For me mysql pros: - Easy to setup - Scalling is easy - Have more administrative tools Maybe i can have both databases, the main mysql running the whole website, something like the 37signalx box, lots of cores and memory and one postgresql database to run olap queries. What you guys think about it!? One thin im worry about in Mysql is data integrity, this is solved using InnoDB? or still Postgres more safe? Im talking about everything, transactions, corrupted data, incosistent data and so. Another question, about full text search, its better stick with the one inside de database or something external like Sphinx!? Im worring about speed and easy of use. Thanks everyone for helping me :) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
