Serve image stored in SQLAlchemy LargeBinary column

by

If you absolutely need to store the image in the database, then yes, this is correct. Typically, files are stored in the filesystem and the path is stored in the database. This is the better solution because the web server typically has an efficient method of serving files from the filesystem, as opposed to the application sending large blobs of data dynamically.

To serve the image, write a view that gets the image data and sends it as a response.

@app.route('/event/<int:id>/logo')
def event_logo(id):
    event = Event.query.get_or_404(id)
    return app.response_class(event.logo, mimetype="application/octet-stream")

<img src="https://stackoverflow.com/questions/31849494/{{ url_for("event_logo', id=event.id }}"/>

Preferably serve it using the correct mimetype rather than application/octet-stream.

You could also embed the image data directly in the html using a data uri. This is sub-optimal, because data uris are sent every time the page is rendered, while an image file can be cached by the client.

from base64 import b64encode

@app.route('/event/<int:id>/logo')
def event_logo(id):
    event = Event.query.get_or_404(id)
    image = b64encode(event.logo)
    return render_template('event.html', event=event, logo=image)

<p>{{ obj.x }}<br/>
{{ obj.y }}</p>
<img src="https://stackoverflow.com/questions/31849494/data:;base64,{{ logo }}"/>

More Related Contents:

  1. Link to Flask static files with url_for
  2. Passing HTML to template using Flask/Jinja2
  3. Reference template variable within Jinja expression
  4. How to execute raw SQL in Flask-SQLAlchemy app
  5. jsonify a SQLAlchemy result set in Flask [duplicate]
  6. Create dynamic arguments for url_for in Flask
  7. How to build a flask application around an already existing database?
  8. Display image stored as binary blob in template
  9. How to iterate through a list of dictionaries in Jinja template?
  10. Remove unnecessary whitespace from Jinja rendered template
  11. Python Flask Render Text from Variable like render_template
  12. ImportError: No module named MySQLdb
  13. Flask sqlalchemy many-to-many insert data
  14. How to delete a record by id in Flask-SQLAlchemy
  15. Reload Flask app when template file changes
  16. Get inserted key before commit session
  17. Querying with function on Flask-SQLAlchemy model gives BaseQuery object is not callable error
  18. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  19. Serve static files from a CDN rather than Flask in production
  20. How to render by Vue instead of Jinja
  21. How to generate an html directory list using Python
  22. Getting first row from sqlalchemy
  23. creating a database outside the application context
  24. How to use g.user global in flask
  25. ImportError: cannot import name ‘Markup’ from ‘jinja2’
  26. Flask-SQLAlchemy Constructor
  27. Returning rendered template with Flask-Restful shows HTML in browser
  28. Global variables in Flask templates
  29. SQLAlchemy ordering by count on a many to many relationship
  30. flask sqlalchemy query with keyword as variable

Leave a Comment