Databases: Difference between revisions

    (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