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 _______________________________________________ geda-dev mailing list [email protected] http://www.seul.org/cgi-bin/mailman/listinfo/geda-dev
