xref: /plugin/sqlite/README (revision 6782aa83f8bc8afb6ebac98bd0e13c23871e4cd1)
17bb92a7bSKlap-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
67bb92a7bSKlap-inwill look for the PHP sqlite extension.
78452ec47SKlap-in
831078b3cSAndreas GohrPDO supports sqlite3 only, and this plugin will look for db files with extension *.sqlite3
931078b3cSAndreas GohrThe sqlite extension supports sqlite2 only, here this plugin will look for  *.sqlite files.
1031078b3cSAndreas Gohr
1131078b3cSAndreas GohrIf both drivers are available, the admin allows to convert old sqlite2 format databases to
1231078b3cSAndreas Gohrthe new format. This should be done when upgrading from an older version. Manual upgrades
1331078b3cSAndreas Gohrcan be done through commandline tools. Database files can be found in the data/meta directory.
1431078b3cSAndreas Gohr
1550832eecSKlap-in    sqlite databasename.sqlite .dump | sqlite3 databasename.sqlite3
1631078b3cSAndreas Gohr
1750832eecSKlap-inMore about this upgrade on http://www.sqlite.org/version3.html
1850832eecSKlap-in
198452ec47SKlap-inAll documentation for this plugin can be found at
208452ec47SKlap-inhttp://www.dokuwiki.org/plugin:sqlite
218452ec47SKlap-in
228452ec47SKlap-inIf you install this plugin manually, make sure it is installed in
238452ec47SKlap-inlib/plugins/sqlite/ - if the folder is called different it
248452ec47SKlap-inwill not work!
258452ec47SKlap-in
268452ec47SKlap-inPlease refer to http://www.dokuwiki.org/plugins for additional info
278452ec47SKlap-inon how to install plugins in DokuWiki.
288452ec47SKlap-in
298452ec47SKlap-in----
3031078b3cSAndreas Gohr
3131078b3cSAndreas GohrCopyright (C) Andreas Gohr <andi@splitbrain.org>,
32*6782aa83SAndreas Gohr              Gerrit Uitslag <klapinklapin@gmail.com>
3331078b3cSAndreas Gohr
3431078b3cSAndreas GohrThis program is free software; you can redistribute it and/or modify
3531078b3cSAndreas Gohrit under the terms of the GNU General Public License as published by
3631078b3cSAndreas Gohrthe Free Software Foundation; version 2 of the License
3731078b3cSAndreas Gohr
3831078b3cSAndreas GohrThis program is distributed in the hope that it will be useful,
3931078b3cSAndreas Gohrbut WITHOUT ANY WARRANTY; without even the implied warranty of
4031078b3cSAndreas GohrMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4131078b3cSAndreas GohrGNU General Public License for more details.
4231078b3cSAndreas Gohr
4331078b3cSAndreas GohrSee the COPYING file in your DokuWiki folder for details
44