in reply to Perl in the database?

This sounds pretty nifty. I'd love to try playing with it. *mumble* years ago, I wrote an Open Server much as you describe: it retrieved stock quotes and prices from several different sources and presented them with a unified interface. (I say "I" but in fact I led a group of 5-10 developers.) Essentially we used TDS as a network transport protocol -- your post doesn't make this obvious, but TDS is a distributed protocol.

One problem I see with this is TDS being tied to Sybase (and now Microsoft). The client for whom I wrote that Open Server is slowly moving away from Sybase -- for various reasons, not all of them technical. That includes slowly decomissioning all Open Servers. But if you're in a dedicated SQL Server shop, I agree it would be very nice to be able to generate result sets from Perl code.

Are you planning on putting this on CPAN?

Replies are listed 'Best First'.
Re: Re: Perl in the database?
by mpeppler (Vicar) on Mar 20, 2002 at 20:42 UTC
    Are you planning on putting this on CPAN?

    I don't know yet - it depends on whether this actually works the way I hope it will.
    And you have to have the Open Server libraries, which most people won't have as they are not included in the default package from Sybase.

    Michael

[reply]
      Michael

      I would love an XP Server library running Perl!

      You could set up a sourceforge project for this, I think you'll find lots of help.

      If you use XP Server and a shared lib, you have everything you need, you don't need any additional libraries.

[reply]
      And you have to have the Open Server libraries, which most people won't have as they are not included in the default package from Sybase.

      I entered this thread a little late, but hopefully it is still active.

      Have you used the FreeTDS libraries? Will they provide the functionality you need? According to the FAQ on freetds.org, libtdssrv may provide some server capabilities.

      Of course, not being an Open Server programmer, I can't really evaluate whether it would be possible or not. It would sure be nice if FreeTDS developed to the point where a full Open Client/Open Server implementation were possible.

      -----
      "Computeri non cogitant, ergo non sunt"

[reply]
        I'm not going to use FreeTDS initially. They are doing a great job, but FreeTDS is still too limited in scope to be used as the basis for such a tool (at least for me).

        Michael

[reply]

In Section Meditations