sqlite file format, anyone?
Derek Atkins
warlord at MIT.EDU
Sun Jun 22 15:28:37 CDT 2003
linas at linas.org (Linas Vepstas) writes:
> On Sun, Jun 22, 2003 at 09:00:10AM -0500, Matthew Vanecek was heard to remark:
> >
> > I may (have to) end up being entirely dynamic on the SQL
> > generation--it's just that, for certain things, the queries just won't
> > change from execution to execution (e.g., loading the accounts into the
> > engine). I want as much as possible to be static.
>
> I'm not sure what you are saying. The current postgres backend works
> just fine and it loads accounts using a 'static' query. Two points:
>
> 1) I don't think it would have added any significant overhead to
> run this from a dynamically generated query.
This is true...
> 2) The 'problem' with the current postgres backend is that every
> new object, e.g. all of the business objects, one needs to
> hand-craft a new table, hand-craft the m4 code to convert
> the SQL table contents into objects, and etc. If one is willing
> to do that work, then the current postgres backend is works great.
It's worse than this... The 'reading' object sout of the database is
also hard-coded, so one still needs to "fix" the Query* -> SQL
generation in order to read objects out of the database due to a GNC
Query.
> The problem, as I see it, is that I want to be able to describe an
> object, and have it automatically save and restore itself from SQL,
> without any further fussing about. I wan to absolutely minimize the
> amount of new code that has to be written to support a new object type.
I'm willing to make a small change to this goal -- I'm willing to
live with writing a small amount of code for each object -- so long
as it can be "plugged in". See the current plugin to the XML backend.
> --linas
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-devel
mailing list