xref: /plugin/sqlite/README (revision 7bb92a7b8acbeea4655e30449ddd649979335f7b)
1*7bb92a7bSKlap-inSqlite Plugin for DokuWiki
28452ec47SKlap-in
38452ec47SKlap-inA helper plugin to easily access a SQLite database.
48452ec47SKlap-in
58452ec47SKlap-inThe plugin detects whether PHPs PDO extension is available otherwise it
6*7bb92a7bSKlap-inwill look for the PHP sqlite extension.
7*7bb92a7bSKlap-inPDO supports sqlite3 only, and this plugin will look for db files with extension *.sqlite3
8*7bb92a7bSKlap-inThe sqlite extension supports sqlite2 only, here this plugin will look for  *.sqlite .
9*7bb92a7bSKlap-inThe admin interface shows a convert button when your database has the sqlite2 format
10*7bb92a7bSKlap-inand your installation has the both sqlite extensions else you should upgrade manually
11*7bb92a7bSKlap-inyour database to sqlite3 format.
128452ec47SKlap-in
13*7bb92a7bSKlap-inManually upgrade can by using commandline tools. Database files are in data/meta directory.
1450832eecSKlap-in    sqlite databasename.sqlite .dump | sqlite3 databasename.sqlite3
1550832eecSKlap-inMore about this upgrade on http://www.sqlite.org/version3.html
1650832eecSKlap-in
178452ec47SKlap-inAll documentation for this plugin can be found at
188452ec47SKlap-inhttp://www.dokuwiki.org/plugin:sqlite
198452ec47SKlap-in
208452ec47SKlap-inIf you install this plugin manually, make sure it is installed in
218452ec47SKlap-inlib/plugins/sqlite/ - if the folder is called different it
228452ec47SKlap-inwill not work!
238452ec47SKlap-in
248452ec47SKlap-inPlease refer to http://www.dokuwiki.org/plugins for additional info
258452ec47SKlap-inon how to install plugins in DokuWiki.
268452ec47SKlap-in
278452ec47SKlap-in----
28