delorie.com/archives/browse.cgi | search |
X-Authentication-Warning: | delorie.com: mail set sender to geda-user-bounces using -f |
X-Recipient: | geda-user AT delorie DOT com |
X-Original-DKIM-Signature: | v=1; a=rsa-sha256; c=relaxed/relaxed; |
d=m0n5t3r.info; s=m0n5t3r; | |
h=subject:to:references:from:message-id:date:user-agent:mime-version | |
:in-reply-to:content-type; | |
bh=4R0TsbpaBVAoSYMucpqAF5fIh8jSMCFJsR0QlUEpQes=; | |
b=H50J+UnNyvljwyHG84SlCiGiFtNGs//pXwsS6IDH78+2oamQNs7n8L/TJcJVy7mf57 | |
+kU3hmBFAPkYiJPkv81m3mNYQ8lC7azLi5YRvwT7Knup0maLBEWT0cRFc5UCXtFmsANN | |
Kh1elDaMksa9ri5jZWl2IRX0kWVxyyyeYdKxg= | |
X-Google-DKIM-Signature: | v=1; a=rsa-sha256; c=relaxed/relaxed; |
d=1e100.net; s=20130820; | |
h=x-gm-message-state:subject:to:references:from:message-id:date | |
:user-agent:mime-version:in-reply-to:content-type; | |
bh=4R0TsbpaBVAoSYMucpqAF5fIh8jSMCFJsR0QlUEpQes=; | |
b=bWWoUNoK6htIMhFnhABfQfj7ZSBCG7n2ags4DLJHT/faUhHsayGPin6E1MUe1EaVwk | |
x0NKKNCVGOU5+hY7jx7B88zJgZq8XOWaddTfitFKItN0lf/+6Wn0VT2gs6h4OwMTigFA | |
4Y3qKNf3CRstjz3hFljymsMx7lXK9BtxIXDoKHYdhXinj+mT0iJD1KsWWW0ClnXx/wT8 | |
nyaM4hl1/oDn+uDCyEyq7reM1ca5IvvnpuIHnClZodaQiVlKEAkVSAeevD4/nTLX3AN2 | |
gUDO8ucSD8Y1SmdqGHjn4He9w62kDt6mIMWWCxTuDI+GSXLpKSTfTWHVHlPJadG+mwQP | |
H62A== | |
X-Gm-Message-State: | ALoCoQlcyTtttvwjZXpB3x0o5O7MtOaSudGrgQdPPgqQPjQl6oySVcz0Y3kZwJJNiPCq+0iY5VVZRGjpCJDz+IHkKTEoE7WDlQ== |
X-Received: | by 10.28.183.132 with SMTP id h126mr14973926wmf.6.1452149231207; |
Wed, 06 Jan 2016 22:47:11 -0800 (PST) | |
Subject: | Re: [geda-user] (SQL file open/save) |
To: | geda-user AT delorie DOT com |
References: | <1512221837 DOT AA25291 AT ivan DOT Harhan DOT ORG> |
<C1CFCCEE-C64A-4E49-AA64-446C061656D6 AT noqsi DOT com> | |
<CAC4O8c-zt8B=joDd+ws77D2jt6aZf3MWfR_dAvpzGcNuBrTURQ AT mail DOT gmail DOT com> | |
<alpine DOT DEB DOT 2 DOT 11 DOT 1601030040320 DOT 2176 AT newt> | |
<D9825C8C-B6FD-4C7F-A8D5-B8AF06253B72 AT noqsi DOT com> | |
<CAC4O8c_R5xWLmzj_cz0g0mPWNs6mR4efjXKGBoup8YO6nwnPTA AT mail DOT gmail DOT com> | |
<CAC4O8c8cVr1H3skmbGo4Rhf5ZTZj8bDx! Jw8a9C4qf HeGyXZ4XA AT mail DOT gmail DOT com> | |
<20160106091006 DOT 5F67B809D7A1 AT turkos DOT aspodata DOT se> | |
<CACwWb3CcsYJ9KgDFAa5pZqDzfTewhvbuatbxoKUp6PtHRCoa+w AT mail DOT gmail DOT com> | |
<20160106133049 DOT 5A0E9809D79B AT turkos DOT aspodata DOT se> | |
<CACwWb3Cyk4yLwt3=V1Mu5C4RieOQEjYH3ej5MXZSNnLPbshqDg AT mail DOT gmail DOT com> | |
<20160106143629 DOT 4D39D809D79B AT turkos DOT aspodata DOT se> | |
<CACwWb3BXbnQXs+DwVVzmC8DrhwOYxPgVyUhZTPL9bM9cJbHimw AT mail DOT gmail DOT com> | |
<20160106164022 DOT D0D4E809D79B AT turkos DOT aspodata DOT se> | |
<20160106180912 DOT 42ddf4079d91384f206b7c35 AT gmail DOT com> | |
<20160106191433 DOT 5dc5cb59 AT jive DOT levalinux DOT org> | |
<20160106202817 DOT 56197b2c539d426a1b724c9e AT gmail DOT com> | |
From: | "Sabin Iacob (iacobs AT m0n5t3r DOT info) [via geda-user AT delorie DOT com]" <geda-user AT delorie DOT com> |
X-Enigmail-Draft-Status: | N1110 |
Message-ID: | <568E09ED.1080508@m0n5t3r.info> |
Date: | Thu, 7 Jan 2016 08:47:09 +0200 |
User-Agent: | Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 |
Thunderbird/38.4.0 | |
MIME-Version: | 1.0 |
In-Reply-To: | <20160106202817.56197b2c539d426a1b724c9e@gmail.com> |
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 |
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --jJhGr8BxlRWBmtnQSqlUc7Bm9gSpNNLP8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 01/06/2016 09:28 PM, Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via geda-user AT delorie DOT com] wrote: >> On Wed, 6 Jan 2016 18:09:12 +0100 >> "Nicklas Karlsson (nicklas DOT karlsson17 AT gmail DOT com) [via >> geda-user AT delorie DOT com]" <geda-user AT delorie DOT com> wrote: >> >>> Then it come to SQL can you solve file open and save as usual? Or do >>> you have to make connection to some kind of database? >> Yes. SQLite. >> >> https://www.sqlite.org/ >> >> Using server/client architectured database engin like postgresql is IM= HO >> overkill. >> >> Lev > I used SQL once to write a small database application but I used an SQL= server and even though it works and could be done it will be rather comp= licated for ordinary use. With a simple library binding it could be worth= a try. > > all right, can't stand it any more, I've been eating my words for a while now: please, please, please, stop with this SQL nonsense... I know that once you find a new shiny hammer everything looks like a nail, but schematics and PCBs are graphs at the core, and SQL databases are a pretty bad fit for storing graphs (yes, you can shoehorn them in - see mptt - but the results are more often than not awful); I too would like to see a more comprehensible file format for PCB, but SQL will be anything but comprehensible (source: used SQL extensively for the last 15 or so years as a developer and a server babysitter). as far as file formats go, while something standard like json or (cringe) yaml or (cringe even harder) xml would have advantages (ubiquitous library support, easy-ish to parse and modify with awk & friends for people who are so inclined), it will degenerate into unproductive holy wars (see previous pushes for lua as the file format, or various bickering about which text format is best); the way I see it, the process looks like this: * decide on data model; this is where you think hard about what you need to do, how it maps to the physical world, etc. * decide on syntax, write formal grammar; this is where you take into account parse-ability with standard text tools and human brains (I, for one, am a big fan of "design for humans first, computers later") * have a parser generator generate parsers for every language you use, generate some more as they are requested problem solved, you get canonical parsers for all languages that are needed and no extra layers of FFI (which can be needlessly heavy) --jJhGr8BxlRWBmtnQSqlUc7Bm9gSpNNLP8 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJWjgntAAoJEIIekQf3ltoLOWgP/1TR6i01EOlQc8rM81rooTbj ymEklqV4Iqq1kkZEBMQYfecAiCSXZ9SdkkeWLFGWAZblO4YymQOEe7DDZDgqdPF2 n3FYwTOuRhJIp+SHSOLItwGxrxGxbGcJaE9k7CbJ10dsydeayxuNtG0aQq6Qw4v5 +ItkHM01smVjxCjg4JMcFQLgOiN4Jbph/2WF65IwD4qCHROXDDvvwBb7fwPplhIF o8bpJSk6k8pKCp7G2qZW6cmEjP9MuTrv6iaM8Onl12Bj3rBSpsBgDWfrs6AXNDRd QbtoUvjSbnrc/Ie0rda4iHcLqASnh6inEG8GmKzw2ONJBcVCUZi5KeHkVC9EEcyz CZSD68sJya46X76n0o+8y6LiDDk8++NRonJPpTQOESNdwlQ/fH8IQn3CaX92FNfQ eaSugsZrpKBvnn2StskhK/WmBJy+hO/DjRtk3f4ZkbcwpBXPF4/I6sx7imohop0+ 5WB03p3D2Uedx+HIzVADzcMB+kAB6nSpz0KhvI4BqM+/7NY4Yld91rrUPkYIEOew klyz7jkveJar87PuRlh5yeaAaQCpcC05fAGCLGXzPitJir/JerzBcm61uP5OHBD0 +9N+GJCOSZgq8HUjCvunh2z+wNuffex+tyJVgBloiZeihe140+bXL8/cF+J+5Q3V 8pIaaAxDqSLsSWwaEyYe =Ujig -----END PGP SIGNATURE----- --jJhGr8BxlRWBmtnQSqlUc7Bm9gSpNNLP8--
webmaster | delorie software privacy |
Copyright © 2019 by DJ Delorie | Updated Jul 2019 |