A presentation at OpenUK Online Meetup by Lorna Jane Mitchell
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
