edit slices of SQL databases in vi
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
visql wrap catsql with vi editor Oct 13, 2017
MANIFEST.in wrap catsql with vi editor Oct 13, 2017
Makefile update packaging slightly Oct 13, 2017
README.md add animation Oct 14, 2017
setup.py wrap catsql with vi editor Oct 13, 2017

README.md

visql

Edit slices of SQL tables in vi. Just specify a table and any filters you want to apply, and the table will show up in vi in csv format. Any edits you make will be applied back to the original source.

demo

Install

To edit local Sqlite databases, just do:

pip install visql

For PostgreSQL or MySQL support, add catsql[postgres] or catsql[mysql]:

pip install visql catsql[mysql]
pip install visql catsql[postgres]

For other databases, just install the appropriate SQLAlchemy dialect.

Use

visql test.sqlite3
visql test.sqlite3 --table users
visql postgres[ql]://user:pass@host/db --table users
visql mysql://user:pass@host/db --table users
visql test.sqlite3 --table users --grep paul
visql test.sqlite3 --table comments --sql "length(txt) < 40"

For all filters, see https://github.com/paulfitz/catsql#examples