Greg Donald wrote: > On Wed, Oct 7, 2009 at 10:11 AM, Marnen Laibow-Koser > <[email protected]> wrote: >> * I use PostGIS a lot. There is nothing comparable for mySQL. > > This is a lie.
Surely you can tell me you think I'm wrong without resorting to calling me a liar. Let's keep this debate as civil as possible. :) > > http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html Srsly? You're claiming that these are comparable to PostGIS? As someone who has worked with both, let me assure you that they are not. In fact, my first PostGIS project was originally going to use mySQL and these very features. It quickly became clear to me that although I wasn't doing anything fancy, mySQL would not suit my needs. So I found PostGIS, which got me into PostgreSQL (which, at the time, I knew nothing about). I can't imagine going back. > >> * MySQL makes you choose between speed and data integrity. �PostgreSQL >> does not. > > PostgreSQL has one table type. MySQL gives you 7 different table > types to choose from. > > Sounds like you're either not smart enough to choose the right one or > you didn't know you could make a choice. Again, I'm sure you could have said this without insulting my intelligence. Anyway, I do know about mySQL's plethora of storage engines. So tell me: which one (no, BLACKHOLE doesn't count :) ) will get me transactions, foreign-key checking, and full-text search in the same table? As far as I know, the answer is none. > > I've never has any speed problems with MySQL, even using it on > mega-sites like ezsweeps.com back in the late 90's. Fair enough. I have had speed problems with mySQL, but I'm not certain whether the cause was mySQL itself, poor DB design, or poor setup (and at the time, I really couldn't tell). > > > -- > Greg Donald > http://destiney.com/ Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- 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 -~----------~----~----~----~------~----~------~--~---
