Categorygithub.com/alfonzm/lazydb
module
0.0.0-20240922042645-c2be9f57b542
Repository: https://github.com/alfonzm/lazydb.git
Documentation: pkg.go.dev

# README

lazydb

Development

go run ./cmd/lazydb

Build

go build ./cmd/lazydb

TODO

Basic Functionality

  • add new row
  • custom SQL editor on new page (by pressing 3)
  • table results pagination
  • support for other DB drivers (refactor to use interfaces)
  • show error modals for failed queries and other user-facing errors
  • update timestamp fields to NOW()
  • row value viewer (broken atm)
  • view for columns and indexes
  • home page - read config file for list of databases
  • home page - connect to a database
  • select/switch databases
  • delete row

QOL Improvements

  • tabs similar to Sequel Ace (keep sessions for each table opened)
  • dynamic hiding/showing of columns in a new modal - similar to Lazygit staging/unstaging files where pressing space toggles, and pressing A toggles all
  • improve UI colors - similar to lazygit
  • keyboard shorcuts
    • ctrl+hjkl to move panels (in addtn to tab)
    • 0 and $ goes to start/end of row
    • ctrl+p command palette type to go to table/database
    • ctrl+f from anywhere goes to table filter
    • press keybind on a cell (W), automatically write a WHERE condition for column
  • queries history (press ctrl+n or ctrl+p on WHERE filter scrolls through history)
  • saved queries
  • help menu by pressing ?
  • improve SQL editor autocomplete for DB columns
  • save/load sessions
  • easy way to show/hide columns
  • yank cell value
  • sort columns by highlighting header name and pressing a keybind

Bugs

  • doing a W(HERE) keypress on a cell where sort is applied uses the arrow key as cell name

# Packages

No description provided by the author