Guyren, Do you have a similar link explaining why Postgres is superior to MySQL? I know Postgres has all the momentum now in the developer community, but I can't seem to find any extremely compelling reason why it's held in such high regard over MySQL (other than the whole evil corporate Oracle owns MySQL thing).
Most of the research I've done comes to the conclusion that they're basically the same, so if you have 10+ years of experience with one then just stick with it. But that doesn't explain why every developer I meet turns his/her nose up at the mere suggestion of using MySQL. So if you've got some good links I'd appreciate it if you could pass them along and convince me otherwise. I just haven't heard any reason yet that's convinced me to make the switch. -- Chris On Friday, November 21, 2014, Guyren Howe <[email protected]> wrote: > I’ve not worked with it nearly as much as MySQL or Postgres. But seems I > can now be almost as harsh about MS SQL Server as I have been about MySQL: > > <http://www.pg-versus-ms.com/> > > That just leaves Oracle. I *have* worked a goodly amount with Oracle. > Oracle is significantly better than SQL Server and MySQL. And I can even > imagine situations where I would choose Oracle over Postgres. Were I to > describe such a situation, I would begin with something like “well, I > suppose if I was working for a bank…”. > > For everyone else, Postgres is clearly, I will even say outrageously, > obviously, and dramatically, the best database available today. > > On related news, I’m currently working on some tests of Postgres’ special > indexes for the next meeting. The GIN index has just received a dramatic > improvement in Postgres 9.4 (both smaller and faster). I’m planning on > presenting results giving an indication about when you might want to use > GIN or GIST indexes. For those who saw my last presentation about indexes, > compound GIN and GIST indexes let the database use any of the columns in > the index for a search. They are rather more complex than BTree for the > database to maintain, so this involves a tradeoff between insert and query > time that ought to be explored in more depth. > > I’m planning on running some benchmarks that will give us at least a rough > idea of how GIN and GIST indexes compare for insert and query time against > BTree indexes. If you use Postgres, you should come hear what I find out. > > > > -- > -- > SD Ruby mailing list > [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');> > http://groups.google.com/group/sdruby > --- > You received this message because you are subscribed to the Google Groups > "SD Ruby" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','sdruby%[email protected]');>. > For more options, visit https://groups.google.com/d/optout. > -- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
