Skip to content
Ruby gem for viewing query results as you type.
Ruby
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
exe
lib
.gitignore
.travis.yml
Gemfile
LICENSE.txt
README.md
Rakefile
live_sql.gemspec

README.md

LiveSql

Hello friends! live_sql is a little program I wrote to watch how your SQL queries change your results as you type. This is a baby gem, so contributions are welcome! Fixing problems, adding new features, or reporting bugs is greatly appreciated!

Installation

Add this line to your application's Gemfile:

gem 'live_sql'

And then execute:

$ bundle

Or install it yourself as:

$ gem install live_sql

Usage

Running from the Terminal

To use with a postgres db, simply run:

live_sql your_database_name_here

To use sqlite3 db, navigate to the folder containing the db and run

live_sql your_database_name_here.db sqlite3

Using the class

The gem exposes the LiveSQL class. To open the interface create a new instance, and call the run method.

require 'live_sql'
options = { db: :sqlite3, limit: 40 }
LiveSQL.new(your_database_name, options).run

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/fsladkey/live_sql

Running list of bugs and potential features:

  • Allow aggregate functions to be included in select but not actually used in the query until a group by clause is added.

  • Allow cursor navigation by holding down command/option for jumping words etc.

License

The gem is available as open source under the terms of the MIT License.

You can’t perform that action at this time.