[Zope] sql access style
I'm about to create a Zope (Plone, in fact) application, as a Package, that will operate on data accessible via SQL (Firebird RDBMS). I'm ordered the data must stay in SQL storage, not in ZODB. Recently I found, outside of Zope, that using python-kinterbasdb module is very straighforward and easy. It's simply about writing SQL statements to Python code. Until then I thought I'll use usual ZSQL Methods for each SQL statement in the application, but kinterbasdb seems to allow a quickier developing. First thing that arises is that I will need to keep the persistent connection reference in the product instance, but it's bearable IMHO. I'm unexperienced in this, please may I hear pros/cons of each method? Thanks in advance. -- \//\/\ (Sometimes credited as 1494 F8DD 6379 4CD7 E7E3 1FC9 D750 4243 1F05 9424.) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] sql access style
Vlada Macek wrote: I'm about to create a Zope (Plone, in fact) application, as a Package, that will operate on data accessible via SQL (Firebird RDBMS). I'm ordered the data must stay in SQL storage, not in ZODB. Recently I found, outside of Zope, that using python-kinterbasdb module is very straighforward and easy. It's simply about writing SQL statements to Python code. Until then I thought I'll use usual ZSQL Methods for each SQL statement in the application, but kinterbasdb seems to allow a quickier developing. First thing that arises is that I will need to keep the persistent connection reference in the product instance, but it's bearable IMHO. I'm unexperienced in this, please may I hear pros/cons of each method? You might look at ExtZSQL:http://www.zope.org/Members/jccooper/extzsql It is made for using RDBMS in Zope products. --jcc -- Building Websites with Plone http://plonebook.packtpub.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )