Re: Comments on SQL Backend

Toby D. Reeves wrote:

> When I first wrote it up, I used MySQL, the world's fastest mostly free
> SQL server, even if it is "simple".  MySQL does not support foreign
> keys, cascading deletes, sub selects, Stored Procedural Languages, or
> Triggers.  But it is fast!!! 


It is fast for read only systems. The second you 
start bringing in writes, the locking mechanisms 
get you. Especially if they're big writes.


> It has fields that will not be used.  Some fields are in the wrong tables.


Would you care to be specific on these two? Please 
tell us which fields you think are in the wrong 
location, and why.


> It makes the assumption
> that the world runs on i386.


I made some changes to support the other arch's 
through the packages and channels tables, and I'm 
working on getting together a piece to indicate 
which archs can work together. Originally, I 
thought the channels could be made arch 
independent. Then Hunter  informed me that you get 
different deps/provides for packages on different 
archs.



> 
> 12. Server can serve up more than one canonical architecture:  alpha,
> ia64, sparc, i386, ....
> 
Should be able to do this now.