A ZopeDA for Interbase..I really hope so... Id also be very interested. Ive been using Interbase for only a few weeks now, and I'm *very* impressed. It is way ahead (for my purposes, at least) of anything else available on Linux through any kind of open-source license. I think Interbase was the first RDBMS to support BLOBs (binary objects) and it is the first *open-source* database to reliably support referential integrity, triggers and stored procedures.. (like the well-known commercial offerings, which Interbase was until a few months ago.) It has a reputation for being *extremely* stable and it is a very mature and well-engineered product. (It used to be owned by DEC, from what I understand, before they were assimilated by Compaq.) It is currently owned by Corel/Inprise. (I am pretty sure) I'm a newbie to SQL (and Zope) but now that I am building my first full-sized SQL project, I can see that key features like foreign keys/referential integrity are very important in any kind of serious SQL work. I started this project thinking I would use MySQL, but I quickly realized that MySQL couldnt handle the foreign key construct I was assuming I could use.. I guess I could have added extra tables to my design to simulate foreign keys in MySQL, but when I heard about Interbase, I was overjoyed. After deciding on Interbase then I went looking for some middleware to connect my database to the Web, and guess where I ended up after a *lot* of research.. here... Like Interbase, Zope is perfect for what I have planned for my project. There has been a fair amount of discussion of Zope over on the Interbase list, and I and everyone else I have spoken to that knows anything about these things agrees, the two are natural partners. Chris Beaumont webmaster, MSRI www.msri.org Jason Cunliffe wrote:

...

On 4 May 2000, at 17:12, Tom Deprez wrote:

...

I'm using Kinterbasdb with SQLDict in an extension module and calling that from Zope.

I'd also like to see a true Zope DA for Interbase.. Not sure where's the best place to start to write one...

We are very interested also in using Interbase with Zope. ZopeDA for Interbase would be a GOOD thing.

Meanwhile, if you care to share some of your experiences writing and using your Extension Module,its code or how-to then that would be a great help in getting up to Interbase speed.

tia

- Jason

_______________________________________________ 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 )

Don't think so. It was Interbase alone - then purchased by Ashton-Tate, then by Borland/Inprise.

Don't know, but I do know that a few months back (until jan 2000) Interbase was shipped as a commercial version and was included in the Borlands Delphi, C++ Builder, .... products... Tom.

On 5 May 2000, at 10:48, Tom Deprez wrote:

Yes Brad,

Is it possible to write a how-to on you experiences with the extension module? And how you manage to get it to work?

An how-to for what part? Using SQLDict with Interbase (simple, just pass SQLDict a database connection) or Using SQLDict with Zope (simple, just return an SQLDict object to Zope from an extension module) Just to re-iterate, I do not have a Zope IB DA .. which I'll probably wan't soon. Brad Clements, bkc@murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

On 5 May 2000, at 9:38, Olivier Deckmyn wrote:

When looking for Interbase on python.org, one can find :

http://www.python.org/topics/database/modules.html

where there seem to exists at least one python module to connect to Interbase RDBMS ...

This could be a starting point for a DAInterbase?

Yes, thats Kinterbasdb. I wrote to the author a few weeks ago, but never received a reply. Brad Clements, bkc@murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In article <005401bfb6b3$8a539d40$a274f6ce@ihosts.net>, J. Michael Mc Kay <admin@ihosts.net> writes

Anybody know what the licensing deal is for IB on NT for web applications?

Interbase 6.0 will be free. - -- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin -----BEGIN PGP SIGNATURE----- Version: PGPsdk version 1.7.1 iQA/AwUBORKHAbTRdIWzaLpMEQKpzACdH6Ssw5gag/Lq2rPCKWMECWX6gcoAoO+m JGafzxhf68wYtBEMYjxNXdzK =opK9 -----END PGP SIGNATURE-----

This may not help at all but I know there is a Perl interface to Interbase - saw it at www.interbase.com a while back. Can I ask why the interest in Interbase over, say, PostgreSQL I've been using Interbase on NT for a few years now. It's stable, zero maintenance, hard-to-kill and has decent features like triggers, stored procedures etc. The one thing that lets it down is the built-in functions - you really need to get a User Defined Functions (UDF) library from day 0 and install it to do any sort of date manipulation for instance. My problem with this is that it makes your DB code hard to port between platforms - that UDF lib you use on NT won't work on Linux - esp. since UDF libs are often written in Delphi and thus tied to Win32 (at least until Kylix is released). I also notice that Interbase don't seem to offer a free version to NT users - that's because they have so many NT customers who already bought licences who will want refunds! One final notice is that Interbase only became Open Source after its key members of its development team walked out in protest over the way that the parent company was pushing (or not) the product. How can Interbase.com turn this crisis into an opportunity? OpenSource it! - Ian Sparks. ----- Original Message ----- From: "Brad Clements" <bkc@murkworks.com> To: <zope@zope.org> Sent: Friday, May 05, 2000 3:25 PM Subject: Re: [Zope] Interbase DB On 5 May 2000, at 9:38, Olivier Deckmyn wrote:

When looking for Interbase on python.org, one can find :

http://www.python.org/topics/database/modules.html

where there seem to exists at least one python module to connect to Interbase RDBMS ...

This could be a starting point for a DAInterbase?

Yes, thats Kinterbasdb. I wrote to the author a few weeks ago, but never received a reply. Brad Clements, bkc@murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements _______________________________________________ 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 )