sqlite, sqlite3, and CPAN equivalents in Ubuntu and Fedora

So I ran into an issue today, while working trying to port a program from Ubuntu to Fedora, involving Sqlite and Sqlite3 and CPAN.

sqlite (2.8)

Ubuntu:    sudo apt-get install sqlite
Fedora:    su -c 'yum install sqlite2'

sqlite3 (3.0+)

Ubuntu:    sudo apt-get install sqlite3
Fedora:    su -c 'yum install sqlite'


Ubuntu:    Installed by default
Fedora:    su -c 'yum install perl-CPAN'

7 thoughts on “sqlite, sqlite3, and CPAN equivalents in Ubuntu and Fedora

  1. Kasper Henriksen says:

    I’ve always found it odd how the Debian (and hence Ubuntu) repositories have a lot of CPAN modules repackaged as debian packages, i.e. most of what is found by apt-cache search ^lib.*perl$

    Not that it bothers me, but occasionally the Ubuntu repository is a bit out of date which can lead to problems with newer stuff. I ran in to a problem with Net::Twitter and a patched version of tircd recently (the tircd package that Ubuntu ships is painfully out of date and basically just sits there spitting out HTTP errors) where I had to purge libnet-twitter-perl and other dependancies of the tircd package and install them with sudo cpan -i instead.

    Just a heads-up to people out there who work with bleeding edge stuff (bleeding edge + perl5… kinda feels wrong to say that considering how old it is).

    • Using cpan is obviously one of the worst ways to install perl modules; as it works around the package manager. Using cpan2deb from dh-make-perl, you can easily build many CPAN packages; I have just built two ones a few days ago. And this way you get normal Debian packages.

      Scripting languages have serious problems with module distribution. Everyone invents their own system and users use those systems although it is the job of the system package management tools. All those ruby gems, perl CPAN and Python with easy_install. This is all completely wrong; and if there were no Windows; those things would not be needed.

      • David says:

        It’s not because of Windows, but because of multiple platforms that these module distribution systems exist. It’s too much work to package stuff for Windows, Mac, and all the Linux/Unix packaging systems out there.

        Personally, I prefer those systems over the package manager, as the package manager
        1. requires that the distro keeps libs up to date (which they often times don’t)
        2. bug fixes get to you much later
        3. you don’t get new features until the next distro release (if you’re lucky)

  2. Kirk says:

    Interesting article, thanks for posting

  3. Wes Wieland says:

    Ran into this issue this evening. Package manager for Ubuntu left me with well over a thousand modules with old revs, addmittedly minor revs in most cases, but some major revs as well… What worked for me was to go back to the original repository… I just did:

    perl -MCPAN -e shell

    Worked like a charm! I am finding that many of the applications and tools that I use are well ahead of Ubuntu’s packages. This includes things like e17, most of the graphics applications that I use as well as little apps like calibre. I seem to be adding about 1 ppa source a week to make up for the difference between the disto packages and the actual app providers. Not really anyones fault, just the way it is…

  4. denis says:

    I like to use with sqlite on ubuntu – free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview at the moment. Does everything you need, and does it very well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s