Control: tags -1 +wontfix Hi Emil,
On Tue, Jul 31, 2018 at 2:33 PM Emil Fihlman <emil.fihl...@gmail.com> wrote: > I would also very much like to see this added to the system. The usability > increase is pretty great and the cost (--enable-readline=yes) is pretty small. Please note that users (like you in this case) often mix three things: command line history, filename completion and command completion. The first two things already available and works as SQLite is built with readline since February, 2005 (indeed, for thirteen years!). For command completion readline is not enough, needs upstream support. I've some memory that there's no plan to do it for keeping the library and tool size small. However you can reach the behavior with a tool called rlwrap. After installing it, create the file ~/.rlwrap/sqlite3_completions with SQLite3 commands in it: -- cut -- ABORT ACTION ADD AFTER ALL ALTER ANALYZE AND AS ASC ATTACH AUTOINCREMENT BEFORE BEGIN BETWEEN BY CASCADE CASE CAST CHECK COLLATE COLUMN COMMIT CONFLICT CONSTRAINT CREATE CROSS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATABASE DEFAULT DEFERRABLE DEFERRED DELETE DESC DETACH DISTINCT DROP EACH ELSE END ESCAPE EXCEPT EXCLUSIVE EXISTS EXPLAIN FAIL FOR FOREIGN FROM FULL GLOB GROUP HAVING IF IGNORE IMMEDIATE IN INDEX INDEXED INITIALLY INNER INSERT INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LEFT LIKE LIMIT MATCH NATURAL NO NOT NOTNULL NULL OF OFFSET ON OR ORDER OUTER PLAN PRAGMA PRIMARY QUERY RAISE RECURSIVE REFERENCES REGEXP REINDEX RELEASE RENAME REPLACE RESTRICT RIGHT ROLLBACK ROW SAVEPOINT SELECT SET TABLE TEMP TEMPORARY THEN TO TRANSACTION TRIGGER UNION UNIQUE UPDATE USING VACUUM VALUES VIEW VIRTUAL WHEN WHERE WITH WITHOUT -- cut -- Then use the CLI tool as 'rlwrap -a -N -c -i sqlite3'. Hope this helps or please convince upstream to implement command completion in the CLI tool itself. Regards, Laszlo/GCS
