I have started sqlite3 and pressed up arrow over ssh session (RPI 4):
osmc@rpi4:~$ sqlite3
-- Loading resources from /home/osmc/.sqliterc
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> ^[[A
As you can se I have got “^[[A” instead of previous command from history.
Why?
If I exit sqlite3, while still in ssh shell session, up arrow works as expected (I can get bash history).
Doesn’t look like sqlite3 is complied with readline support. A google search would indicate that compiling with support, isn’t as straight as it should be.
I can get it to work as expected with rlwrap as suggested in the link.
Tom was faster, my suggestion was to force it in your ssh-client instead, but it’s better to do it in the remote OS, and define to which apps. Since what ever client setting you set, the server (osmc device in this case) can override it. But setting it in the “server os” well that solves the issue.
If it was a one time occurrence, it could be a lag spike in the connection too. ( more common in Serial connections. but can occur in modern network too.)