1====== crossdbsqlclient Plugin ====== 2 3---- plugin ---- 4description: A GUI-Interface in Dokuwiki to execute sql on MySQL and PostgreSQL. 5author : Soft2C.de 6email : info@soft2c.de 7type : Action, Syntax 8lastupdate : 2016-07-08 9compatible : 2016-06-26 "Elenor Of Tsort",2012-10-13 "Adora Belle",2013-05-10a "Weatherwax",Release 2013-12-08 "Binky",Release 2014-05-05e "Ponder Stibbons",Release 2014-09-29d "Hrun", 2015-08-10 "Detritus" 10tags : mySql-client, mySql-GUI, mySql-Interface, database, tables 11 12downloadurl: http://www.soft2c.de/pub/crossdbsqlclient.zip 13donationurl: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=GN27JNRYKUYTG 14---- 15 16===== Description ===== 17 18This is a very simple SQL-Client for MySQL. Some helper and template buttons are available in plugin. One or more (; separated) SQL can be executed by an database transaction. 19 20===== Configuration and Settings ===== 21 22In Admin-Section is to configurate the plugin. You have to set the database name, user, passwort and the host. Than you can allow some users or some groups (comma separated) to access the database via plugin. 23 24===== Installation ===== 25 26Download the plugin at [[http://www.soft2c.de/pub/crossdbsqlclient.zip|crossdbsqlclient.zip]] and extract the zip file to the plugin folder on your dokuwiki. 27 28 29===== Examples/Usage ===== 30 31Example to activate the plugin on your page: 32 33==== Default-DB via Admin-Configuration page ==== 34<code> 35{{crossdbsqlclient}} 36</code> 37 38==== DB via page level url ==== 39 40<code> 41{{crossdbsqlclient>type|server|database|user|password}} 42</code> 43 44 * type can be mysql or postgresql 45 * server can be the host with port delimitted by : 46 47e.g. 48<code> 49{{crossdbsqlclient>postgresql|localhost:54321|testdb|tester|pwd}} 50</code> 51 52===== Syntax ===== 53 54With the string ''%%{{crossdbsqlclient}}%%'' on the page level you activates the plugin. 55 56Also, the plugin is on page level. 57 58 59===== Development ===== 60 61===== Change Log ===== 62 63 * **2016-07-08** Initial release, first version 64 * **2016-07-11** Update description 65 66=== ToDo/Wish List === 67===== FAQ ===== 68 69===== Discussion ===== 70 71