[New-bugs-announce] [issue33436] Add an interactive shell for Sqlite3

[Raymond Hettinger]

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>
_______________________________________