sqlite file format, anyone?

[Linas Vepstas]

On Mon, Jun 23, 2003 at 02:42:50PM -0400, Derek Atkins was heard to remark:
> linas at linas.org (Linas Vepstas) writes:
> 
> > Besides, the pg backend 'works' today; it doesn't have business object
> > support, but I'm thinking that with 'setters', it might not be hard to
> > add business object support.
> 
> "Setters" as you keep calling them are completely irrelevant.  What

OK. I thought it would make it easier to add the bus. obj.

> we need are hooks for the BackendRegistry, and we need to completely

??  grep egistry  *.c doesn't give me anything.

> re-write the Query* -> SQL conversion.  I already added comments
OK.

> in the PG code for where we'd need hooks into the BackendRegistry...
> 
> And then we'd need to implement the PGBackendAPI plugin for each of
> the objects to add.

grep BackendAPI  */*.c give me nothing.

> Isn't it?  It's what I've always been talking about.  The current code
> doesn't have a clean separation (IMHO) between PG-specific and
> SQL-generic code.  

No it doesn't, but shouldn't really be that hard.  There's one or two
macros that are used for 100% of the calls, the macro can be changed.
The only other thing is the 'logging onto the databse' code, which
is very pg-specific.  But its not rocket science to do this, this is a
small project.  Maybe a few days of work.

> Another thing we need to do is rename the existing gncEntry table (to
> gncSplit, or "Split), because there is another object (in the business

Yeah, OK.

> code) named gncEntry.  If Splits were to be called Entries then they
> should have been globally renamed, not just renamed in the PG backend.

Well, that never happend, did it? I was being hounded because everyone
kept telling me that split means stock split and that entry is the right
term for it.  But the person who insisted the most didn't actually
follow through.  Ugh.

Crap like this is what makes me cranky and conservative.  I get real
pissed when people come in and they say they'r gonna 'improve' things,
and instead they break features without seeming to really improve
anything at all. 

> Personally, I think table-name should equal the GNC_ID_ string for any
> object..

Yes.

--linas

-- 
pub  1024D/01045933 2001-02-01 Linas Vepstas (Labas!) <linas at linas.org>
PGP Key fingerprint = 8305 2521 6000 0B5E 8984  3F54 64A9 9A82 0104 5933