Re: [Plone-users] Re: Zope databasw
sergio, try to keep to the list - you'll get more help ;-) On Wed, May 07, 2003 at 09:19:21AM -0400, Cueto, Sergio wrote:
Can I use SQL2000 as the database in zope? Also, if I wished to use another database such as MySQL or Oracle, how is this link set in zope since the default appears to be ZODB?
You can access any database from Zope - if you want to store information in tables. You can access several different external relational databases from one zope. But the Zope Object Database (ZODB) is actually one the great features of Zope - you can just store objects without needing to convert from objects to rows. Most commonly people use the ZODB for storing templates, logic, etc and then connect to an external RDBMS to work with existing or tabular data. Zope makes this easy. If you really really want to use an RDBMS to store the actual ZODB, you can search for AdaptableStorage or DirectoryStorage, but that's quite advanced stuff and you'd need a good reason to do it. What are you actually trying to do? F.
If you really really want to use an RDBMS to store the actual ZODB, you can search for AdaptableStorage or DirectoryStorage, but that's quite advanced stuff and you'd need a good reason to do it.
AdaptableStorage (Ape, now, right?) maybe: it can do anything. DirectoryStorage is a file-system based storage, with nothing and nothing else to do with relational databases. Unless you consider the filesystem to be an RDB, in which case you're wrong. (The filesystem is a database, and usually a pretty good one, but it is not relational.) There are various specialized RDB-based storages: BerkleyDB, Oracle, maybe others. These map the ZODB into a relational database. I don't know that I'd prefer these over FileStorage or DirectoryStorage. --jcc
participants (2)
-
felix@chaptereight.com -
J Cameron Cooper