#73 New plugin request: Basic database browser/query tool

open
nobody
None
5
2011-02-22
2011-02-22
Anonymous
No

I think geany could really use a basic database plugin. Such a plugin would need to do the following:
* connect to a small variety of databases (mysql, postgresql, sqlite)
* store settings per project, and automatically connect when a project is loaded
* view/modify table structure/data
* edit/execute adhoc queries

Thoughts on interface
* Table list: sidebar
* Table structure/data: separate window (like webhelper)
* Query editor: separate window (like webhelper)

Other things that would be neat:
* Ability to select a string in an open file, right click->"Edit as query"
* ability to record scripts of database structure changes to a clipboard (useful for developing a set of changes to a db that need to be deployed)

Discussion