diff options
| author | Nicolas Vigier <boklm@mageia.org> | 2013-04-14 13:46:12 +0000 |
|---|---|---|
| committer | Nicolas Vigier <boklm@mageia.org> | 2013-04-14 13:46:12 +0000 |
| commit | 1be510f9529cb082f802408b472a77d074b394c0 (patch) | |
| tree | b175f9d5fcb107576dabc768e7bd04d4a3e491a0 /zarb-ml/mageia-sysadm/2011-January/001913.html | |
| parent | fa5098cf210b23ab4f419913e28af7b1b07dafb2 (diff) | |
| download | archives-master.tar archives-master.tar.gz archives-master.tar.bz2 archives-master.tar.xz archives-master.zip | |
Diffstat (limited to 'zarb-ml/mageia-sysadm/2011-January/001913.html')
| -rw-r--r-- | zarb-ml/mageia-sysadm/2011-January/001913.html | 127 |
1 files changed, 127 insertions, 0 deletions
diff --git a/zarb-ml/mageia-sysadm/2011-January/001913.html b/zarb-ml/mageia-sysadm/2011-January/001913.html new file mode 100644 index 000000000..acf964bbf --- /dev/null +++ b/zarb-ml/mageia-sysadm/2011-January/001913.html @@ -0,0 +1,127 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-sysadm] Starting packages import in Mageia svn + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20Starting%20packages%20import%20in%20Mageia%20svn&In-Reply-To=%3C1294788886.32187.144.camel%40akroma.ephaone.org%3E"> + <META NAME="robots" CONTENT="index,nofollow"> + <META http-equiv="Content-Type" content="text/html; charset=us-ascii"> + <LINK REL="Previous" HREF="001912.html"> + <LINK REL="Next" HREF="001914.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-sysadm] Starting packages import in Mageia svn</H1> + <B>Michael Scherer</B> + <A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20Starting%20packages%20import%20in%20Mageia%20svn&In-Reply-To=%3C1294788886.32187.144.camel%40akroma.ephaone.org%3E" + TITLE="[Mageia-sysadm] Starting packages import in Mageia svn">misc at zarb.org + </A><BR> + <I>Wed Jan 12 00:34:46 CET 2011</I> + <P><UL> + <LI>Previous message: <A HREF="001912.html">[Mageia-sysadm] Starting packages import in Mageia svn +</A></li> + <LI>Next message: <A HREF="001914.html">[Mageia-sysadm] Starting packages import in Mageia svn +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#1913">[ date ]</a> + <a href="thread.html#1913">[ thread ]</a> + <a href="subject.html#1913">[ subject ]</a> + <a href="author.html#1913">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE>Le mardi 11 janvier 2011 à 18:32 +0100, nicolas vigier a écrit : +><i> On Tue, 11 Jan 2011, Thierry Vignaud wrote: +</I>><i> +</I>><i> > On 11 January 2011 18:01, nicolas vigier <<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">boklm at mars-attacks.org</A>> wrote: +</I>><i> > > After thinking more about this, I think I agree that it would be much +</I>><i> > > better to run it on alamut. Especially if using a SQL database for +</I>><i> > > packages status. +</I>><i> > > +</I>><i> > > Maybe once BS is ready, we can work on updating tools to use a database, +</I>><i> > > and migrate the web interface on alamut at that time ? +</I>><i> > +</I>><i> > That sounds like a the way to go +</I>><i> +</I>><i> Actually after talking with blino, he thinks using a database for +</I>><i> packages status is not such a good idea : +</I>><i> +</I>><i> "we don't need a database, that will only make everything more complex +</I>><i> for little advantage..." +</I> +It would be easier to clean ( just a select request, referential +integrity ), easier to code well ( db handle the race condition ). +And in fact easier to code, ie, if the web team need to handle this, I +am sure they would prefer using a db than reading output of unix +command. It would also be easier to interface with others systems, or +others uses ( statistics, etc ). + +It would also be easier to use and understand ( ie, no need to parse +file and directory structure tied to iurt ). + +Easier to sort, easier to do select ( like showing just the package of a +maintainer without selecting the whole listing of rpm, and doig lots of +I/O ) + +It would spread the load amongst server (I/O wise again), it would use a +proper indexing system, as the main part of the job of the status page +is to find the list of job by getting all inodes from some predefined +directory. + +In short, it seems to me cleaner from a engineering point of view, and +more extensible. + +I understand there is concern on the complexity. But I do not think a +sql base would be more complex than the current system, where the data +are encoded partially in the path, partially in the file name, and +partially in the content of the file. That's not very efficient, and I +feel that's reinventing the wheel. + +Regarding the fact that we lose the ability to do simple shell script, I +think sql could be much more expressive than shell script when it come +to data manipulation ( ie, it is partially done for that after all ), +and that we should first see why we need shell script in the first +place. + + +Maybe we also do not have the same vision of what would "store stuff in +db" mean so maybe a more complete proposal could be done. + +What about brainstorming about it with a beer at FOSDEM ? + +><i> One advantage is that it's easier to access from an other host (better +</I>><i> than nfs export I think). But I don't know if that's enough. +</I> +-- +Michael Scherer + +</PRE> + + + + + + + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="001912.html">[Mageia-sysadm] Starting packages import in Mageia svn +</A></li> + <LI>Next message: <A HREF="001914.html">[Mageia-sysadm] Starting packages import in Mageia svn +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#1913">[ date ]</a> + <a href="thread.html#1913">[ thread ]</a> + <a href="subject.html#1913">[ subject ]</a> + <a href="author.html#1913">[ author ]</a> + </LI> + </UL> + +<hr> +<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm +mailing list</a><br> +</body></html> |