Purpose of SQLAlchemy over MYSQL CONNECTOR PYTHON

Question

I am new to working with databases and couldn't find any relevant answers for this. What are the uses of SQLAlchemy over MYSQL CONNECTOR for python.

Answer 1

I do not have much experience with MYSQL CONNECTOR for Python. However, from what I know SQLAlchemy primarily uses ORM (Object-Relational Mapping) in order to abstract the details of handling the database. This can help avoid errors some times (and also introduce possibly introduce others). You might want to have a look at the ORM technique and see if it is for you (but don't use it as a way to avoid learning SQL). Generally, ORMs tend not to be as scalable as raw SQL either.