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 project directory just run it.

$ queryit

Or specify the database URI

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

Development

All this still in a very early development stage. Above is a todo list in no specific order:

• [x] Basic query execution/show results.
• [x] Save results to CSV.
• [ ] 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 queries.
• [ ] Have a manpage.
• [ ] Display nice useless charts about the server like pgAdmin4 does.

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