Not logged in. · Lost password · Register
Forum: General Help and Support Features and Functionality RSS
DokuWiki and Database Storage
Avatar
cihans #1
Member since May 2007 · 6 posts
Group memberships: Members
Show profile · Link to this post
Well in my wiki in mind
all data will be stored to a database
searches and indexes are at database
but wiki admins regularly change articles from database to files for users to read articles.

Doku i think at this step can hold all indexing and links of the article files at a database,
which will increase searching performance for articles,
database outputs that link
php will take link and shows article text file to the user.
This post was edited on 2007-05-27, 18:51 by cihans.
Avatar
pchan #2
Member since Apr 2007 · 111 posts · Location: Lille, France
Group memberships: Members
Show profile · Link to this post
Hi,
all data will be stored to a database
I think this will improve the "loosing" feature of dokuWiki compared to the 'huge' wikis in the world.

wiki admins regularly change articles from database to files for users to read articles
Note that there are possibilities of creating things like - slide show - chm - pdf - especially for readers who need to be off-line.
Avatar
Falkor #3
Member since Apr 2007 · 32 posts
Group memberships: Members
Show profile · Link to this post
Also, if one wants to use dokuwiki with a db, and you have a little nack for say postgres and php,
a db-backend shouldn't be that difficult to implement :-)

//Falkor
Avatar
pchan #4
Member since Apr 2007 · 111 posts · Location: Lille, France
Group memberships: Members
Show profile · Link to this post
Falkor, maybe it shouldn't be difficult to implement.
But then, you are off on your own branch of DokuWiki code and very difficult to benefit from
- mainstream DokuWiki updates (security/unicode handling in php6/etc.)
- different modules still using the standard file system.

It would be great if DokuWiki core can offer the option of using file system or using db.
Through a new type of plugin or API's so that the above features are not lost.
People can start "simple" using file system, then "upgrade" to using DB.
And call that dokuWiki v3!

Codes that access a file using its name may be mapped into accessing a record using a primary
key derived from the filename, and return the content in the form of a big blob.
Tags may be implemented directly in the DB to profit from indexing.

There may be other DB features to profit from. Any ideas?
Avatar
Falkor #5
Member since Apr 2007 · 32 posts
Group memberships: Members
Show profile · Link to this post
I think you've covered most.

What I had in mind was something similar to the auth-backend,
with $cando arrays, and the complete implementation with conf-directory
like the one for plugins.

Of course, use plain text as default, with possibility to use db if large projects.
Dokuwiki would certainly be a very serious alternative for large wikis.

//Falkor
Avatar
jroeterd #6
Member since Aug 2006 · 14 posts · Location: The Netherlands
Group memberships: Members
Show profile · Link to this post
In reply to post #4
Most reasons for using a DB seems to be for searching, ect. Why not use something light like SQLITE for the searching and have links to the files itself. The best of both worlds.

Greetings,
Jar
Avatar
pchan #7
Member since Apr 2007 · 111 posts · Location: Lille, France
Group memberships: Members
Show profile · Link to this post
Jar, would you care to give more light on SQLITE  ;-)
Maybe I'm missing something.
Avatar
jroeterd #8
Member since Aug 2006 · 14 posts · Location: The Netherlands
Group memberships: Members
Show profile · Link to this post
Hello,

SQLITE is a light DB without the need to install but very capable. It comes default with PHP 5+. See www.sqlite.org for more information.

Greetings,
Jar
Avatar
pchan #9
Member since Apr 2007 · 111 posts · Location: Lille, France
Group memberships: Members
Show profile · Link to this post
Jar,
MySQL comes packaged with PHP too. I'm using Easy PHP V2.0b1 on Windows XP, with:
- MySQL Admin
- Apache
- PHP5

Easy to start/stop the various processes.
So to conclude, there is no short of candidates for a SQL-compliant database!
There are also many candidates for a DB wrapper class.
Avatar
jroeterd #10
Member since Aug 2006 · 14 posts · Location: The Netherlands
Group memberships: Members
Show profile · Link to this post
Hello Pchan,

When you download PHP you do not get MySQL. The tools to use PHP to connect to a MySQL database are default in the PHP download but not the DB software self. You have to install MySQL on your machine and that is exactly not what we want. A download of PHP 5+ contains the DB software SQLITE so no other download is necessary and no installation is needed.

It is a much 'lighter' solution than MySQL.

Greetings,
Jroeterd
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
Imprint
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2019-08-21, 17:57:02 (UTC +02:00)