Contents

# Visual DB [![Gem Version](https://badge.fury.io/rb/visual_db.svg)](http://badge.fury.io/rb/visual_db)

Visual DB is web utility to connect to local or remote MySQL instances and view & modify data. Visual DB is meant to be quick and easy to use, and reduce some potential for errors in user queries. Visual DB is a resource well suited for those just getting started with SQL syntax.

### Screenshots

* ![screenshot](https://github.com/at1as/at1as.github.io/blob/master/github_repo_assets/visual_db.jpg)

### Features

* Download Tables as CSV
* View/Create/Delete Databases
* Connect to local or remote mySQL instances
* Accessible via browser of your choice
* SQL Query templates based on user input
* Tables sortable by column header

### Installation

To install the [Ruby Gem](https://rubygems.org/gems/visual_db) (which is generally more stable, but several commits behind this repository):

```bash
gem install visual_db
```

To install this repo directory, simply clone assign appropriate permissions, and install necessary dependencies.


### Dependencies

* See Gemfile for dependencies
* Developed and tested on Ruby 2.2, Mac OS 10.10, and MySQL 5.6.21 

### TODO

* UI Work
* More UI guided SQL query generation

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
visual_db-0.1.2	README.md
visual_db-0.1.1	README.md