Simpler Bugzilla

[Bill Barry]

Frédéric Buclin wrote:
>
> I just visited http://www.sqlite.org/omitted.html which says foreign 
> keys are not supported. This is a problem as our code now assumes 
> these constraints to be enforced, especially on deletion.
Foreign keys can be mocked using triggers.

The biggest problem with supporting sqlite is its concurrency model. 
Multiple connections can read at the same time, but only one connection 
can connect to the entire database (the whole db is write locked) when 
writing. That severely limits the number of concurrent users of Bugzilla.

A better path for Bugzilla might be to work towards a completely 
abstracted migration/installation database library (DBMI? *note). Once 
that is done, it would be able to support any database where a migration 
implementation (DBMD?) exists and a DBD implementation exists

note:
As a disclaimer, I have no idea how migrations are working in bugzilla 
at the moment, nor have I searched in Bugzilla for anything like this. I 
have only done rudimentary searching on cpan and come up with 
DBIx::Migrations::Directory, but I don't think that is a good solution 
as it requires sql scripts for each migration for each supported 
database. I was thinking something more along the lines of migrator.net 
(http://code.google.com/p/migratordotnet/) which abstracts away the sql 
that runs in order to support multiple databases with a single migration 
script.