Databases: Difference between revisions

Starting on an article to centrally deal with the database models and implementations chosen
 
more linking. split to headings for closer examination
Line 3: Line 3:
== Known types of databases ==
== Known types of databases ==
* [[w:Relational database]] or [[w:RDBMS]]
* [[w:Relational database]] or [[w:RDBMS]]
* [[w:Triplestore]] may be native implementation or on top of RDBMS
* [[w:Triplestore]] may be native implementation or on top of RDBMS and like the name implies it stores information as [[w:RDF]]-[[w:triplet|triplet]]s almost always in the subject-predicate-object form.
* [[w:Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks.
* [[w:Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks.


=== RDBMS ===


* On default [[MediaWiki]]s 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.
* On default [[MediaWiki]]s 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
* Postgresql is also in use working as data storage for [[w:GNU MediaGoblin]] at https://media.consumium.org
=== Triplestore ===
* [[w:List of subject-predicate-object databases]]
=== Graph database ===
* [[w:Graph_database#List_of_graph_databases|Wikipedia's list of graph databases]]