Databases: Difference between revisions

263 bytes added ,  26 August 2016
reworking content, adding links, clarifying info
(Expanding on == Subject-predicate-object database ==)
(reworking content, adding links, clarifying info)
Line 2: Line 2:


== Known types of databases ==
== Known types of databases ==
* [[w:Relational database]] or [[w:RDBMS]]
* [[w:Relational database]] provided by a [[w:RDBMS]]
* [[w:Triplestore]]s handle information stored as [[w:RDF]]-[[w:triplet|triplet]]s almost always in the subject-predicate-object form
* Subject-predicate-object database are provided by [[w:Triplestore]]s , native or on top of RDBMS
* [[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.
* [[w:Object database]]s were a supposed fad in the late 80's and early 90's as [[w:relational algebra]] based systems are quite old.
* [[w:Object database]]s were a supposed fad in the late 80's and early 90's as [[w:relational algebra]] based systems are quite old.


== Relational database ==
== Relational database ==
Together Consumerium and Consumium run all the 3 major free full fledged RDBMS there are: [[w:MariaDB]], [[w:MySQL]] and [[w:Postgresql]].
=== Relevant relational database powered software ===
* [[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
* https://d.consumium.org since 2013 and the rest mentioned on the landing page over there since 2016


* 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
9,842

edits