[ZODB-Dev] Re: Gadfly with ZEO clients - anyone trying this?

[Ken Wasetis]

Thanks, Chris.

Since my system is running on Windows 2000, and since I expect minmal 
load from this part of the application (storing entries to a contest 
into a relational DB; I use ZODB for everything else, just about), I'm 
likely to look into ODBC with one of the databases you mention.  I don't 
want to get bogged down with recompiling everything just to get an 
optimized database driver working.

Anyone have any recommendations one way or the other of using Zope/ODBC 
with MySQL or Postgres or Firebird?  I've never actually used Firebird, 
so would likely go with one of the other two.  And with recent screwing 
around of the MySQL license, I might shy away from that.

Suggestions?  If not, no problem, I'll just get trying 'em out.

Thanks,

Ken

Chris McDonough wrote:
> I don't think Gadfly is a client-server application.  In other words,
> it's limited to running on one system.  I'd suggest MySQL, Postgres,
> Firebird, or another relational database that does support the
> client-server model.
> 
> On Wed, 2004-02-25 at 12:45, Ken Wasetis wrote:
> 
>>Hi,
>>I've built a prototype using Gadfly as storage for some contest data 
>>acquired via Formulator forms via ZPT.  I developed this on a test 
>>server running a ZEO client and ZEO server.  Everything works fine with 
>>just one ZEO client.
>>
>>The problems comes when I try to run multiple ZEO clients (which my 
>>production environment has), due to the fact that when we add a 
>>ZGadflyDA connection, it creates its storage files within 
>>$CLIENT_HOME/var/mydatabase.
>>
>>Since it creates the database within the filesystem of a ZEO client 
>>(client home) rather than the /var folder on the ZEO server, in 
>>production, where the ZEO server is on a different machine than the 
>>multiple ZEO clients (on multiple different servers), only the ZEO 
>>client where the Gadfly database is stored can connect to it and execute 
>>queries.
>>
>>Has anyone modified the Gadfly DA.py or db.py files to specify a remote 
>>storage (ZEO Server) location/var rather than the location zeo client 
>>/var folder for storing Gadfly databases?  Or possibly modified 
>>App.config to add a SERVER_HOME or modified one of the other _HOME 
>>environment variables?
>>
>>I'm sort of surprised that I couldn't find any information on people 
>>using Gadfly in a ZEO client/server (specifically, with multiple 
>>machines) situation.  If you know of a reference, please help me out.
>>
>>If I were to continue to use Gadfly, the most likely scenario would 
>>involve me creating a ZEO Client instance on the machine running the ZEO 
>>Server/ZODB and this instance would have the Gadfly connection defined. 
>>  Then, I'd somehow use ODBC to connect to that database from all the 
>>ZEO Clients on the other machines.
>>
>>If I must go through the process of hacking to create a centralized 
>>Gadfly, I will look more strongly at using MySQL or some other database 
>>as the centralized database, I think.
>>
>>Any help is appreciated,
>>
>>-Ken
>>
>>
>>
>>_______________________________________________
>>For more information about ZODB, see the ZODB Wiki:
>>http://www.zope.org/Wikis/ZODB/
>>
>>ZODB-Dev mailing list  -  ZODB-Dev at zope.org
>>http://mail.zope.org/mailman/listinfo/zodb-dev
> 
> 
> 
> _______________________________________________
> For more information about ZODB, see the ZODB Wiki:
> http://www.zope.org/Wikis/ZODB/
> 
> ZODB-Dev mailing list  -  ZODB-Dev at zope.org
> http://mail.zope.org/mailman/listinfo/zodb-dev
>