X-Authentication-Warning: delorie.com: mail set sender to geda-user-bounces using -f
X-Recipient: geda-user AT delorie DOT com
Date: Mon, 14 Sep 2015 14:56:09 +0200
From: "Stephen R. van den Berg (srb AT cuci DOT nl) [via geda-user AT delorie DOT com]" <geda-user AT delorie DOT com>
To: "Lev (leventelist AT gmail DOT com) [via geda-user AT delorie DOT com]" <geda-user AT delorie DOT com>
Subject: Re: [geda-user] Using parse_l.y etc. for parsers for other languages
 (via SWIG)
Message-ID: <20150914125609.GA6914@cuci.nl>
References: <CAC4O8c-8O7eOEy3X=z+S4ugODBnvTJ4xhs_R9KRZqF-Z0oauvQ AT mail DOT gmail DOT com>
 <20150906154849 DOT 2449a717 AT jive DOT levalinux DOT org>
 <20150908224802 DOT GA4545 AT cuci DOT nl>
 <20150909184113 DOT 31288ef9 AT jive DOT levalinux DOT org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20150909184113.31288ef9@jive.levalinux.org>
User-Agent: Mutt/1.5.21 (2010-09-15)
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
Precedence: bulk

Lev (leventelist AT gmail DOT com) [via geda-user AT delorie DOT com] wrote:
>On Wed, 9 Sep 2015 00:48:02 +0200
>"Stephen R. van den Berg (srb AT cuci DOT nl) [via geda-user AT delorie DOT com]"
><geda-user AT delorie DOT com> wrote:

>> Have you even looked at the schema I proposed?

>Yes, I looked at the schema you sent. I think introducing a PosgreSQL
>dependency is a waaaay overkill for this project.

It depends, I guess.  PostgreSQL runs on Windows too, it even has
an installer for that :-).
The nice thing about PostgreSQL is that it does not matter where it runs,
it does not (necessarily) need to run on your local machine.

>However, I like your idea, but I don't know how to implement this with
>SQLite.

It is unlikely that SQLite will gain a query-engine that optimises as
good as PostgreSQL and supports that wide a range of SQL, including the
excellent GiST geometric-shape-indexes.  If this weren't crucial to
a tool as gschem/pcb I wouldn't bother even suggesting using PostgreSQL.
I think it could simplify a lot of code.

I think the file-dump in SQLite format has its merits, but I'd rather say
that improving the internal format helps more, and then generate
whatever format you want from there.  The most important criterium being
that the internal format supports a superset of all the actual file formats
you want to be able to import/export.  Writing a proper importer/exporter
(for any format) is then not that difficult anymore.
-- 
Stephen.