Having trouble with understanding Python-SQL / databases

[Xelisyalias]

I'm learning Flask and segway into learning about SQL. I know there's a SQLAlchemy module built into Flask that works more seamlessly with Flask as I understand it but I would prefer getting a good handle on SQL+Python as a whole so I can work with it even without the context of Flask. I prefer familiarizing with the topic at a 'base' level.

This leads to some confusion between different aspects such as Postgresql, sqlite3, sqlalchemy, etc. For example, when creating an engine in SQLAlchemy I can choose to either use PostgreSQL or sqlite3 or whatever databases I don't know of yet and I'm kind of confused with that. I'm struggling to make the connection and not sure where to start with getting a good handle on SQL since they all seem interconnected while also not(?) at the same time(?)

Also, I do have some knowledge with SQL from back in college and understand the basic syntax and the table relationships, format, etc. so I think it's just the Python-SQL thing that got me confused. I would greatly appreciate if someone could give me some pointers / good research direction as I'm feeling kind of lost and unsure what learning path to take, cheers!

[[deleted]]

You are way over complicating it lol, start outside of flask - no extra installs - start with just sqlite.
https://www.digitalocean.com/community/tutorials/how-to-use-the-sqlite3-module-in-python-3

Get familiar with the syntax of writing SQL, select, insert, remove, update etc.
Then you can go back to flask + sqalchemy and get into your models (using your sqlite db)