Page 1 of 1

Retrieving attachment data from Attachment table

PostPosted: Wed Jan 18, 2017 6:20 pm
by dfisher
After reading a previous thread, they discovered attachment data is compressed via Hermite Normal Form (HNF) before it is stored in the "Data" column of the "Attachment" SQL table. Is there any way to retrieve the data and decompress it to be viewed and/or saved outside of the Alloy application without having to extract all attachments and run a tool?

Re: Retrieving attachment data from Attachment table

PostPosted: Thu Feb 23, 2017 11:25 am
by eliaslynch
I asked about this once. Alloy uses a proprietary compression on attachments. They offered to create a tool for me to work with attachments outside the db, but it would be through their consulting services. I didn't need it that badly so I didn't pursue it, but it's surely possible.