0

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.

sushi
  • 25
  • 4
  • Does [this](https://stackoverflow.com/questions/1279613/what-is-an-orm-how-does-it-work-and-how-should-i-use-one) answer your question? – snakecharmerb Mar 22 '22 at 11:12
  • So SQLAlchemy is used to access data from the database as python objects whereas mysqlconnector is used to manipulate data in the database. – sushi Mar 22 '22 at 11:38

1 Answers1

0

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.

tintins7a6164
  • 148
  • 1
  • 7