Databases
This article is about choice of database models and implementations.
Known types of databases
- w:Relational database or w:RDBMS
- w:Triplestore may be native implementation or on top of RDBMS and like the name implies it stores information as w:RDF-triplets almost always in the subject-predicate-object form.
- w:Graph databases would intuitively appear more advanced than using RDF-triplet composed semantic networks.
- w:Object databases were a supposed fad in the late 80's and early 90's as w:relational algebra based systems are quite old.
RDBMS
- On default MediaWikis run on w:MySQL or the better and more ethical binary compatible drop-in replacement w:MariaDB. A recent fork by the original MySQL founders from MySQL. The Netherlands server serving the Consumium free social media run on MariaDB 10.
- Postgresql is also in use working as data storage for w:GNU MediaGoblin at https://media.consumium.org
Triplestore
A triple store maybe a native implementation from ground up or be standing on the shoulders of a standard RDBMS system where actual SQL is formulated by the interpreter and then queried from SQL. This probably has upsides and downsides.