7
GitHub - mathaou/termdbms: A TUI for viewing and (eventually) editing database f...
source link: https://github.com/mathaou/termdbms
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
termdbms: A TUI for viewing and (eventually) editing databases, written in Go
Database SupportSQLite
made with modernc.org/sqlite, charmbracelet/bubbletea, and charmbracelet/lipgloss
Works with keyboard:
... And mouse!
Roadmap
- Run SQL queries and display results
- Edit cells on the fly
- Add/remove rows/columns/cells
- Rename anything
- MySQL support (more eventually)
- Serialization
Building (generally a go build should be enough, architecture included for completeness)
Linux
GOOS=linux GOARCH=amd64 go build
Windows
GOOS=windows GOARCH=amd64 go build
GOOS=darwin GOARCH=amd64 go build
Terminal settings
xterm-256 color mode must be enabled in the settings in order for color highlighting to function in these environments as well. MobaXterm, GitBash, and the most recent Windows terminal should all support these on Windows. Linux supports out of the box.
Known issues:
Large databases (tens of thousands of rows) make it slow sometimes. PRs open for optimization/ batching etc... Headers wig out sometimes in column expansion or selection view. Mouse controls don't might not work over SSH from Windows clients.
Help:
-p database path
-h prints this message
Controls:
MOUSEScroll up + down to navigate table
Move cursor to select cells for full screen viewing
[WASD] to move around cells
[ENTER] to select selected cell for full screen view
[UP/K and DOWN/J] to navigate schemas
[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
[P] in selection mode to write cell to file
[ESC] to exit full screen view
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK