SQLite Forum

sqlite3 history error in vscode terminal
Login
I'm Using the vscode wsl terminal with distro Ubuntu 20.04.

If I install sqlite3 with 'sudo apt install sqlite3' I get version 3.33 and, when running sqlite3, the arrow up/down keys allow me to scroll through the history of previous commands and the left/right keys allow me to move through the current command to correct errors. 

If I use the sqlite3 executable created by the configure and make scripts in the trunk I get version 3.35 but pressing arrow up, arrow down, arrow left, arrow right while running sqlite3 shows

sqlite> ^[[A^[[B^[[D^[[C

There is another problem in vscode terminal with both the aforementioned versions in that if you're on the bottom line and enter a particularly long command the text wraps and then overwrites the bottom line rather than scroll the window up and continue the text on the new bottom line. This I suspect is a vscode problem and I've reported it on github but I'm not sure about the arrow key problem.