BLOB Storage Errors

JJS jjs at krutt.org
Wed Jul 31 15:37:21 EDT 2019


*i use something like this:
*

*
*

*put base64encode(image "productphoto") into tGT*

*put URLencode(tGT) into tPrdFt
put "phototable=" & tT & "&id=" & gId & "&productphoto=" & tPrdFt into 
varSendData
put  "https://yoursite.com/uploadphoto.php" into tThis
post varSendData to URL tThis*

*Note that i used php as middleware to my db
*

*
*

Op 31-7-2019 om 19:41 schreef Tom Glod via use-livecode:
> I've always avoided using blobs, and have recently been reconsidering
> (trying to improve performance by not having to baseencode) it.....
>
> but now I'm back to not wanting to use blobs.
>
> I hope someone here can finally clear this up once and for all.....how and
> if to use blobs correctly.
>
> Thanks Bob :)
>
> On Wed, Jul 31, 2019 at 12:45 PM Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com> wrote:
>
>> Hi all.
>>
>> Those familiar with storing file data in SQL blob columns please chime in
>> if you have any ideas. I have added a File Storage module to my SQL based
>> app. Mostly it works a peach, but every now and then I encounter a file
>> that generates some kind of error. I get "mySQL Server has gone away" when
>> I attempt to insert the file. I open the files for binary read so it's the
>> raw file data unadulterated when I insert it.
>>
>> The nature of the files are typically backup information from copiers, so
>> it's likely they contain encryption hashes. They may also contain other
>> data that mySQL does not like. Any ideas? Should I be encoding the data
>> somehow before inserting?
>>
>> Bob S
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the use-livecode mailing list