Choosing the Right Database for Your Next Project - Looking at Options Beyond PostgreSQL and MySQL

Explore the evolving landscape of database engines in this 32-minute conference talk from EuroPython 2022. Delve into the challenges of selecting the right database for your project, considering options beyond traditional choices like PostgreSQL and MySQL. Learn about the strengths of various database engines when used with Python applications, covering relational databases for general-purpose tasks, data warehouse workloads, data analytics, machine learning, and streaming data. Gain insights into in-memory databases, GPU-based databases, data lakes, distributed databases, document databases, audit databases, and machine learning databases. Understand important decision factors such as feature sets, schema design, cardinality, query complexity, deployment complexity, and operational complexity to make informed choices for your next project.

Introduction
Motivation
The problem
Approach
Typical data load
Two databases
Feature set
Schema
Cardinality
Query complexity
Deployment complexity
Operational complexity
Additional decision factors
Inmemory databases
GPUbase databases
Dataware databases
Data lakes
Distributed databases
Document databases
Audit databases
Machine learning databases
Other databases
Conclusion
Questions