go install github.com/mathaou/[email protected]
// pacman sudo pacman -S termdbms-git // yay yay -S termdbms-git
SQLite CSV* (see note below)
GOOS=linux GOARCH=amd64/386 go build
GOOS=linux GOARCH=arm GOARM=7 go build
GOOS=windows GOARCH=amd64/386 go build
GOOS=darwin GOARCH=amd64 go build
Whatever terminal emulator used should support ANSI escape sequences. If there is an option for 256 color mode, enable it. If not available, try running program in ascii mode (-a).
-p / database/.csv path -d / specifies which database driver to use (sqlite/mysql) -a / enable ascii mode -h / prints this message -t / starts app with specific theme (default, nord, solarized)
Scroll up + down to navigate table/text Move cursor to select cells for full screen viewing
[WASD] to move around cells, and also move columns if close to edge [ENTER] to select selected cell for full screen view [UP/K and DOWN/J] to navigate schemas [LEFT/H and RIGHT/L] to navigate columns if there are more than the screen allows. Also to control the cursor of the text editor in edit mode [BACKSPACE] to delete text before cursor in edit mode [M(scroll up) and N(scroll down)] to scroll manually [Q or CTRL+C] to quit program [B] to toggle borders! [C] to expand column [T] to cycle through themes! [P] in selection mode to write cell to file, or to print query results as CSV. [R] to redo actions, if applicable [U] to undo actions, if applicable [ESC] to exit full screen view, or to enter edit mode [PGDOWN] to scroll down one views worth of rows [PGUP] to scroll up one views worth of rows
[ESC] to enter edit mode with no pre-loaded text input from selection When a cell is selected, press [:] to enter edit mode with selection pre-loaded The text field in the header will be populated with the selected cells text. Modifications can be made freely [ESC] to clear text field in edit mode [ENTER] to save text. Anything besides one of the reserved strings below will overwrite the current cell [:q] to exit edit mode/ format mode/ SQL mode [:s] to save database to a new file (SQLite only) [:s!] to overwrite original database file (SQLite only). A confirmation dialog will be added soon [:h] to display help text [:new] opens current cell with a blank buffer [:edit] opens current cell in format mode [:sql] opens blank buffer for creating an SQL statement [:clip] to open clipboard of SQL queries. [/] to filter, [ENTER] to select. [HOME] to set cursor to end of the text [END] to set cursor to the end of the text
[ESC] to move between top control bar and format buffer [HOME] to set cursor to end of the text [END] to set cursor to the end of the text [:wq] to save changes and quit to main table view [:w] to save changes and remain in format view [:s] to serialize changes, non-destructive (SQLite only) [:s!] to serialize changes, overwriting original file (SQLite only)
[ESC] to move between top control bar and text buffer [:q] to quit out of statement [:exec] to execute statement. Errors will be displayed in full screen view. [:stow <NAME>] to create a snippet for the clipboard with an optional name. A random number will be used if no name is specified.
[:d] to reset table data back to original view [:sql] to query original database again