landfill: /tools/ now understands PostgreSQL

[Max Kanat-Alexander]

On Tue, 2005-07-12 at 13:31 +0200, Guillaume Rousse wrote:
> Maybe a stupid question (I didn't even attempted to read the code), but
> as bugzilla is using DBI instead of native drivers, why are you tied to
> PostgreSQL or MySQL rather than to any supported database ? Are there so
> much non-standard SQL constructs?

	The problem isn't so much non-standard constructs as it is the fact
that almost no database fully supports ANSI SQL.

	That is, we could write Bugzilla to be totally ANSI, and then no
database would support it. :-) MySQL, in particular, is quite far from
full ANSI support.

	Most of the work involved to get Bugzilla to support PostgreSQL was in
making as much of Bugzilla's SQL ANSI-compliant as possible. So yes, now
that we support PostgreSQL, supporting other databases should be much
easier.

	However, every database system has its quirks, and so every time we
want to support another database, we have to make some adjustments to
Bugzilla itself.

	-Max
-- 
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.