Tibs
After being a programmer for a good few years, I changed career in 2022 to become a Developer Educator at Aiven (https://aiven.io/tibs). My favourite programming language is Python, my favourite markup language is reStructuredText (although I'm fascinated by Typst), my favourite storage technologies are SQLite, PostgreSQL and Valkey, and I’m rather enthusiastic about Apache Kafka as a messaging system. Find out more about my past at https://www.tonyibbs.co.uk/
Session
What database should you choose? Worse, what kind of database should you choose?
My aim is to give you enough information to make that choice, or at least be aware of what the alternatives are.
I'd argue that there are five important database types at the moment, differing in how they regard the "shape" of their data. I'll give a brief introduction to each, explaining how it works, and discuss why you might want to use that particular type of database, depending on your data and what you want to do with it. I'll show case at least one open source example of each.
I'll cover:
- Relational (PostgreSQL®, SQLite)
- Columnar (ClickHouse®)
- Document (OpenSearch®)
- Key Value (Valkey™️)
- and as an extra, Graph (Neo4J®)