maddy icon indicating copy to clipboard operation
maddy copied to clipboard

SQL table blob storage

Open foxcpp opened this issue 5 years ago • 3 comments

Allows easy backups, etc when used together with storage.imapsql. See https://github.com/foxcpp/maddy/issues/291#issuecomment-735242195

Depends on #303.

foxcpp avatar Nov 28 '20 16:11 foxcpp

Postgres supports Large Object storage with a custom interface. That would make this more feasible for non-tiny deployments.

The currently used driver (pq) does not support this. pgx does though.

theduke avatar Nov 28 '20 16:11 theduke

That would make this more feasible for non-tiny deployments.

At first a separate table with a binary data type column would be nice as well. LOS is a bit more involved to keep track of and back up and not everyone might wish to do so.

Avamander avatar Nov 28 '20 17:11 Avamander

Agreed, for my own deployment a regular table would probably be just fine as well.

theduke avatar Nov 28 '20 19:11 theduke