Le Mercredi 8 Octobre 2003 20:27, FACORAT Fabrice a �crit : > Le mer 08/10/2003 � 15:05, Pierre Jarillon a �crit : > > Le Mercredi 8 Octobre 2003 09:18, Vedran Ljubovic a �crit : > > Yes your idea is very good and ergonomic. As GC said, "There would take > > very much diskspace, especially screenshots!" > > To avoid this, it could be useful to create a database hosted by > > Mandrake: > > several problems : > 1�/ db loads form mdk > 2�/ need an internet connection > > we'd better use a local lighweight db like sqlite ( > http://www.sqlite.org/ , http://www.sqlite.org/faq.html ). > The first time rpmdrake is launched or when a hdlist is modified, > rpmdrake rebuild the database and then do everything after on this > database. The difficulty is to sync urpmi/rpmdrake DB with rpm DB ( but > you could think about the fact that when an rpm is inserted or deleted > from rpm DB, rpm automatically update rpmdrake DB accordingly ). > To my mind this could resolve our speed problems with hdlist > computations at rpmdrake start and when performing queries. > I could hope that sqlite may be far faster.
I agree, sqlite is a good idea to replace hdlist. But I was talking of a another database, hosted by Mandrake, with true foreign keys, grants, rollback.... Like posgresql with integrity constraints. The sqlite database could be an extraction of the main database and this extraction could be included in the distro (like the localized man or howto). Query of the Mandrake database could be allowed to to Club members only. I like evolution instead of revolution. I don't know how is made the rpm database. I suggest to improve this management step by step. The first goal is to get a localization of the rpm. But to avoid to modify the rpms, this could be a separate database in a first step. I spoke at Metz with Martin Michlmayer (Debian project). They have the same problem. I dream of a common localization... why not ? Another idea is that a software can belong to several groups. The groups are defined in only one tree. This is not enough. It is possible to make other trees according to the job: Infography, webmaster, professional sound and music, secretary, and so on. In each profession, certian programs are very useful or not. My database structure can allow people (from club) to maintain a level of pertinence (ie 0..10) for each program in each group. For example OpenOffice would be scored 10 for a secretary and 2 for a webmaster. I worked during 23 years with databases (10 with Oracle), I wish to use my knowledge to help Mandrake. I don't forget that the aim is to help newcomers, to spare time and money to Mandrake and help the "Libre Software". -- Pierre Jarillon - http://pjarillon.free.fr/ Vice-pr�sident de l'ABUL : http://abul.org/
