I remember when I worked in Ingres we used "Ingperl" and when the Perl DBD
for Ingres came out we migrated all our perl scripts away from Ingperl. I'm
contemplating introducing Perl on our servers (management fear of anything
bar shell scripts being ignored) and I'm wondering if anyone can weigh up
the pros and cons for Sybperl and DBD::Sybase. Are people gradually moving
onto DBD? Is Sybperl dominant? What are the functionality benefits from
each? Any views welcome.

TIA,
Martin

On Fri, 07 May 2004 13:56:48 +0100, Martin Hanna wrote:

There's some info on my home page (http://www.mbay.net/~mpeppler) and
http://www.peppler.org/

I should point out that "sybperl" is not a separate binary anymore, but
rather the name for a set of modules (Sybase::CTlib, etc) that provide
access to the OpenClient libs.

Personally I tend to use the Sybase::Simple, which is a simple module
built on top of Sybase::CTlib.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

"Martin Hanna" <postmaster (AT) SPAMIGNOREmovillaIGNOREplus (DOT) com> writes:

Sybperl includes perl wrappers for dblib and ctlib. Ctlib is slightly
more modern but both of them are essentially C APIs. I find the DBI
interface much more convenient, particularly for error handling. A
bonus is that you can use the same style of code for Sybase and other
RDBMSes. I haven't tried the Sybase::Simple module included with
sybperl.

--
Ed Avis <ed (AT) membled (DOT) com>

"Ed Avis" <ed (AT) membled (DOT) com> wrote

That's my key interest. If I can code a connection to the DBI, whether the
DBD is Sybase, Sql Server, Oracle or whatever, the code change is minimal or
none.

Martin

On Sat, 15 May 2004 00:40:04 +0100, Martin Hanna wrote:

Within limits. Between SQL Server and Sybase this is mostly true, as they
both talk T-SQL. With Oracle there will be some differences.

And to get good performance at the database server level we often use
server-specific SQL, which makes the code non-portable.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html