Flat Files vs. Relational Databases

Discussion about the most popular wiki software and other technologies enabling collaborative volunteer-written encyclopedias.
Post Reply
User avatar
Auggie
Posts: 168
Joined: Sat Feb 25, 2017 2:00 pm

Flat Files vs. Relational Databases

Post by Auggie » Mon Feb 27, 2017 10:32 am

In the beginning of wikis, there was a debate about how best to store the content.

Flat files are quick, and require less specialized knowledge to work with.
Relational databases (e.g. MySQL) are easier to search through.

Says Patrick Michaud:
Patrick Michaud wrote:I chose flat files to store PmWiki pages because I haven't seen any real advantages of using a database, and there are definitely some disadvantages. For the standard operations (view, edit, page revisions), holding the information in flat files is clearly faster than accessing them in a database, and with page caching abilities (coming soon) it'll be even faster. The only operations that really benefit are searches, but I've always believed that for fast, flexible search capabilities it's much better to use existing search programs such as ht://Dig or Google over reinventing another search engine. PmWiki's Site.Search is functional/fast enough for most purposes, and if more performance is needed it's just better to switch to a real search engine.
When Wikipedia rose to dominance, MediaWiki became the default standard. It uses a relational database.

Fast forward to 2017, and interest is growing again in flat file storage. Funny how ideas come back like that. :)

DannMeyer
Posts: 13
Joined: Tue Aug 29, 2017 1:10 pm

Re: Flat Files vs. Relational Databases

Post by DannMeyer » Tue Aug 29, 2017 1:20 pm

+ there is DOCUWIKI

User avatar
Auggie
Posts: 168
Joined: Sat Feb 25, 2017 2:00 pm

Re: Flat Files vs. Relational Databases

Post by Auggie » Tue Aug 29, 2017 3:23 pm

I forgot about DokuWiki. Are they still active?

DannMeyer
Posts: 13
Joined: Tue Aug 29, 2017 1:10 pm

Re: Flat Files vs. Relational Databases

Post by DannMeyer » Tue Aug 29, 2017 10:00 pm

+ Yeah, changes. a major upgrade on 2017-02-19.

Kumioko
Posts: 2
Joined: Fri Sep 01, 2017 11:52 pm

Re: Flat Files vs. Relational Databases

Post by Kumioko » Fri Sep 01, 2017 11:59 pm

We use Sharepoint Wiki were I work at. We played with using Mediawiki but it was to high maintenance from an administration standpoint.

User avatar
Auggie
Posts: 168
Joined: Sat Feb 25, 2017 2:00 pm

Re: Flat Files vs. Relational Databases

Post by Auggie » Wed Sep 06, 2017 2:32 pm

It looks like SharePoint is part of Microsoft?

That's pretty cool. I love how quickly flat files load. None of that clunky database lag.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest