datasette-media
datasette-media copied to clipboard
simonw
Datasette plugin for serving media based on a SQL query
I have keys in my sqlite db that contains spaces, and when i generate media urls like http://localhost:8001/-/media/thumbnails/Google%20Photos/Algarve/IMG_XXX.jpg those do not match any existing key. I think line 30 of...
SQLite has a mechanism for serving large BLOB content without reading it all into memory: https://www.sqlite.org/c3ref/blob_open.html This is hopefully going to land in the next version of Python: https://github.com/python/cpython/pull/271 It's...
Serving raw data out of the database could inadvertently lead to XSS attacks, if a site allows users to insert content that is later served up raw by this plugin....
If a database column stores md5 could I combine that with the resize query string parameters and support conditions GET, hence avoiding a resize operation? Are CDNs smart enough to...
```json { "plugins": { "datasette-media": { "photo": { "sql": "select filepath from apple_photos where uuid=:key", "default_convert": { "heic": "jpeg" } } } } } ``` `default_convert` can be used to...
I ran into problems serving mp4 files such that they could be embedded in an HTML `` element: ```html ``` I think this is due to to a lack of...
I should default to stripping out EXIF data, because leaking latitude/longitude in GPS tags is a potential privacy violation. To allow EXIF through I can support this option: ```json "strip_exif":...