Message316248
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 |
|
Date |
User |
Action |
Args |
2018-05-07 01:47:00 | rhettinger | set | recipients:
+ rhettinger |
2018-05-07 01:47:00 | rhettinger | set | messageid: <1525657620.33.0.682650639539.issue33436@psf.upfronthosting.co.za> |
2018-05-07 01:47:00 | rhettinger | link | issue33436 messages |
2018-05-07 01:46:59 | rhettinger | create | |
|