Queryit

A very basic setupless terminal based SQL query runner meant to be used as a developer tool to test queries against a project database.

Installation

if ArchLinux

There's an AUR package for it.

$ yay -S queryit

else

You need the project dependencies installed on your system:

• Termbox C library - https://github.com/nsf/termbox
• Crystal language compiler
• Shards, the crystal language package manager

$ make
$ sudo make install

Usage

On a rails or amber project directory just run it, a connection will be made to the development database:

$ queryit

Or specify the database URI:

$ queryit --uri postgres://localhost/database

Database support

Despite of only be really tested with Postgres and SQLite, it should work with MySQL too.

Development

The application is already useful but still need some love. Above is a todo list in no specific order:

• [x] Basic query execution/show results.
• [x] Save results to CSV.
• [x] Help screen.
• [x] Change database.
• [x] Navigate through results.
• [ ] Syntax highlight.
• [x] SQL beautifier.
• [ ] SQL auto complete.
• [x] Improved copy/paste support.
• [x] Install script/instructions.
• [x] ArchLinux package.
• [ ] Move TextUI code to their own shard.
• [ ] Do not block UI when executing long queries.
• [ ] Show time spent to execute a query,
• [ ] Show available table and their columns.
• [ ] Have a manpage.

Contributing

1. Fork it (https://github.com/hugopl/queryit/fork)
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request

Contributors

• Hugo Parente Lima - creator and maintainer