litecli
litecli copied to clipboard
dbcli
CLI for SQLite Databases with auto-completion and syntax highlighting
It would be great to be able to save query results using litecli. Currently, my workflow involves copying a query from litecli and using sqlite3 to get a csv. Similar...
Hi all (especially @amjith and @j-bennet). I contributed a couple of PRs back in the early days of pgcli. Then, y'know, I got busy with wrapping up my phd and...
Prompt for db `DY_DeskPLRSRange03.db` becomes this C:\temp\liteFri Jul 26 17:21:37 2019Y_DeskPLRSRange03.db> probably `\D` is treated as sysdate?
I would like to call another favorite from one favorite. i.e. [favorite_queries] test = 'SELECT * FROM database WHERE id = "$1"' test2 = '\f test "$1"' but I get:...
If you open the chinook db and run the following command ``` select artists.name,albums.title from artists,albums where artists.`ArtistId` = albums.`ArtistId` ``` litecli will only suggest completions for `artist.` and `albums.`...
### Description Sometimes, even when the command output fits on the screen, it is displayed by the pager. ### Steps to reproduce 1. Open chinook db in litecli and enter...
### Description When configured to use vi mode, Ctrl+y doesn't yank the previous cut text. ### Steps to reproduce 1. Add `key_bindings = vi` to your config file 1. Open...
### Description When using the dark version of the default theme, every command output is displayed by the pager, even if it fits on the screen. ### Steps to reproduce...
`./litecli mycool.db` Version: 1.3.2 ``` .load /home/ubuntu/src/sqlite-csv-vtable/csv CREATE VIRTUAL TABLE temp.t1 USING csv(filename="sample.csv");' 'SELECT * FROM t1; ``` Segmentation fault
Installed it on gitbash using python/pip (which I know very little about but I didn't spot any errors in the output), and it has created the exe `/Python27/Scripts/litecli.exe`, but when...
