Enable autocomplete in an sqlite3 interactive shell

Question

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.

Edit

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 http://superuser.com/ — András Váczi, Nov 04 '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 04 '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.) — András Váczi, Nov 04 '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 http://superuser.com/questions/499634/enable-autocomplete-in-an-sqlite3-interactive-shell post — CoatedMoose, Nov 04 '12 at 20:55

score 4 · Accepted Answer · edited Mar 20 '17 at 10:04

4

Question was ultimately answered on superuser.

The solution is to compile sqlite3 with readline support.

edited Mar 20 '17 at 10:04

Community

1

answered Mar 09 '14 at 06:51

CoatedMoose

221
2
8

Enable autocomplete in an sqlite3 interactive shell

1 Answers1