Re: BLOB Storage Errors
It's okay, it's not something I can implement right away. Besides none of the files I really care about are having an issue, but someone is going to try and insert one of these problem files in the future and it's going to crash a standalone. I'll look into it later. I'll just open a file for binary read, read until EOF, base64encode it, base65devoce it, write it binary back to the disk and see if it survives intact. Bob S > On Jul 31, 2019, at 13:59 , JJS via use-livecode > wrote: > > wel copying the piece of scipt did not go flawless > > Also i blindly assumed you talked about storing images as BLOB ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: BLOB Storage Errors
wel copying the piece of scipt did not go flawless Also i blindly assumed you talked about storing images as BLOB Op 31-7-2019 om 21:37 schreef JJS via use-livecode: *i use something like this: * * * *put base64encode(image "productphoto") into tGT* *put URLencode(tGT) into tPrdFt put "phototable=" & tT & "=" & gId & "=" & 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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: BLOB Storage Errors
*i use something like this: * * * *put base64encode(image "productphoto") into tGT* *put URLencode(tGT) into tPrdFt put "phototable=" & tT & "=" & gId & "=" & 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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: BLOB Storage Errors
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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
BLOB Storage Errors
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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
