| # |
Sep 8th 2019, 22:31 |
 itmpls |
hmm? |
| # |
Sep 8th 2019, 22:31 |
itmpls |
@jimbo2150 I debugged and apparently it's the `SHOW FULL COLUMNS` on that table , but the connection is 'default' |
| # |
Sep 8th 2019, 20:34 |
itmpls |
but yeah lemme try to debug further (resuming) |
| # |
Sep 8th 2019, 20:33 |
itmpls |
@jimbo2150 if that were the case this query would work, though |
| # |
Sep 8th 2019, 09:42 |
challgren |
https://stackoverflow.com/questions/1061710/php-zip-files-on-the-fly |
| # |
Sep 8th 2019, 09:41 |
COOurb |
won't* |
| # |
Sep 8th 2019, 09:41 |
COOurb |
and we won use it more than 2 times a day |
| # |
Sep 8th 2019, 09:41 |
COOurb |
I'm at vacation now and making this "software" to help me (and guys from other departments) to create different document packages |
| # |
Sep 8th 2019, 09:40 |
COOurb |
there are from 1 to 10 users |
| # |
Sep 8th 2019, 09:39 |
challgren |
Ok so what happens when 100 users request a zip, you have 1GB of memory used |
| # |
Sep 8th 2019, 09:39 |
COOurb |
It's for local usage, kinda filling documents with values |
| # |
Sep 8th 2019, 09:39 |
COOurb |
archives are small, up to 10MB. |
| # |
Sep 8th 2019, 09:39 |
challgren |
Think about scalability and using memory wisely |
| # |
Sep 8th 2019, 09:38 |
challgren |
And creating the file in memory will take up memory which you’ve said is a concern, and what happens when 10+ users request a zip file |
| # |
Sep 8th 2019, 09:37 |
COOurb |
thnx |
| # |
Sep 8th 2019, 09:36 |
challgren |
Example would be `$this->QueuedJobs->createJob('DeleteZip', ['filename' => $tmp_zip], ['notBefore' => strtotime('+1 hour')]);` |
| # |
Sep 8th 2019, 09:35 |
COOurb |
ye, but it's kinda sad |
| # |
Sep 8th 2019, 09:33 |
challgren |
Like I said, create the zip, create a queue task to clean up in a certain time and serve the zip file to the user. The queue will clean up the file at the specified time |
| # |
Sep 8th 2019, 09:33 |
COOurb |
it's ok |
| # |
Sep 8th 2019, 09:33 |
COOurb |
yeah, I know there is ZipArchive built-in class |
| # |
Sep 8th 2019, 09:32 |
COOurb |
well, ok, I'll try that queue task plugin |
| # |
Sep 8th 2019, 09:32 |
challgren |
CakePHP provides no classes for zipping files. So you would need some other class in PHP or a native class provided by PHP |
| # |
Sep 8th 2019, 09:32 |
COOurb |
I mean, I saw /tmp directory |
| # |
Sep 8th 2019, 09:32 |
challgren |
What do you mean? |
| # |
Sep 8th 2019, 09:32 |
COOurb |
does cakephgp has something like that? |
| # |
Sep 8th 2019, 09:31 |
challgren |
You could but on a shared server anyone could access that file and you depend on the system to clean up the files |
| # |
Sep 8th 2019, 09:30 |
COOurb |
what if I use tmp directory via "php://tmp"? |
| # |
Sep 8th 2019, 09:29 |
challgren |
You realize there is no Zip class in cakephp |
| # |
Sep 8th 2019, 09:28 |
COOurb |
No correct way? Wow, that's upset. |
| # |
Sep 8th 2019, 09:27 |
challgren |
For my app I first check for the existing zip if not create the zip, then create a queue task to clean up the zip in 1 hour and then send the file to user |
| # |
Sep 8th 2019, 09:26 |
challgren |
Ok well you may miss responses from other people, but AFIK theres no correct way. The best way would be to generate it and send the zip and then clean up the temp file |
| # |
Sep 8th 2019, 09:25 |
COOurb |
so I can't |
| # |
Sep 8th 2019, 09:25 |
COOurb |
slack eats much RAM |
| # |
Sep 8th 2019, 09:25 |
challgren |
Also if you join us on slack you can see responses that may come in after you log off irc |
| # |
Sep 8th 2019, 09:25 |
COOurb |
Is there any example of correct way to do it? I mean, sending file without storing it permanently? |
| # |
Sep 8th 2019, 09:24 |
COOurb |
yeah, got it. |
| # |
Sep 8th 2019, 09:23 |
challgren |
You could add your task before calling return |
| # |
Sep 8th 2019, 09:23 |
COOurb |
As I know there is no execution after it |
| # |
Sep 8th 2019, 09:23 |
COOurb |
ok, but to send file to user I have to call 'return' or reach end of the action. |
| # |
Sep 8th 2019, 09:23 |
challgren |
https://github.com/dereuromark/cakephp-queue |
| # |
Sep 8th 2019, 09:22 |
COOurb |
queue task? |