Flat Files vs. Relational Databases

Discussion about the most popular wiki software and other technologies enabling collaborative volunteer-written encyclopedias.
Post Reply
User avatar
Posts: 33
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. :)

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest