Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
I think, this question would be a better fit for – 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… post – CoatedMoose Nov 4 '12 at 20:55
up vote 0 down vote accepted

Question was ultimately answered on superuser.

The solution is to compile sqlite3 with readline support.

share|improve this answer

Your Answer


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.