http://www.perlmonks.org?node_id=1011671


in reply to Re^2: Writing a database lookup tool
in thread Writing a database lookup tool

"Do you have any input on the pros and cons of sqlite+DBI (or any other perl module) versus Solr"

Apache Solr isn't comprable to SQLite/DBI. It's not a RDBMS, why are you trying to make comparisons where there are none to be made?

"Can either be packed into an exe with par packer?"

DBD::SQLite can be packaged with pp. If you'd actually read what Solr is you wouldn't consider asking if it could be packaged. It simply doesn't make sense to do so.

"Would every user need to install sqlite or other software separately?"

No.

Replies are listed 'Best First'.
Re^4: Writing a database lookup tool
by elef (Friar) on Jan 04, 2013 at 16:41 UTC
    "Apache Solr isn't comprable to SQLite/DBI. It's not a RDBMS, why are you trying to make comparisons where there are none to be made?"
    I don't know, perhaps because the two of them were suggested as alternative means of achieving the same end?

    "DBD::SQLite can be packaged with pp."
    Thanks.

    "If you'd actually read what Solr is you wouldn't consider asking if it could be packaged. It simply doesn't make sense to do so."
    There is a Solr CPAN module. I would have thought that it's reasonable to ask whether it is self-contained or requires that solr be installed separately, and whether it can be packaged or it has un-packable dependencies. I guess that using Solr would mean that every user needs to install Lucene/Solr.

    "Would every user need to install sqlite or other software separately? - No"
    I guess that only applies to DBD::SQLite then.

    If you are annoyed about beginner questions in a thread that explicitly states that it is about beginner questions and feeling around for possible options/feasibility, there is nothing wrong with just not posting in it. If you decide to try and help, there is no reason to get irritated.

      "I don't know, perhaps because the two of them were suggested as alternative means of achieving the same end?"

      I suggested it as a pre built solution for basing a tool on, rather than inventing a tool. At no point did I suggest they did the same thing. Because you can use a product or build your own to achieve a goal does not mean they're the same. You're jumping to conclusions again rather than researching the suggestions already given.

      "There is a Solr CPAN module. I would have thought that it's reasonable to ask whether it is self-contained or requires that solr be installed separately, and whether it can be packaged or it has un-packable dependencies. I guess that using Solr would mean that every user needs to install Lucene/Solr."

      The Solr module documentaion explains what it is. Had you looked there and in the Solr documentation is then you'd know the answer. Is there anything stopping you actually researching these questions before posting?

      " If you are annoyed about beginner questions in a thread that explicitly states that it is about beginner questions and feeling around for possible options/feasibility, there is nothing wrong with just not posting in it. If you decide to try and help, there is no reason to get irritated.

      I'm not in the slightest annoyed. I find it curious however that you don't seem to want to do any research yourself, simply relying on the advice of others while making crazy assumptions about things rather than actually read what they do.

      Update: For example here you spend time, again stating what you expect a reasonable person to provide when it'd take you less time to build test cases and generage actual output for use as a metric.