SQLAlchemy

SQLAlchemy is an amazing library for working with relational databases. It was made by the Pocoo Team, the same folks that brought you Flask, and is considered "The Facto" Python SQL library. It works with SQLite, Postgres, MySQL, Oracle, and all SQL databases, which comes with compatible drivers.

SQLite describes itself as a self-contained, serverless, zero-configuration, and transactional SQL database engine (https://sqlite.org/about.html). One of its main goals is to be a great embeddable database solution for applications and small devices, which it is! It is also very easy to use and that makes it perfect for our learning purposes.

Though all the examples will be given and tested with SQLite in mind, they should work in the other databases with little to no changes. Database-specific tips will be given from time to time whenever appropriate.

Note

Refer to http://www.w3schools.com/sql/default.asp for an extensive SQL reference.

Before our first example, should we review...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Building Web Applications with Flask

By : Italo Maia

Building Web Applications with Flask

By: Italo Maia

Overview of this book

SQLAlchemy

Note

Building Web Applications with Flask

By : Italo Maia

Building Web Applications with Flask

By: Italo Maia

Overview of this book

SQLAlchemy

Note

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access