Hi Bert,
Thank you very much for your comments. I've put together a detaild description of the system. http://web.interware.hu/lekovacs/cuccok/theory_of_operation.txt As I go back to Germany next week, I'm gonna have time to start programming. Cheers, Levente Timmerman, Bert <[EMAIL PROTECTED]> wrote: > Hi Levente, > > This looks good to me, as it has been on my mind for some time since I > read http://archives.seul.org/geda/dev/Jul-2007/msg00050.html and > replied with http://archives.seul.org/geda/dev/Jul-2007/msg00061.html as > to allow for invoking data from a csv file for the attributes. > > I'm just not that good with the setup of DBMS stuff ;-( > > So I thought of a spreadsheet solution to maintain the data, because I > know how to generate a csv file from a spreadsheet. > > The least thing I could do is to provide data for a DBMS ;-) > > This database could be a way to solve the problem of all heavy symbols > with a generic symbol (A.K.A. the "transistor problem"), and could even > be expanded to logic gates, FETs, and whatnot. > > The "only" requirement would be that some sort of script generates a csv > file and starts up a generator script like Dan's "symgen.tgz" and puts > the generated symbol in a defined subdirectory (where you could actualy > find it, something like /usr/share/gEDA/sym/local for example). > > And there have to be "light" generic symbols of course (maybe in > /usr/share/gEDA/sym/generic ??). > > One caveat: there are zillions of transistor, logic gates, FETs and > whatnot packages around, so it would take some time to feed them into > the DB. > > The good news is that one central webbased repo could contain all this > stuff and could be maintainted by all of us happy gEDA users ;-) > > Maybe even distributed as snapshots with the geda distro > (geda-symbols-db.tar.gz) for users without continuous web access. > > Just my EUR 0.02 > > Kind regards, > > Bert Timmerman. > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Levente > Sent: Sunday, September 02, 2007 11:51 PM > To: [EMAIL PROTECTED] > Subject: gEDA-dev: database driven component selection > > > > Hi all, > > > I am about to engineer a database driven component selection system for > gEDA. Currently, > I've set up a database system with just few tables. > > http://levente.obudanet.hu/phpmyadmin/index.php > > Please use the "component" database. The database can be accessed with > user > "guest" with no password from the web interface, and by any mysql > client. > > Each row of the device table represent a single physical component. The > symbol > field points to a template symbol file. I would like to write an SQL > client > which helps selecting component, and would tell gschem what symbol to > use, and pass it > to gschem with attributes. > > My question here is how can I tell gschem to select some file as symbol? > How > to make it attach attributes? Can it be done from guile script? > > Later, the selecting mechanism could be integrated in gschem. > > I am making this thing to be able to calculate prices, to automate > component > ordering, etc. > > Please let me know if you like it, or not, or if you have any > suggestion, > question! > > [EMAIL PROTECTED] > -- Levente http://web.interware.hu/lekovacs _______________________________________________ geda-dev mailing list [email protected] http://www.seul.org/cgi-bin/mailman/listinfo/geda-dev
