Open Source Databases Lorna Mitchell, Redocly

Data Sources Two main sources of data • my own Opinion • https://db-engines.com/en/ranking @lornajane ~ @lornajane@indieweb.social

Relational Databases Traditional databases: • MySQL or MariaDB • PostgreSQL (see also: PostGIS, TimescaleDB) @lornajane ~ @lornajane@indieweb.social

Time Series Data Time series data: • a timestamp • a measurement Try InfluxDB or Prometheus @lornajane ~ @lornajane@indieweb.social

Tiny but mighty • SQLite • ValKey (Redis fork) @lornajane ~ @lornajane@indieweb.social

Distributed Databases • Apache Cassandra • OpenSearch/Dashboards (also ElasticSearch) @lornajane ~ @lornajane@indieweb.social

Open Source Databases Great technology for your every need. @lornajane ~ @lornajane@indieweb.social

Resources • 7 Databases in 7 Weeks (2nd edition) @lornajane ~ @lornajane@indieweb.social