flask-sqlalchemy or sqlalchemy

by

The main feature of the Flask-SQLAlchemy is proper integration with Flask application – it creates and configures engine, connection and session and configures it to work with the Flask app.

This setup is quite complex as we need to create the scoped session and properly handle it according to the Flask application request/response life-cycle.

In the ideal world that would be the only feature of Flask-SQLAlchemy, but actually, it adds few more things. Check out the docs for more info. Or see this blog post with the overview of them: Demystifying Flask-SQLAlchemy (update: the original article is not available at the moment, there is a snapshot on webarchive).

When I first worked with Flask and SQLAlchemy, I didn’t like this overhead . I went over and extracted the session management code from the extension. This approach works, although I discovered that it is quite difficult to do this integration properly.

So the easier approach (which is used in another project I am working on) is to just drop the Flask-SQLAlchemy in and don’t use any of additional features it provides. You will have the db.session and you can use it as if it was pure SQLAlchemy setup.

More Related Contents:

  1. SQLAlchemy ordering by count on a many to many relationship
  2. How to execute raw SQL in Flask-SQLAlchemy app
  3. jsonify a SQLAlchemy result set in Flask [duplicate]
  4. How to build a flask application around an already existing database?
  5. SQLAlchemy ManyToMany secondary table with additional fields
  6. Flask sqlalchemy many-to-many insert data
  7. How to delete a record by id in Flask-SQLAlchemy
  8. Get inserted key before commit session
  9. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  10. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  11. Getting first row from sqlalchemy
  12. Flask-SQLAlchemy Constructor
  13. flask sqlalchemy query with keyword as variable
  14. Flask SQLAlchemy query, specify column names
  15. Flask-SQLAlchemy import/context issue
  16. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  17. Case Insensitive Flask-SQLAlchemy Query
  18. Flask-SQLalchemy update a row’s information
  19. Efficiently updating database using SQLAlchemy ORM
  20. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  21. Flask-SQLAlchemy db.create_all() raises RuntimeError working outside of application context
  22. ImportError: No module named flaskext.sqlalchemy
  23. sqlalchemy: create relations but without foreign key constraint in db?
  24. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  25. ImportError: No module named sqlalchemy
  26. creating a database outside the application context
  27. Using SQLAlchemy models in and out of Flask
  28. Is possible to mapping view with class using mapper in SqlAlchemy?
  29. Flask, SQLAlchemy : KeyError: ‘SQLALCHEMY_TRACK_MODIFICATIONS’
  30. Tyring to set up modelview with Flask-Admin causes ImportError

Leave a Comment