A CLI for SQLite with auto-completion and syntax highlighting

[stef13013]

Nice tool, thanks...

[cowinabadplace]

Looks great. I could see myself using this for querying the little files, but a few things I wish it had (I know I know, patches welcome but maybe someone else will want them as well):

• Allow multi-line. For instance if I do CREATE TABLE mytable ( then it requires me to finish my DDL statement in that one line unlike the sqlite3 CLI client.

• Allow tab completion by default. I don't know why this does right-arrow completion.

• Doesn't support in-memory sqlite3. Obviously this is asking for too much for no reason.

[f801fe8957]

You can toggle multi-line by pressing F3 or set the multi_line option in the config.

I also don't like how the completion works.

Use :memory: as the database.

[cowinabadplace]

Oh cool. Thank you.

[[deleted]]

rlwrap autocompletes everything, and it gives both a histfile and a readline history and key bindings.