landfill: /tools/ now understands PostgreSQL

Max Kanat-Alexander mkanat at
Tue Jul 12 12:22:52 UTC 2005

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

	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.

Everything Solved: Experts at Bugzilla... and everything else, too.

More information about the developers mailing list