| # |
Apr 4th 2019, 13:17 |
 admad |
you can create cache config which use `ArrayEngine` which would be in memory |
| # |
Apr 4th 2019, 13:16 |
val |
Or do I get it wrong? |
| # |
Apr 4th 2019, 13:16 |
val |
@admad if I understood correctly that uses cache config, f.ex. memcached. In-memory-caching with `cacheQueries` in cake 2.x allows to minimize the number of hits to memcached. |
| # |
Apr 4th 2019, 13:14 |
admad |
that allows you pretty much the same what you described |
| # |
Apr 4th 2019, 13:14 |
admad |
@val https://book.cakephp.org/3.0/en/orm/query-builder.html#caching-query-results |
| # |
Apr 4th 2019, 13:13 |
weto.jc |
@rochasmarcelo the connection works this way with pure php```$db = new mysqli("meubanco", "admin", "123456", "DATABASE_NAME");``` |
| # |
Apr 4th 2019, 13:10 |
admad |
the right person to have this conversation with would be @lorenzo |
| # |
Apr 4th 2019, 13:09 |
val |
@admad I think technically the final SQL is not really needed for in-memory-caching. The prepared statement and the query params could be json encoded, merged and md5'ed in order to generate the cache key. |
| # |
Apr 4th 2019, 13:02 |
ricksaccous |
interesting |
| # |
Apr 4th 2019, 13:02 |
admad |
before have you just have placeholders in the query |
| # |
Apr 4th 2019, 13:01 |
admad |
@val with pdo prepared statements you can't have the final SQL until query is actually executed |
| # |
Apr 4th 2019, 13:00 |
ricksaccous |
you have a cache method now but you have to feed it some params |
| # |
Apr 4th 2019, 12:57 |
val |
@admad is there a good reason why `cacheQueries` property was removed? |
| # |
Apr 4th 2019, 12:57 |
weto.jc |
@rochasmarcelo changing to 'mysql' the host has the following error: ```{"code":"500","url":"ROUTE_URL","name":"Database connection andquot;SQLSTATE[HY000] [1044] Access denied for user and#039;adminand#039;@and#039;%and#039; to database and#039;DATABASE_NAMEand#039;andquot; is missing, or could not be created."}``` |
| # |
Apr 4th 2019, 12:49 |
rochasmarcelo |
@weto.jc host is the service name, normally 'mysql' |
| # |
Apr 4th 2019, 12:45 |
admad |
sunny: you sure can |
| # |
Apr 4th 2019, 12:44 |
admad |
@val there isn't any |
| # |
Apr 4th 2019, 12:24 |
weto.jc |
version php 5.x |
| # |
Apr 4th 2019, 12:09 |
weto.jc |
``` ```'host' => 'meubanco',links: - meubanco:mysql``` and 'login' => 'admin', 'password' => '123456',``` |
| # |
Apr 4th 2019, 12:01 |
weto.jc |
Hi everyone, I'm creating a docker development environment for a legacy cackephp application (version 2.x), but I'm having trouble connecting to the database that is another container. When I connect to mysqli it works but when I connect through database.php it is giving the following error: How do I report the data in database.php? |
| # |
Apr 4th 2019, 11:38 |
sunny |
hi |
| # |
Apr 4th 2019, 11:34 |
sunny |
where i will store pem files |
| # |
Apr 4th 2019, 11:33 |
sunny |
can i have a private folder outside webroot? |
| # |
Apr 4th 2019, 11:33 |
sunny |
hi |
| # |
Apr 4th 2019, 11:20 |
val |
Hi, what is the equivalent of 2.x `$this->MyModel->cacheQueries = true;` in 3.x? |
| # |
Apr 4th 2019, 10:57 |
neon1024 |
Breaks the S in SOLID |
| # |
Apr 4th 2019, 10:57 |
neon1024 |
The thing which puts me off Entity methods is that an entity shouldn’t know how it’s data is displayed |
| # |
Apr 4th 2019, 10:56 |
neon1024 |
Fractal was nice, but didn’t allow us to match our existing web service response format :( |
| # |
Apr 4th 2019, 10:56 |
neon1024 |
So it’s kinda data and view |
| # |
Apr 4th 2019, 10:56 |
neon1024 |
I’m undecided because it’s data manipulation, but only for JSON response |
| # |
Apr 4th 2019, 10:55 |
neon1024 |
Didn’t look into it |
| # |
Apr 4th 2019, 10:54 |
dereuromark |
why not using my dtos then?^^ |
| # |
Apr 4th 2019, 10:53 |
neon1024 |
I think new classes would be cleaner |
| # |
Apr 4th 2019, 10:52 |
neon1024 |
I’m looking to mimic the functionality of Fractal, and I can’t decide if I should make my transformers their own class, implementing an interface, or if they should be entity mutation methods |
| # |
Apr 4th 2019, 08:17 |
neon1024 |
Morning all :wave: |
| # |
Apr 4th 2019, 07:26 |
patox44 |
1 problem. I have numbers. How can I make array with keys? |
| # |
Apr 4th 2019, 07:10 |
patox44 |
`$connection->execute($query)->fetchAll('assoc');` How can I fetch it not to object, but to array? I need array of arrays |
| # |
Apr 4th 2019, 06:48 |
kgb.acct.personal |
Hello everyone, How do you handle large amount of resultset in cakephp? Do you just get the total count then loop on every record? |
| # |
Apr 4th 2019, 03:39 |
chan |
@challgren thanks |
| # |
Apr 4th 2019, 03:31 |
challgren |
@chan https://support.google.com/docs/answer/183965?co=GENIE.Platform%3DDesktopandhl=en |
| # |
Apr 4th 2019, 03:29 |
challgren |
@chan that would be something to look at Google drive support |