public
Fork of tomtt/schema-browser
Description: Rails schema browser plugin: proof of concept
Homepage: http://tomtenthij.co.uk/2008/2/12/rails-schema-browser-plugin-proof-of-concept
Clone URL: git://github.com/notch8/schema-browser.git
Search Repo:
name age message
folder .gitignore Thu Jan 24 15:37:45 -0800 2008 git ignore setup [Tom ten Thij]
folder MIT-LICENSE Tue Feb 12 05:10:13 -0800 2008 changed the repos to just contain the plugin co... [Tom ten Thij]
folder README Thu Apr 10 13:00:25 -0700 2008 Minor README updates [Tom ten Thij]
folder Rakefile Tue Feb 12 05:10:13 -0800 2008 changed the repos to just contain the plugin co... [Tom ten Thij]
folder generators/ Thu Feb 14 05:54:36 -0800 2008 created migration to store table properties [Tom ten Thij]
folder init.rb Thu Apr 17 15:44:33 -0700 2008 Requiring schema_browser in init.rb fixes errors [Tom ten Thij]
folder install.rb Tue Feb 12 05:10:13 -0800 2008 changed the repos to just contain the plugin co... [Tom ten Thij]
folder lib/ Tue May 06 14:39:56 -0700 2008 Fixed undifined method 'tableize' error in some... [notch8]
folder spec/ Mon Feb 18 06:20:54 -0800 2008 fixed error when column inferred from index doe... [Tom ten Thij]
folder tasks/ Tue Feb 12 05:10:13 -0800 2008 changed the repos to just contain the plugin co... [Tom ten Thij]
folder uninstall.rb Tue Feb 12 05:10:13 -0800 2008 changed the repos to just contain the plugin co... [Tom ten Thij]
README
SchemaBrowser
=============

This plugin will allow the database structure and model relations to
be viewed in an interactive graphical interface. The interface used heavily based
on http://ondras.zarovi.cz/sql/

Please note that this is just a proof of concept at this stage and
that it will be in constant state of rewrite over the next few
weeks. Be prepared for everything changing on a whim.

To install run script/generate schema_browser. This creates a
controller called schema_browser, views generating the interface and
the xml representation of the database schema and model relations. It
also adds routes for this and copies required files to public/

Todo
====
* Support polymorphic relations
* Modify layout page to be more suited for just browsing the schema
* Smarter default placement of tables
* Ability to store position of tables in database, stored remotely after drag event in interface
* Allow name of controller (and schema view) to be specified to generator
* Disable by default in production mode
* More support in interface for untangling relations
* Provide option to not show certain tables
* Allow different views of the schema (with tables having different properties/positions for each view)
* Create whitelist and blacklist implementation to determine which table to show
* Allow table to be collapsed (interface + store in database)
* Fix issue where some tables do not show PK for their id

Copyright (c) 2008 [Tom ten Thij], released under the MIT license