[FIXED] Difference between included SQLite3 library in Python and SQLAlchemy

Issue

I know there is an included library in python for SQLite3, and when I was studying Flask the course instructor proposed to use SQLAlchemy to manage an SQLite database, What´s the difference between using sqlite3 library and SQLAlchemy?

Solution

SQLAlchemy is an ORM based tool: https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping. It therefore can create and support complex objects, relationships and structures, which is more than an simple API interface with database. I am guessing here, but the SQLite3 library is probably little more than what you need to interface with the database engine. In principle, all database drivers can be used with SQLAlchemy.

I hope this helps.

Answered By - Pieter Geelen