Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: Querying eDOCS SearchServer Full-Text Search Engine From Perl

by roboticus (Chancellor)
on Jan 14, 2008 at 02:49 UTC ( #662243=note: print w/replies, xml ) Need Help??


in reply to Re: Querying eDOCS SearchServer Full-Text Search Engine From Perl
in thread Querying eDOCS SearchServer Full-Text Search Engine From Perl

Seconded! I normally use DBD::ODBC as my first choice for chatting with databases. Some claim that it's not very efficient, but I find it quite adequate.

...roboticus

  • Comment on Re^2: Querying eDOCS SearchServer Full-Text Search Engine From Perl

Replies are listed 'Best First'.
Re^3: Querying eDOCS SearchServer Full-Text Search Engine From Perl
by fenLisesi (Priest) on Jan 14, 2008 at 11:41 UTC
    But isn't it too slow and doesn't it have too much conceptual overlap with DBI to be the first choice?
      fenLisesi:

      I always access DBD::ODBC through DBI. (I don't know how to talk to it directly.) While some claim that ODBC is "slow", I've not found it to be slow for the standard SQL statements I use.

      I'm sure that it's probably significantly slower than other DBI backends for some workloads and or databases, but I haven't run across it yet.

      I tend to use it for simple DDL and DML manipulations with small tables (less than 10 million rows).

      ...roboticus

      Not sure about the speed, but I don't understand your second comment. DBD::ODBC is a DBD driver meant to be used with DBI. Did you mean that Win32::ODBC has too much conceptual overlap with DBI?
        Sure, I understand that DBD::ODBC is a DBD driver meant to be used with DBI. That is precisely what I thought was the problem.

        ODBC is a layer, is it not (I am really not an expert there), that gives you a standard way to access different kinds of database. DBI is a layer that gives you a standard way to access different kinds of database. I am sure one could generate enough material for ten threads just talking about their differences, but this is the conceptual overlap that I was talking about.

        By using DBD::ODBC as your go-to guy, aren't you condemning yourself to using two abstraction layers most of the time? PostgreSQL (or another database) at the bottom, ODBC on top of that, DBI on top of that and your logic on top. Town Musicians of Bremen, where the Dog and the Cat do similar gigs. What would we lose by putting the Dog out to pasture?

        There may well be problems (certain combinations of Perl, DB etc.) that are best (or only) solved by having the Dog in there, but I thought that wouldn't make the best default solution.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://662243]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (2)
As of 2020-10-26 22:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (254 votes). Check out past polls.

    Notices?