[Coldstuff] genesis 1.1.11-pre1

[Brad Roberts]

Could you provide some implementation details?  Would you like some
pointers on how to generalize it more?  I hope so, since I'm going to give
it anyway.

I suggest, for 1.1.x, another extra pointer off the Obj struct.  For 1.2.x
(I know.. practically vaporware as far as most people are concerned, but
trust me, some really incredible work has gone on that just needs to be
cleaned up before anyone sees it (ie, I'd be a little embarassed for it to
be looked at too closely by anyone right now)) I've overhauled that
mechanism to make it less expensive (memory wise, slightly more expensive
cpu wise) to add object specific pieces like the current connection and
file pointers.

Try to isolate the sql engine specific pieces into a layer such that the
coldc api can work for multiple sql engines (mysql, postgres, informix,
sybase, oracle, mssql, etc).  Ie, there's bound to be some amount of code
that is independant of the sql engine api's and some that's very very
specific.  Try to make it easy to write different spcific pieces without
having to touch the common piece.  Also, try to think about cursor
support.  Mysql doesn't support cursors, not sure about postgres, but the
rest do and could go a long way towards reducing the latency for sql
results.

If there's enough demand for the sql support, I'd be tempted to back port
the changes I mentioned above from 1.2 to 1.1.  With those changes, it'd
be very easy to keep the sql code as a separate module that didn't have to
touch any core code at all, I think.  As usual, thinking out loud without
looking at the code could get me in trouble, but I'm fairly confident that
it's easily doable.

Later,
Brad

On Fri, 24 May 2002, Jeremy Weatherford wrote:

> Date: Fri, 24 May 2002 20:01:49 -0700 (PDT)
> From: Jeremy Weatherford <xidus@xidus.net>
> Reply-To: coldstuff@cold.org
> To: coldstuff@cold.org
> Subject: Re: [Coldstuff] genesis 1.1.11-pre1
>
> I added basic MySQL client support (single connect per driver and exec) to
> Genesis about a year ago.  I don't know what the status of that code is
> right now.  It wasn't a huge project, in any case.
>
> I'm starting on more comprehensive PostgreSQL support now.  I'm not
> worried about performance with this implementation, because the support is
> currently only for a single-user web-app with more need for persistence
> than volume in data storage.  I will try to handle multiple connections in
> a sane manner, though -- either with descriptors or by binding them to
> objects.  Hmm... probably descriptors.
>
> If you're interested in the MySQL code, which I assume still works, let me
> know.  It's a hackish 133-line module meant to be linked with
> -lmysqlclient.  Last tested with 1.1.9-STABLE.
>
> Jeremy Weatherford
> xidus@xidus.net
> http://xidus.net
>
>
> On Fri, 24 May 2002 elh@astroarch.com wrote:
>
> >
> > Hi,
> >
> > Has anyone integrated Genesis into an SQL server? Or any thoughts on how
> > hard that would be or where to start?
> >
> > Also, has anyone updated the MOO2COLD code?
> >
> > Thanks,
> > Edward Haletky
> >
> > >
> > > I've taken all the patches submitted to coldstuff to date and created a
> > > pre-release tarball for any who want to test it.  I've done little more
> > > than make sure it still passes the limited test suite.  There are no major
> > > changes in here:
> > >
> > >   http://www.puremagic.com/~braddr/Genesis-1.1.11-pre1.tar.gz
> > >   http://www.puremagic.com/~braddr/Genesis-1.1.11-pre1.tar.bz2
> > >
> > >   * fix BUFFER in BUFFER.  Use buffer_index which contained a fix
> > >     not propagated to the previously duplicated code in op_in
> > >     (Allen Noe)
> > >   * Apply (with changes (Brad)) a bunch of MSVC patches (Robert Bradley)
> > >   * Fix some missed regerror -> gen_regerror's (pvx at wmute.net)
> > >   * Fix method access setting error handling (pvx at wmute.net)
> > >
> > > I haven't tested the win32 MSVC patches myself, and I didn't apply them
> > > exactly as they were submitted so I'm interested in hearing if there are
> > > problems.  I believe there's some set of files that Rob has that need to
> > > be added on top of the tarball before it's actually functional.  Or
> > > something like that.  I'm just supporting what I can without the ability
> > > (or desire) to test.
> > >
> > > If anyone has additional bug fixes that should be rolled into this release
> > > or even just bugs that you haven't reported or aren't included in this
> > > list, please send them my way.
> > >
> > > Thanks,
> > > Brad
> > >
> > > _______________________________________________
> > > Cold-Coldstuff mailing list
> > > Cold-Coldstuff@cold.org
> > > http://web.cold.org/mailman/listinfo/cold-coldstuff
> > >
> >
> > _______________________________________________
> > Cold-Coldstuff mailing list
> > Cold-Coldstuff@cold.org
> > http://web.cold.org/mailman/listinfo/cold-coldstuff
> >
>
> _______________________________________________
> Cold-Coldstuff mailing list
> Cold-Coldstuff@cold.org
> http://web.cold.org/mailman/listinfo/cold-coldstuff
>