Re: [Bayonne-devel] SQL support

[Dmitry Agafonov]

Julien Chavanton wrote:

> I guess it would be more clean and simple for bayonne to let the scripting 
> engine provide the database connection !
>  
As for me - I think, that "permanent" connections will follow the ideas 
of non-blocking operation
as "connect" and "disconnect" phases can be slow (not for mysql though). 
Many databases will
love you much more if you connect once for 30 queryes than 30 times :)
Moreover, system may use smaller number of SQL gateways than trunk count 
as each query will
use one (any) available connection from a pool.

On the other hand SQL query can became simple analog of TGI and may be 
joined as some kind
of GenericGateway class of ccscript or commoncpp with TGIGateway, 
MySQLGateway,
ODBCGateway, etc. That is why I compared SQL and TGI work in my post.

> -----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-----
>         
>
>
>
>
>  


--
Dmitry