SQLite is the best fit for Python app development. PostgreSQL database is also recommended for the relational database.