Googie I missed console (*nix) manager for SQLite that supports input line history and interactive editing query, so I've wrote one. It's build on top of Unix pure-Tcl readline [L1 ].
It's pretty similar to binary application sqlite3 but has some advantages:
- Supports input history, so you can use up/down keys to edit and reexecute your query (just like readline lets),
- You can use left/right and home/end keys to move across a query string and edit it (just like readline lets too),
- It always uses the same SQLite interface version as other scripts on the host, so you'll not get problems when you've created database by another script with one interface version and you're trying to read/modify it by the manager.