Zope and MySQL on Windows
Greetings- I have a fairly mature Python application which uses MySQL for the database. I would like to switch over from a single machine application to a web based app (and maybe even make some money!!), and thought Zope would be the logical choice. The past 2 weeks have had me running through the examples in the Zope book and the Zope "Bible", and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory. Thanks for any advice you can supply! Greg Lindstrom Vilonia, Arkansas
Hi Greg,
and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows
Do they meant MySQL with Zope on the same Windows box ? But why Windows ? We use always Linux for such a project.
box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really
PostGreSQL is also a open source I think.
would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory.
5 MB is not big ! Regards, Dirk
For your application MySQL will work nice and smooth. Don't worry Maybe you could consider using the ZODB? \Oliver -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Greg & Janet LINDSTROM Sent: 2. november 2002 16:41 To: zope@zope.org Subject: [Zope] Zope and MySQL on Windows Greetings- I have a fairly mature Python application which uses MySQL for the database. I would like to switch over from a single machine application to a web based app (and maybe even make some money!!), and thought Zope would be the logical choice. The past 2 weeks have had me running through the examples in the Zope book and the Zope "Bible", and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory. Thanks for any advice you can supply! Greg Lindstrom Vilonia, Arkansas --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.393 / Virus Database: 223 - Release Date: 30-09-2002
From: "Greg & Janet LINDSTROM" <yuba@cyberback.com> 2. If so, what other Open Source Database is out there. ZODB for example. :-) Now, you probably ment to ask what opse source SQL databases there are. I know of two others: PostgreSQL and Firebird Best Regards Lennart Regebro Torped Strategi och Kommunikation AB
i use a python application which stores (web)objects to relational DB (=mySQL) two installations running on win98SE and win2k - each using zope and the DB on the same machine i can say it works fine (i don't have much workload on it) <hth> fritz (-:fs) Am Samstag, 2. November 2002 16:41 erhalten:
Greetings- I have a fairly mature Python application which uses MySQL for the database. I would like to switch over from a single machine application to a web based app (and maybe even make some money!!), and thought Zope would be the logical choice. The past 2 weeks have had me running through the examples in the Zope book and the Zope "Bible", and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory.
Thanks for any advice you can supply! Greg Lindstrom Vilonia, Arkansas
There are several options to using Zope+MySQL on the same Windows box. I have not done this in a production server environment, so I can't say how well that would work. But for development purposes, it works just fine. I had some problems getting python-MySQL adapter to install on Windows and recognize my python installation (because I was trying to install MySQLDA). But there are two ways around this problem which I've learned: (1) One is to install MyODBC (see www.mysql.com) and create a System ODBC database for your MySQL database. Then install the MyODBCDA database adapter for Zope (instead of MySQLDA). This allows you to talk to MySQL through an ODBC bridge. This solution works like a charm. (2) The second workaround is to install Python2.1.3 on your machine separately from the Windows Zope installation. Then install the .exe Mysql-Python package (www.sourceforge.net). Then copy the installed files to the Zope/Python directory. Then install MySQLDa. This solution was provided to me by another list member (hiren_hindocha@attbi.com). Bryan Bryan R. Capitano President, CAPITANO WEb CONSULTING Tel: 541-344-0747 Email: Bryan@capitanoweb.com URL: http://www.capitanoweb.com -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Greg & Janet LINDSTROM Sent: Saturday, November 02, 2002 7:41 AM To: zope@zope.org Subject: [Zope] Zope and MySQL on Windows Greetings- I have a fairly mature Python application which uses MySQL for the database. I would like to switch over from a single machine application to a web based app (and maybe even make some money!!), and thought Zope would be the logical choice. The past 2 weeks have had me running through the examples in the Zope book and the Zope "Bible", and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory. Thanks for any advice you can supply! Greg Lindstrom Vilonia, Arkansas
participants (6)
-
Bryan Capitano -
Dirk Datzert -
fritz -
Greg & Janet LINDSTROM -
Lennart Regebro -
Oliver Marx