some advice for a news site
We have a project of a Web-zine that has to run on a Linux box. I heard about Zope and I'm impressed so far. The site will have functionality like "related news" and "send this to a friend". We also need to be able to categorize the content/news and search with keywords. There will be "subscribers" that will receive daily tips with links to the news on the Web site. Those will be stored in a RDBMS. We took a look at PHP3 and MySQL as an interesting choice, but after reading about Zope we would like to take the better alternative. Is it possible to use the Z ODB to store the news instead of a RDBMS, without loosing the functionality we need?... Maybe a combination of Zope and MySQL?. Any advice would be appreciated. Luis Bordas
On Wed, Dec 01, 1999 at 09:58:54PM -0400, Luis Bordas wrote:
We have a project of a Web-zine that has to run on a Linux box. I heard about Zope and I'm impressed so far.
The site will have functionality like "related news" and "send this to a friend". We also need to be able to categorize the content/news and search with keywords. Have you looked at Squishdot? It does provides a slashdot-like interface to news and is used by several sites (http://www.technocrat.net and http://www.kdeforum.org). Also, the source is available so you could use features from it or modify it to suit your needs. It is based on a more generic product called ZConfera by Digital Creations(??). Check the Zope site for more info on that.
There will be "subscribers" that will receive daily tips with links to the news on the Web site. Those will be stored in a RDBMS.
You could use a cron script with Python to grab the info from Zope (XML-RPC) and send the emails.
We took a look at PHP3 and MySQL as an interesting choice, but after reading about Zope we would like to take the better alternative.
I'll second that...PHP3 gets ugly when dealing with medium->large sites
Is it possible to use the Z ODB to store the news instead of a RDBMS, without loosing the functionality we need?... Maybe a combination of Zope and MySQL?.
Depends on the size of your data. With the ZMySQLDA (Zope MySQL Database Adapter), you can run queries on a MySQL database from Zope code and even encapulate the returned rows as objects! That way, you retain the flexibility of Zope while your data can be stored in MySQL. -- Stephen Pitts smpitts@midsouth.rr.com webmaster - http://www.mschess.org
Luis Bordas wrote:
We have a project of a Web-zine that has to run on a Linux box. I heard about Zope and I'm impressed so far.
The site will have functionality like "related news" and "send this to a friend". We also need to be able to categorize the content/news and search with keywords.
No problem there. You can model and implement news items a multiple number of ways within Zope. One would be to model your news items as "Z Classes" (a fancy word for a fairly simple abstraction that allows you to instantiate "things" [objects] in your ZODB that have properties [such as news text] and capabilities [such as the ability to render the text a certain way] of their own) Or if you prefer, you can store your news items in an RDBMS and use Zope to render the items. Or you could store news items on the filesystem and use Zope to render the items. Whatever best suits the requirement. Built in to Zope is the capability to send mail flexibly. Searching of items in the ZODB can be done via "ZCatalog" or you can roll your own search facility for items stored in an RDBMS or on the filesystem.
There will be "subscribers" that will receive daily tips with links to the news on the Web site. Those will be stored in a RDBMS.
This is fine, subscriber information doesn't need to be stored in an RDBMS with Zope, but you have that option.
We took a look at PHP3 and MySQL as an interesting choice, but after reading about Zope we would like to take the better alternative.
Most of us on this list would probably contend that Zope has at least as much to offer as the combination of PHP3 and MySQL and much more.
Is it possible to use the Z ODB to store the news instead of a RDBMS, without loosing the functionality we need?... Maybe a combination of Zope and MySQL?.
News items are a prime candidate for storage in ZODB, because they'll probably just be a combination of text and images which are two data types that are well supported :-). However, you can put just about anything in there. One guy even stores his MP3s in his Zope installation, if I recall correctly. MySQL is sort of deprecated for use with Zope because it doesn't support transactions. Zope has a strong affinity for transaction-based RDBMSes. This doesn't mean you can't use MySQL (there is a Zope database adapter for MySQL), but its not really recommended (or supported). I guess the stock answer in the case that you want a free database would be for me to suggest you use PostgreSQL (which supports transactions and is free, don't know if its "officially" supported). However, Zope works well with many other SQL RDBMSes too... like, oh, say.. Oracle. Or Sybase. A "pure" Zope implementation would probably be based around the ZODB and more than likely would include ZClasses. It would probably not include links to an RDBMS. This may or may not meet your requirements. It doesn't really sound like you *need* an RDBMS... an example situation where you might need one would be that you have data already stored in one and you need to get at it from Zope... another example situation would be that you want to use Zope to display the information stored in the RDBMS, but you want to use other tools (such as Microsoft Access, etc.) to manage the data...
Any advice would be appreciated.
Luis Bordas
If it meets your requirements, we love to see new Zope sites come up. You may want to read http://www.zope.org/Resources/QA for the 100,000-foot overview of Zope. HTH, -- Chris McDonough Digital Creations, Inc. Zope - http://www.zope.org
Is it possible to use the Z ODB to store the news instead of a RDBMS, without loosing the functionality we need?... Maybe a combination of Zope and MySQL?.
The only thing to watch out for is the 2GB file size limit on Linux. The ZODB is one big file, and it's not always tightly packed, so 100MB of data will take up more space on disk. This is a limitation of the ext2 filesystem, so it's a linux thing, not a zope thing. I haven't come anywhere near to hitting this wall, so I don't know what, if any, workarounds there are to this. ----------------------------------------------------------------- Karl Fast
Karl Fast wrote:
The only thing to watch out for is the 2GB file size limit on Linux. The ZODB is one big file, and it's not always tightly packed, so 100MB of data will take up more space on disk.
This is a limitation of the ext2 filesystem, so it's a linux thing, not a zope thing. I haven't come anywhere near to hitting this wall, so I don't know what, if any, workarounds there are to this.
A relatively easy workaround would be to use ReiserFS, which should handle a lot more. http://devlinux.com/projects/reiserfs
----------------------------------------------------------------- Karl Fast
_______________________________________________ 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 )
Shane Hathaway wrote:
A relatively easy workaround would be to use ReiserFS, which should handle a lot more. http://devlinux.com/projects/reiserfs
Nope - ext2 can also handle >2GB files. It's some other part of the kernel that has this problem on 32-bit machines, but there's a patch that fixes the problem. -- Itamar S.T. itamars@ibm.net
participants (6)
-
Chris McDonough -
Itamar Shtull-Trauring -
Karl Fast -
Luis Bordas -
Shane Hathaway -
Stephen Pitts