egghelp/eggheads community

gzcompress

2012-04-14T03:14:16-04:00

look for a way to do it with images cause images like jpeg is basically just compressed data, .. read about "blob" type unless you're inserting text then you might better find something like drive compression never really looked into it but i know it used to be on ntfs, years ago when i still used windows, .. that there was this feature to compress all your data onto fly when you stored it on disk. I never saw much use for it and never really looked for something like that cause most of my files where jpeg or media files and then it's useless to compress them once more, .. it's only a waste of cpu time. I'm pretty sure you can set up some sort of zip drive, or whatever you want to call it in any os.

Statistics: Posted by Ofloo — Sat Apr 14, 2012 3:14 am

gzcompress

2012-03-07T09:12:35-04:00

Okay, thanks for the reply

Statistics: Posted by Fire-Fox — Wed Mar 07, 2012 9:12 am

gzcompress

2012-03-07T01:24:47-04:00

A quote from a user on this topic that is related to gzcompress.

This is a bad idea because:
- theoretically, there might be a sequence of data that, when compressed, leads to a SQL injection or simply breaks the query
- gzcompressed data can't be properly indexed and searched - you'll have a database full of garbled characters
- gzcompression is computationally expensive

Simply always sanitize your data before entering it into a database, using the string escaping method of your library (like mysql(i)_real_escape_string()) or parametrized queries. If you do that reliably, no further protection is necessary.

You will end up getting an error like:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'cUÓyM›û]YûßTS§mÖø_öè|®SÝT?½¥®Ê!y{ëVùÊP†’Â1�'‰;(§�èh$1Cà�b

Statistics: Posted by caesar — Wed Mar 07, 2012 1:24 am

gzcompress

2012-03-06T17:14:37-04:00

Is there a way of gzcompress stuff before inserting it to database...?

Statistics: Posted by Fire-Fox — Tue Mar 06, 2012 5:14 pm