Cursor keys not working when using sqlite3 from adb shell
adb, android, readline, sqlite
Solution
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.)
Problem
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?