[development] Do not let postgresql hold back great patches

Edward Z. Yang edwardzyang at thewritingpot.com
Fri Nov 30 17:58:37 UTC 2007

Hash: SHA1

> Take, for example, that COUNT(*) is _really_ fast on MySQL + MyISAM,
> but is slow on just about every other DB.  So, replace it with
> $db->count(), which does an SQL COUNT(*) on MySQL + MyISAM, but uses
> some other technique on other databases.  The programmer no longer
> cares _how_ such a thing gets done, he only cares that he wants to
> know how many rows are in a particular query

The primary problem with this approach (at least in my experience) is
that the moment you need to create queries that are even somewhat
complicated the abstraction layer proves to be insufficient. Ad hoc
queries are often very useful for performance reasons, but you'll have
to get a PostgreSQL guru to write an equivalent.

Then again, for most people writing SQL performance/complex joins/etc
are not a primary concern...

- --
 Edward Z. Yang               Portable GnuPG: 0x995A2C84
 HTML Purifier <http://htmlpurifier.org> Anti-XSS Filter
 [[ C8D5 9E3C 15AD 1467 5561 2C0E 719A 2D9D 995A 2C84 ]]
      This Message Courtesy of Thunderbird Portable
Version: GnuPG v1.4.7 (MingW32)


More information about the development mailing list