Hello. Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise) But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use? Best regards, Carlos. PS. She's running Windows 2000. Tried to convince her to run FreeBSD but that was too much to ask, so I conceded.
mySQL runs on Windows. Cheers. -- Andy McKay.
On Thu, 26 Jul 2001, Carlos A. Carnero Delgado wrote:
Hello.
Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise)
But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use?
Best regards, Carlos.
PS. She's running Windows 2000. Tried to convince her to run FreeBSD but that was too much to ask, so I conceded.
MySQL would be an excellent choice. Interbase might be even better--it has many nice windows tools for installing, querying, etc. PostgreSQL is the most powerful of the Open Source databases, in terms of features, however, it's not a simple setup for Windows, and might be overkill for this project. Have fun, -- Joel Burton <jburton@scw.org> Director of Information Systems, Support Center of Washington
"Carlos A. Carnero Delgado" wrote:
Hello.
Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise)
But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use?
I've not used it in a couple of years but sounds like mySQL would be perfect. -- Tim Cook, President - Free Practice Management, Inc. http://www.FreePM.com Office: (731) 884-4126 ONLINE DEMO: http://www.freepm.org:8080/FreePM
I'm sure other people on the Zope list would have told you this but MySQL is the thing to go for. Usually runs on Unix systems but works very well on Windows with some neat graphical administration tools and is very powerful - more than basic SQL! Just install and set up a connection through the Control Panel ODBC Data Sources so it can be accessed either internally or externally. http://www.mysql.com Then use the ZODBC data connection in Zope to connect. ----- Original Message ----- From: "Carlos A. Carnero Delgado" <texel@rtvc.com.cu> To: "Zope discussion forum" <zope@zope.org> Sent: Thursday, July 26, 2001 11:00 PM Subject: [Zope] Simple, Open Source RDBMS for Windows
Hello.
Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise)
But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use?
Best regards, Carlos.
PS. She's running Windows 2000. Tried to convince her to run FreeBSD but that was too much to ask, so I conceded.
Why use ODBC when native is better/faster? ----- Original Message ----- From: "David Legg" <d.legg@ncl.ac.uk> To: "Carlos A. Carnero Delgado" <texel@rtvc.com.cu> Cc: "Zope List" <zope@zope.org> Sent: Friday, July 27, 2001 9:42 AM Subject: Re: [Zope] Simple, Open Source RDBMS for Windows
I'm sure other people on the Zope list would have told you this but MySQL is the thing to go for. Usually runs on Unix systems but works very well on Windows with some neat graphical administration tools and is very powerful - more than basic SQL! Just install and set up a connection through the Control Panel ODBC Data Sources so it can be accessed either internally or externally.
Then use the ZODBC data connection in Zope to connect.
----- Original Message ----- From: "Carlos A. Carnero Delgado" <texel@rtvc.com.cu> To: "Zope discussion forum" <zope@zope.org> Sent: Thursday, July 26, 2001 11:00 PM Subject: [Zope] Simple, Open Source RDBMS for Windows
Hello.
Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise)
But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use?
Best regards, Carlos.
PS. She's running Windows 2000. Tried to convince her to run FreeBSD but that was too much to ask, so I conceded.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Carlos A. Carnero Delgado]
Here's the satanic plan: with a little hard work for me, I'm converting my girlfriend's notebook office applications to Zope. She's currently using Microsoft Office for a number of tasks, but I'm "porting" her Excel and Access applications to Zope (not porting Excel, mind you; just the business logic, as well as some reporting stuff from Access.) I have demonstrated her that it would works--and it looks cool BTW, not to mention some stuff I have under my sleeve for her in the future (Zope wise)
But, I've been using Gadfly as the underlying RDBMS service. I know of its limitations (sort of). So, I'm asking you guys if there's a small, SQL compliant to the basic level, Open Source RDBMS that runs under Windows. Or is Gadfly more than enough for personal use?
But you might as well stick with using the Access database (as opposed to the Access application) unless you're trying to get rid of all Microsoft stuff completely - hard to do if you are using Windows. The Jet engine is already on the machine, you could use it from Zope. Otherwise, Interbase has an odbc driver and is free, or MySQL. If you want to get daring and be the first kid on the block, SAP has just opened up their relational database, and I believe there is an odbc driver for it. Cheers, Tom P
participants (7)
-
Andy McKay -
Carlos A. Carnero Delgado -
David Legg -
Joel Burton -
Phil Harris -
Thomas B. Passin -
Tim Cook