[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Bayonne-devel] SQL support
From: |
Julien Chavanton |
Subject: |
RE: [Bayonne-devel] SQL support |
Date: |
Thu, 7 Apr 2005 15:28:05 -0400 |
I guess it would be more clean and simple for bayonne to let the scripting
engine provide the database connection !
-----Original Message-----
From: address@hidden on behalf of David Sugar
Sent: Wed 4/6/2005 09:49 AM
To: Dmitry Agafonov
Cc: address@hidden
Subject: Re: [Bayonne-devel] SQL support
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In ccscript3 what I did was create a connection to an associated
database as each script is compiled. The
use statement was extended to pass the name of the database for the
script that expects to connect. Hence,
each script can have it's own private database reference, and different
scripts can have different database
connections associated with them. When old scripts are purged, old
connections are torn down. The only
database operations that occur during execution are now the actual
queries, in an async thread.
Dmitry Agafonov wrote:
> Hello!
>
> I just get myself to the idea of SQL usage in bayonne (ccscript).
>
> Imagine a pool of SQL connections, ready to answer any query.
> One connection per SQL gateway thread (like TGI).
>
> Just ping() connection on script startup and cleanup result sets on
> script ending.
>
> Simple schema, isn't it?
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCU+jSJlWtSTiTVsYRAl/eAJkBxsEaOXY2kr9xDzdviw0hhc7QFACfQMgW
BNSLEFiwDAkbOlwvytLQCS8=
=bVYw
-----END PGP SIGNATURE-----