[issue33436] Add an interactive shell for Sqlite3

[Diego Ramirez]

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 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue33436] Add an interactive shell for Sqlite3

[Erlend Egeberg Aasland]

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 = _
>>> print(res[0])

--
keywords: +patch
nosy: +erlendaasland
Added file: 
https://bugs.python.org/file49199/0001-Add-proof-of-concept-REPL.patch

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue33436] Add an interactive shell for Sqlite3

[Big Stone]

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 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue33436] Add an interactive shell for Sqlite3

[Serhiy Storchaka]

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 repl is not always installed when Python is 
installed (especially on Windows). It is handy that Python provides CLI to some 
modules, including zipfile and tarfile.

I would prefer CLI, but maybe both interfaces can be combined.

It would be nice to provide also a graphical Sqlite3 browser, which can be ran 
as a separate application and be integrated with IDLE (as turtledemo).

--
nosy: +serhiy.storchaka

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue33436] Add an interactive shell for Sqlite3

[R. David Murray]

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 
expanding her sqlpython to be multi-db capable, and while it doesn't look like 
that has happened, maybe that would be an alternative worth investigating?  
(I've never used it or looked at its code, so it may not be.)

--
nosy: +r.david.murray

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue33436] Add an interactive shell for Sqlite3

[Raymond Hettinger]

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 version 2.6.0

 Enter "help" for usage hints

sqlite> open Irises.db
sqlite> select distinct species from irises
('Iris-setosa',)
('Iris-versicolor',)
('Iris-virginica',)
sqlite> select species, avg(pet_len), avg(sep_len) from irises group by 
species
('Iris-setosa', 1.464, 5.005)
('Iris-versicolor', 4.26, 5.936)
('Iris-virginica', 5.552, 6.5879998)
sqlite> select count(*) from irises
(150,)
sqlite> quit

--
components: Library (Lib)
files: sqlite3_repl.py
messages: 316248
nosy: rhettinger
priority: normal
severity: normal
status: open
title: Add an interactive shell for Sqlite3
type: enhancement
versions: Python 3.8
Added file: https://bugs.python.org/file47573/sqlite3_repl.py

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com