[issue33436] Add an interactive shell for Sqlite3

Diego Ramirez added the comment: Do we still want to do this? See https://discuss.python.org/t/titling-sqlite3-table-columns-with-number/13656/3. -- nosy: +DiddiLeija versions: +Python 3.10, Python 3.11, Python 3.9 ___ Python tracker

[issue33436] Add an interactive shell for Sqlite3

Erlend Egeberg Aasland added the comment: I think this is a good idea. Proof-of-concept implementation added (invoke REPL with `python -m sqlite3`). Possible improvements: - Use sqlite3.complete_statement() - Support Python syntax as well. For example: >>> select * from t >>> res = _ >>>

[issue33436] Add an interactive shell for Sqlite3

Big Stone added the comment: as a graphical sqlite browser, you have sqlite_bro that may give you inspiration. It's about one single file. -- nosy: +Big Stone ___ Python tracker

[issue33436] Add an interactive shell for Sqlite3

Serhiy Storchaka added the comment: It could be added in Tools/scripts directory or as a part of the sqlite3 module. > It's not immediately obvious what benefits this provides over the existing > sqlite-native repl and the python repl. The existing sqlite-native

[issue33436] Add an interactive shell for Sqlite3

R. David Murray added the comment: It's not immediately obvious what benefits this provides over the existing sqlite-native repl and the python repl. Can you expand a bit on the use case? Also, I seem to remember that Catherine Devlin had at one point thought about

[issue33436] Add an interactive shell for Sqlite3

New submission from Raymond Hettinger : To facilitate rapid experimentation with SQL queries, add a shell to run commands and display results. Attached is minimal proof-of-concept modeled loosely on the Linux sqlite3 REPL. Here's a sample session: SQLite