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 am using sqlite3 on a machine where I can use tab completion (ie .read abc 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.

Originally posted on dba.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Compile the program with readline supoort. Readline is a common library that handles user input in interpreters such as bash and python. Fetch the source, the dependencies and configure with:

user@computer in: ~/src/sqlite-autoconf-3071602
$ ./configure --enable-readline=yes

Consult the INSTALL file for details. Also, it's worth mentioning that there are probably binaries of sqlite3 with readline support already packaged for your distro. Look around.

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.