Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I had the sqlite3 package installed on Ubuntu and there's no support for readline. That means there's no command history and those other nifty features readline gives you.

Is this a configuration or a packaging problem? Is there a different package archive somewhere that would give me readline support out of the box? Or else, how do I compile sqlite3 myself making sure it has readline support?

share|improve this question
add comment

2 Answers 2

up vote 14 down vote accepted

You could always use rlwrap:

rlwrap sqlite3 database.db

FYI, I just checked my hardy heron install, and its sqlite3 does have readline support.

share|improve this answer
    
Didn't know about rlwrap. Really great, thanks! I'm using the sqlite3 package in Kubuntu Jaunty Jackalope and, for some reason, it didn't come with readline support. –  obvio171 Dec 14 '09 at 13:20
add comment

I add another answer because this is the first hit for "ubuntu sqlite3 readline" on google:

The android SDK installs its own version of the sqlite3 binary. This binary does not provide readline support. If you added the Android SDK to your path this might make you think you have no readline support, in fact every Ubuntu package is compiled with readline support.

Also see this Ubuntu Bug Report which describes the same situation.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.