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