the project of 2nd Archive resp. "2nd Foundation" germinated for many years
ultimate impetus for creation of KMS given by need of VK and KuM study programs for a unified aggregator and generator of Einführungveranstaltung (EV) presentations
first EV in winter semester 2016/2017 at url https://cloud.medienhaus.udk-berlin.de/community
first public demonstration at UdK Zukunfstag 2019
deployment of other instances in 2021
handbook generator (SQL->LaTex->PDF) deployed in Summer Semester 2022
Perl Dancer app behind nginx proxy
PostgreSQL database with just three tables: "knots", "bounds" and "zeitgeist"
all knot-related ad hoc information stored in knots.attributes hstore
main predicates: "is_parent", "has_bookmark", "contains" common to all instances, certain predicates "is_uttered_as", "illustrates", "is_symbiont_with" etc. instance-specific)
Kastalia is composed of "knots" which have attributes and relations ("bounds") to other "knots".
Everything (e.g. user, institution, event, presentation slide, fairy tale, musical piece) is a knot.
A knot is a "Ding an sich".
Bounds are predicated. (hello sir Berners-Lee, hello Wikibase, hello "semantic web")
A knot is presented to an observer (e.g. human user) by means of a template.
Combination of a knot, other knots which are bound to it and a template yield "Ding für uns".
The English word archive /ˈɑːrkaɪv/ is derived from the French archives (plural), and in turn from Latin archīum or archīvum, the romanized form of the Greek ἀρχεῖον (arkheion). The Greek term originally referred to the home or dwelling of the Archon, a ruler or chief magistrate, in which important official state documents were filed and interpreted; from there its meaning broadened to encompass such concepts as "town hall" and "public records".
The root of the Greek word is ἀρχή (arkhē), meaning among other things "magistracy, office, government", and derived from the verb ἄρχω (arkhō), meaning "to begin, rule, govern" (also the root of English words such as "anarchy" and "monarchy").
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spans formal techniques and practical considerations including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues including supporting concurrent access and fault tolp
A database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.
Learn SQL
what You want to use is PostgreSQL and nothing else than PostgreSQL
hstore is Your friend https://www.postgresql.org/docs/current/hstore.html
digital community which I founded in Slovakia in 2002
still used by few hundred people
architecture based around the principle "all nodes are functionally identical"
MySQL database; core tables: "nodes", "neurons" and "node_access"
avoid XML
encode everything in utf-8
the swiss-knife of pattern extraction: grep -r -P ...
other useful commands: wc, uniq, sort
aggregates information (sometimes in a form of an artefact)
gives in certain form "sense" to the archived entity
has something to do with "power"