delorie.com/archives/browse.cgi   search  
Mail Archives: geda-user/2018/10/18/12:53:51

X-Authentication-Warning: delorie.com: mail set sender to geda-user-bounces using -f
X-Recipient: geda-user AT delorie DOT com
X-Virus-Scanned: Debian amavisd-new at gag.com
From: Bdale Garbee <bdale AT gag DOT com>
To: "Nicklas Karlsson \(nicklas.karlsson17\@gmail.com\) \[via geda-user\@delorie.com\]" <geda-user AT delorie DOT com>,
geda-user AT delorie DOT com
Subject: Re: [geda-user] Gschem component database? <-- mapping symbol attributes
In-Reply-To: <20181018105812.abde204f9007586a71f16238@gmail.com>
References: <CALSZ9goACqKVRJ-EB=UnD38P+nCknSvuZ4UtRsmQqAjmkNA7+g AT mail DOT gmail DOT com> <20180814083707 DOT 7ef526fd225ce9179bb836a0 AT gmail DOT com> <87k1otcqyd DOT fsf AT gag DOT com> <20181018105812 DOT abde204f9007586a71f16238 AT gmail DOT com>
Date: Thu, 18 Oct 2018 10:52:04 -0600
Message-ID: <87bm7rfb9n.fsf@gag.com>
MIME-Version: 1.0
Reply-To: geda-user AT delorie DOT com
Errors-To: nobody AT delorie DOT com
X-Mailing-List: geda-user AT delorie DOT com
X-Unsubscribes-To: listserv AT delorie DOT com

--=-=-=
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

"Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via
geda-user AT delorie DOT com]" <geda-user AT delorie DOT com> writes:

> SQL is common for databases and is probably a good choice for
> storage. Stored in file locally on computer is probably the choice for
> most users and for organizations with more people a server. Question
> is what programming language to use? You have link to your awk script?
> Or how does it store the data?=20

Don't over-think this.  I realized one afternoon that what I actually
needed was really simple, and the benefits of a flat file that could be
maintained in git far outweighed any advantage SQL could offer.=20=20

So what we use is a flat file, one line per part, with tab-separated
fields.  We have templates for make for projects using geda-gaf+pcb and
lepton-eda+pcb-rnd that contain the logic to actually run the scripts.=20

As I indicated previously, our current parts database and all the
associated scripts live in the hw/altusmetrum repo at git.gag.com:

  http://git.gag.com/?p=3Dhw/altusmetrum;a=3Dsummary

Feel free to use any of this, all the scripts are under one or another
version of the GPL.  Or take the ideas you like and write something
completely different, whatever works for you!

Bdale

--=-=-=
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEhHDyCwYlkhh8unuzOpNhlsCV2UEFAlvIujQACgkQOpNhlsCV
2UGAwBAAyMKCJNWUqC+/9ynCOXPnh75kEU4wKl75+VeMdJDIfNRFkzNpqiOnRQbu
q7SPeG4h2ueIMl1pxO8hUFEFE32pGV3Qt7MYyIcoR0M1QCPQBtdlaMo51yEOezcf
hwBvdsp7uDJrD75YmFHimcPQEWm2ktBK+wBsJXz/SCR/A7Xcg0mycyA5oDKvMrRP
xm/PeZ5tgOeZDpc9pJHJOagZHmrSDav+hfsSZbUNF2fKV2Nu8kNIx4vquDBAwH85
xlbn7PUpU+t8Zz9ukyTgm1WjAQvmLBCfVdPJNe4vT27RSRBgSd92lMCDsHbCytV2
xjhxCSyOHztk6JMYXWwBDcBu3qZH6ILBsw+dk3qndVPia3gH8xIas3DKUBLM34sl
JR1plFyJR7iCL/fQsOLbWMWbXhxQLZBRfuzZQSG9wmrPSqgMIFLkqRE0xut8MpLC
7u1uSgmqs0i2a1SRi5tbW2VaR3cwtzl4RDMOhsb1R5uT48d3XTMyshQc2M2Qgvfx
K7Jz/o5aydPQAS/tzfmV1uthkzOc0IsDu4AYrCkDrVs2gARtxF21nl1OE2O2P5CN
KkAej1S6P2zDmAs47dVvCjg1rC6VJCg9118E044iki27xaoWeX4Psm+iUtEHN95/
AeKXZBtP2n8/E69CXJfJSGqC0l0rU+yhLZTMrmTGiteHrvJWRg8=
=fwuR
-----END PGP SIGNATURE-----
--=-=-=--

- Raw text -


  webmaster     delorie software   privacy  
  Copyright © 2019   by DJ Delorie     Updated Jul 2019