====== SQL-Plugin ======

A long standing plugin-wishlist-item is an extension, to better support handling of SQL inside of Geany. In particular it's about e.g. executing queries -- currently Geany is supporting only hacking of SQL with e.g. syntax highlighting or navigation via symbol browser.

===== Already supported by Geany =====

  * Syntaxhighlighting for a huge number SQL dialects 
  * Symbolbrowser
  * Running sql-scripts via build menu 
  * Running sql via "sending selection to"
  * Converting a tab-seperated list to SQL for e.g. INSERT by tableconvert-plugin

==== Open points for Geany core ====

  * Improve symbolbrowser as some procedures are not recognized (as by March 2014)

===== Wishlistitems for a new plugin =====

  * Support for common (relational) DBMS
    * MySQL/MariaDB/*
    * PostgreSQL
    * DB2
    * Oracle
    * Sybase-Family
    * MS SQL (?)
    * Informix (?)
  * Configuration/bookmarks for different connections (kind of a server manager)
  * A widget showing messages
  * A widget showing results of query 
    * Most likely as a tabular
  * View showing structure of database/table
  * "create .. anything" (view, stored procedure, index..) from sidebar(?)

===== Sources =====

A first development will be done at https://github.com/frlan/geanypysql (not yet really started)

{{tag> MySQL PostgreSQL DB2 Plugin SQL}}