Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • I really enjoy using SQLite, especially since all it takes from Perl is install DBD::SQLite, and the whole database gets embedded inside the DBD handler!

    Between SQLite for the low end, and PostgreSQL for the high-end, there's really no need to use the crippled MySQL for any new installations. Joy.

    • Randal L. Schwartz
    • Stonehenge
    • Without getting all long and drawn out here, do you have some previous postings to point to so I can understand what leads you to state that MySQL is bad and PostgreSQL is good?

      I've skimmed over both of them slightly, and have no real opinions either way, but I don't feel like heading down the wrong track and having to back up and start over.
      • This might be slightly dated, but check out MySQL Gotchas. I consider the lack of reporting that data is too large for the storage to be showstopping, personally, even if the rest of it weren't true.

        Another showstopper is the licensing. Even the MySQL website advocates a commercial license if you're doing any sort of money making with MySQL. On the other hand, PostgreSQL is completely free, being under the free'er-than-GPL BSD license. Since I work mainly with commercial clients, this can make a diffe

        • Randal L. Schwartz
        • Stonehenge
        • Hmm. What happened to my link: MySQL Gotchas [].
          • Randal L. Schwartz
          • Stonehenge
        • But no support for Windows. That is a showstopper for PostgreSQL. It is "coming" I know. I think FirebirdSQL is really good for high end stuff *and* it is cross-platform.

          I really like SQLite, as you can do some quick and dirty stuff with it.

          • As near as I can tell, PostgreSQL has been installed on my last three windows machines at work, under Cygwin. I have never used it, however.

            J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
        • Hmm, these are good things to know.

          I use Informix and Oracle at work, and would like a GPL database that is close to how they work.

          Sounds like PostgreSQL might be a much better fit.

    • It's sad that you have nothing better to do than be our resident anti-MySQL troll.

      See also: X is better than Y []

      I'm now adding a new reason to the list of reasons to use MySQL: "You're not associating with PostgreSQL zealots".
  • Would you mind if I add this script to the docs as a getting started example? One of the regular complaints I get is people saying while it's trivial to install, they still have no idea how to use it.
    • Would you mind if I add this script to the docs as a getting started example?

      You're absolutely welcome to use this code or a modified version of it. I think the Term::ReadLine stuff might confuse some people. Maybe not. I've only recently come to enjoy the wonders of this module.

      I'm surprised just how compliant SQLite is. It seemed to handle natural joins well. I didn't try LIKE statements, but I've got a larger dataset with which to experiment.

      SQLite appears to be an excellent solution for those s