android - Cursor keys not working when using sqlite3 from adb shell

Question

When using sqlite3 through adb shell arrow keys, instead of moving the cursor to the desired position or summoning the history facility, the following is showed in the screen: ^[[A, ^[[B, ^[[C, ^[[D.

I'm using Mac OS X and I have tried Terminal and iTerm terminal emulators.

Does anybody know how to fix this?

Answer 1

To allow editing and history in the input of a console program, that program must be linked with the readline library.

The sqlite3 tool does support readline, but on Android, readline support has been disabled. (Probably because readline is licensed only under the GPL.)