I am using sqlite3 on a machine where I can use tab completion (ie .read abc<tab> will autocomplete to .read abcdefghij.db. I would like to know how to enable this on my personal machine.


Both machines are ubuntu linux and the shell is bash. I am referring to autocompletion in the sqlite interactive prompt.

  • I think, this question would be a better fit for superuser.com – dezso Nov 4 '12 at 20:16
  • Updated to answer questions. And I am curious why this doesn't qualify as database administration. (I can take the question elsewhere if this isn't the appropriate place for it, but I'd like why it isn't appropriate.) – CoatedMoose Nov 4 '12 at 20:22
  • I think this is more of an OS than DB thing, but never mind. If you get an answer here, then it's quite OK, I just thought that SU would be a place for getting an answer faster :) (See also the FAQ, if you haven't already seen it.) – dezso Nov 4 '12 at 20:28
  • I see, I figured that since it was referring to the databases prompt this would be the better option. Here is the su superuser.com/questions/499634/… post – CoatedMoose Nov 4 '12 at 20:55

Question was ultimately answered on superuser.

The solution is to compile sqlite3 with readline support.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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