Interbase 6.0 will be open source for all platforms according to the open source Q&A at interbase.com : http://www.interbase.com/open/community/opensource_qa.html. The current version (5.6) is still commercial however. The 6.0 version comes with a user defined function library which includes date functions (I had the same problem when I started to use Interbase - found a UDF library, from Canada I think - NT only however) It also now has an Extract operator to work with the datetime datatype. I've been using Interbase since version 4.0 (about four years). I have it in use with up to 35 users simultaneously. I don't know how well it would scale to very large systems. I also would like to see an Interbase DA for Zope. I'm not enough of a Python programmer yet to do it myself, but I might have to bite the bullet and try. Bob Corriher Original Message Message: 55 Reply-To: "Ian Sparks" <isparks@wmute.u-net.com> From: "Ian Sparks" <isparks@wmute.u-net.com> To: <bkc@murkworks.com>, <zope@zope.org> Subject: Re: [Zope] Interbase DB Date: Fri, 5 May 2000 18:42:54 +0100 charset="iso-8859-1" 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 __________________________________________
After a few hours of futzing around and trying to get Kinterbasdb (the python DB-API2 module for Interbase) working against Interbase 4.0 for linux, I have the following report: - Kinterbasdb will not compile against the libraries distributed with the beta of IB6 'SuperServer'. - Kinterbasdb compiles wonderfully against the libraries included with Interbase 4. However, because I'm running Red Hat with glibc 2.1.2, and the interbase libraries are statically linked against an older libc, upon attempting to use the Kinterbasdb module, I get: ImportError: ./_kinterbasdb.so: undefined symbol: _xstat I suppose some waving of dead chickens over the Makefile could solve this. After careful consideration, I don't care. - Evidently Kinterbasdb compiles against Interbase 5.X (which I would presume is linked against a later glibc), but Interbase 5.X is not available for download (it's still a commercial product). I'm not real keen on futzing more with this. I hope Alexander K. (the author of Kinterbasdb) revs the code soon to compile against Interbase 6. Until then, I give up. bobc@p-wave.com wrote:
Interbase 6.0 will be open source for all platforms according to the open source Q&A at interbase.com : http://www.interbase.com/open/community/opensource_qa.html. The current version (5.6) is still commercial however. The 6.0 version comes with a user defined function library which includes date functions (I had the same problem when I started to use Interbase - found a UDF library, from Canada I think - NT only however) It also now has an Extract operator to work with the datetime datatype. I've been using Interbase since version 4.0 (about four years). I have it in use with up to 35 users simultaneously. I don't know how well it would scale to very large systems. I also would like to see an Interbase DA for Zope. I'm not enough of a Python programmer yet to do it myself, but I might have to bite the bullet and try.
Bob Corriher
Original Message
Message: 55 Reply-To: "Ian Sparks" <isparks@wmute.u-net.com> From: "Ian Sparks" <isparks@wmute.u-net.com> To: <bkc@murkworks.com>, <zope@zope.org> Subject: Re: [Zope] Interbase DB Date: Fri, 5 May 2000 18:42:54 +0100 charset="iso-8859-1"
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 )
-- Chris McDonough Digital Creations Publishers of Zope - http://www.zope.org
- Kinterbasdb will not compile against the libraries distributed with the beta of IB6 'SuperServer'.
Really? What problem did you have? I was able to get this to compile against IB6, and I don't remember jumping through any unusual hoops to do so. Now, getting it run -- that was another matter entirely. ;-) My system is Debian potato. I used Kinterbase 0.2.1, and the IB6 beta. I think I had to add -lcrypt to the Makefile. Eric W. Sink, Software Craftsman SourceGear Corporation eric@sourcegear.com
Well, after trying for another 15 minutes, I was able to do it. Thanks Eric... I had to change the config.sh file directive GDSLIB to GDSLIB=gds.so instead of leaving it blank (as well as compile with -lcrypt). Now, I wonder if it works. "Eric W. Sink" wrote:
- Kinterbasdb will not compile against the libraries distributed with the beta of IB6 'SuperServer'.
Really? What problem did you have?
I was able to get this to compile against IB6, and I don't remember jumping through any unusual hoops to do so. Now, getting it run -- that was another matter entirely. ;-)
My system is Debian potato. I used Kinterbase 0.2.1, and the IB6 beta. I think I had to add -lcrypt to the Makefile.
Eric W. Sink, Software Craftsman SourceGear Corporation eric@sourcegear.com
-- Chris McDonough Digital Creations Publishers of Zope - http://www.zope.org
Well, after trying for another 15 minutes, I was able to do it. Thanks Eric... I had to change the config.sh file directive GDSLIB to GDSLIB=gds.so instead of leaving it blank (as well as compile with -lcrypt).
Now, I wonder if it works.
No, it doesn't. :-) In kinterbasdb.c, server_version() will choke. This is because ver_callback() receives the version strings from IB6 and tries to parse them, evidently expecting to find the letter V in a place where there is in fact no letter V. I hacked server_version() to say: version = 6 and return. A rather short-term workaround, I admit. After this, you are as far along as I've gotten. I was able to execute simple stuff through Kinterbasdb, but I haven't tried anything complicated yet. -- Eric W. Sink, Software Craftsman SourceGear Corporation eric@sourcegear.com
Date sent: Sun, 07 May 2000 18:49:08 -0400 From: Chris McDonough <chrism@digicool.com> Organization: Digital Creations To: bobc@p-wave.com Copies to: isparks@wmute.u-net.com, zope@zope.org Subject: Re: [Zope] Somewhat OT: Interbase DB Hi Chris, There's a post at http://weblogs.userland.com/qube/discuss/msgReader$497 from Markus Kemper of Interbase.com which indicates that they would like to work with the Zope community and are also looking for Python/Zope programmers. Perhaps they could spearhead the effort to get the Python libraries up to date for Interbase 6.0. I saw another post which said they got no reply from the author of Kinterbasdb, so perhaps he is no longer active. If I was a little farther along on Python programming myself, I'd give it a try. Come to think of it, it might be good training. Bob Corriher P-Wave.com
After a few hours of futzing around and trying to get Kinterbasdb (the python DB-API2 module for Interbase) working against Interbase 4.0 for linux, I have the following report:
- Kinterbasdb will not compile against the libraries distributed with the beta of IB6 'SuperServer'.
- Kinterbasdb compiles wonderfully against the libraries included with Interbase 4. However, because I'm running Red Hat with glibc 2.1.2, and the interbase libraries are statically linked against an older libc, upon attempting to use the Kinterbasdb module, I get:
ImportError: ./_kinterbasdb.so: undefined symbol: _xstat
I suppose some waving of dead chickens over the Makefile could solve this. After careful consideration, I don't care.
- Evidently Kinterbasdb compiles against Interbase 5.X (which I would presume is linked against a later glibc), but Interbase 5.X is not available for download (it's still a commercial product).
I'm not real keen on futzing more with this. I hope Alexander K. (the author of Kinterbasdb) revs the code soon to compile against Interbase 6. Until then, I give up.
bobc@p-wave.com wrote:
Interbase 6.0 will be open source for all platforms according to the open source Q&A at interbase.com : http://www.interbase.com/open/community/opensource_qa.html. The current version (5.6) is still commercial however. The 6.0 version comes with a user defined function library which includes date functions (I had the same problem when I started to use Interbase - found a UDF library, from Canada I think - NT only however) It also now has an Extract operator to work with the datetime datatype. I've been using Interbase since version 4.0 (about four years). I have it in use with up to 35 users simultaneously. I don't know how well it would scale to very large systems. I also would like to see an Interbase DA for Zope. I'm not enough of a Python programmer yet to do it myself, but I might have to bite the bullet and try.
Bob Corriher
Original Message
Message: 55 Reply-To: "Ian Sparks" <isparks@wmute.u-net.com> From: "Ian Sparks" <isparks@wmute.u-net.com> To: <bkc@murkworks.com>, <zope@zope.org> Subject: Re: [Zope] Interbase DB Date: Fri, 5 May 2000 18:42:54 +0100 charset="iso-8859-1"
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 )
-- Chris McDonough Digital Creations Publishers of Zope - http://www.zope.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In article <3915F2E4.EAA574BA@digicool.com>, Chris McDonough <chrism@digicool.com> writes
- Evidently Kinterbasdb compiles against Interbase 5.X (which I would presume is linked against a later glibc), but Interbase 5.X is not available for download (it's still a commercial product).
Interbase 5.6 upgrade ( which is the full thing anyway ) is available for download. You can use the codes eval, and eval to activate it for 90 days. - -- 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/AwUBORXtnbTRdIWzaLpMEQIozwCfTpMY8iN0ODDxQHr+D0cpHDp6qxsAoNpe i9Fx7DCl5Xqbr12wUYQcj+Qw =4CUi -----END PGP SIGNATURE-----
participants (4)
-
bobc＠p-wave.com -
Chris McDonough -
Eric W. Sink -
Graham Chiu