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.

Build Status

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.

Screenshot

Installation

if ArchLinux

There's an AUR package for it.

$ yay -S queryit

Else

You need the project dependencies installed on your system:

$ 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 and still not so far from useless. Above is a todo list in no specific order:

  • Basic query execution/show results.
  • Save results to CSV.
  • Help screen.
  • Change database.
  • Navigate through results.
  • Syntax highlight.
  • SQL beautifier.
  • SQL auto complete.
  • Improved copy/paste support.
  • Install script/instructions.
  • 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

Unreleased

Added

  • Detect Amber project configuration.

Fix

  • SQLite3 databases now works.

[0.1.0] - 2019-11-07

  • First release, only basic things working but still useful.
  • Support for SQLite and MySQL is there, but never tested.
  • Postgres is the only one tested for now.
Github statistic:
  • 1
  • 1
  • 0
  • 1
  • 0
  • about 5 hours ago

License:

MIT License

Links: