[New-bugs-announce] [issue33436] Add an interactive shell for Sqlite3
Raymond Hettinger
report at bugs.python.org
Sun May 6 21:47:00 EDT 2018
New submission from Raymond Hettinger <raymond.hettinger at gmail.com>:
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.005999999999999)
('Iris-versicolor', 4.26, 5.936)
('Iris-virginica', 5.552, 6.587999999999998)
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 <report at bugs.python.org>
<https://bugs.python.org/issue33436>
_______________________________________
More information about the New-bugs-announce
mailing list