The kind of database you use will depend on you needs. If you want/need database on a client, or working on prototyping, then I suggest using a flatfile database like sqlite. The advantage here is that you don’t need an sql server program to use SQLite.
MariaSQL, Postgres, even the nosql versions like mongodb require a separate server program.
You might also want to consider using python database middleware like sqlalchemy sqlalchemy.org/