Re: Freshmeat Made a Mistake Publishing This
> Here's the deal. Screwdrivers are
> tools, but you don't use a flathead to
> do a phillipshead's job. Just the same,
> You don't grab Oracle or Postgres when
> MySQL does the job.
Recently, after using PostgreSQL for two years because of the questions about whether MySQL had transactions, etc, I decide to begin using MySQL more, for those applications that don't involve financial transactions. I found that it crippled me to work with MySQL. How can you build a complex query when you don't have subselects? The alternative is to have lots of smaller queries and build the later ones based on the former, but this has two problems: It's far slower than just one query, because of the overhead involved in calling out to a database, and, you have to write extra code in the calling language (Python, RXML, Pike, whatever) to make up for the lack of subselects. This slows down web development considerably, in my experience. Anyway, since the recommended solution is to do more database queries to make up for not being able to do complex queries, I gave up and went back to PostgreSQL, which, after all, is fast enough.