Project

visual_db

0.0
No commit activity in last 3 years
No release in over 3 years
visual_dbat1as/visual_dbHomepageDocumentationSource CodeBug TrackerWiki
Browser front-end for navigating and modifying mySQL databases
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Popularity
Downloads
7,634
Stars
0
Forks
0
Watchers
2
 Releases
Current version
0.1.2
Total releases
3
First release
2015-02-13
Latest release
2015-05-04
 Development
Primary Language
HTML
Licenses
MIT
Average date of last 50 commits
2015-02-24
Reverse Dependencies
0

 Dependencies

Development

bundler
~> 1.7
rake
~> 10.0

Runtime

mysql
>= 2.9.1, ~> 2.9
sinatra
>= 1.4.5, ~> 1.4
vegas
>= 0.1.11, ~> 0.1
 Project Readme

Visual DB Gem Version

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

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 (which is generally more stable, but several commits behind this repository):

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