Systems selections

Factors affecting database systems selections

• Copyleft 'free to modify' and 'free in cost' software is strongly preferred over other solutions.
• Minimal modifications required could be another preference as that means maintenance of the chosen solution is minimized in that aspect.

---

Encodings

• Integers w:BASE10 for integers, size depends on available solutions. Escape integer ceiling by bluntly encoding the integer as string of BASE-10 chars, dirty hack but could do the trick.
• Condense URL encoding w:BASE64 and 64 possible characters, exactly 6 bits from w:ISO/IEC 646 (hard compatible with 7-bit ASCII)
• w:UTF-8 encoded w:Unicode for text. UTF-8 is efficient and allows 2^32 different characters.. unless escaped to 40-bit in future revision

Languages

Programming languages

Currently used languages

• w:PHP (5)
• w:Ruby (programming language)
• w:Python (programming language)

Considered languages / languages of interest

Databases

Current databases

Main article: Database

Currently using all major free software RDBMS:

• w:MariaDB
• w:MySQL
• w:PostgreSQL

Considered databases

• Graph databases and Subject-predicate-object databases seem to perform the same thing just with different architecture and suitability for certain searches. See Talk:Databases for more on this.

Candidates for testing

• All copyleft licensed triplestore and more advanced i.e. graph

---

Frameworks

Frameworks

• Semantic MediaWiki

---

Software

Main article: Software

Current software

• MediaWiki
• w:diaspora (software)*
• w:Draft:Hubzilla (pauvre ecrivan.. les deletionists vous savez..)
• w:Friendica
• w:GNU social
• w:GNU MediaGoblin

...

---

APIs

APIs to communicate with:

• Free social media ones

---

Data sources

Data sources: own

• Semantic MediaWiki well thought out and set up on implementation wiki (c.consumerium.org)
• Development Wiki - User database, userspace sharing or importing and Unified Login are being looked at as options.

Data sources: Semantic web

• Other copyleft Semantic MediaWikis
  • Semantic MediaWiki Community wiki list of SMW sites
  • Wikiapiary list of SMW sites
  • Wikiindex.org category of SMWs

• DBpedia Public SPARQL endpoint of DBpedia.org and Projects and efforts using DBpedia are very relevant.
• Wikidata Public SPARQL endpoint of Wikidata.org (Wikidata Query Service)

Lists of Sparql endpoints

• https://www.w3.org/wiki/SparqlEndpoints

---

Media sources

Copyleft:

• w:Wikimedia Commons
• Consumerium Commons
• Upcoming federated w:GNU MediaGoblin