# |
May 25th 2016, 12:03 |
ionas |
the tree behavior is nested set |
# |
May 25th 2016, 12:03 |
hmic |
there exist solutions to speed that up too, quite a bit acutally |
# |
May 25th 2016, 12:02 |
ionas |
hmic there are adjacency lists, nested sets, closure table, fertile forest, nested interval (donâ??t know), materialized path on ids, materialized path on real labels etc |
# |
May 25th 2016, 12:02 |
hmic |
the only thing that speaks against it is updating (inserting specifically) into a big tree all the time, which is seldomly the case |
# |
May 25th 2016, 12:02 |
lampsBR |
Hi guys! How can I set a cake.i18n.date to past monday? I'm using cakephp 3.2. I'm trying $lol = new Date(); $lol->modify('past monday'); but this way I get an error message |
# |
May 25th 2016, 12:02 |
jippi |
ionas: haha, no, not quite :p but josé will still be there :D |
# |
May 25th 2016, 12:01 |
hmic |
ionas, that specific question and given sql, i'd go nested set, *ever* |
# |
May 25th 2016, 12:01 |
ionas |
jippi what the fuck!! got pregnant? |
# |
May 25th 2016, 12:01 |
ionas |
hmic: nested sets? I only had bad experiences |
# |
May 25th 2016, 12:01 |
hmic |
but if neccessary there are 2 solutions: adjacent lists and nested sets. if you are going more than a handfull levels deep, nested set only. |
# |
May 25th 2016, 12:01 |
jippi |
ionas: i had to cancel last minute :\ |
# |
May 25th 2016, 12:01 |
ionas |
â?¦ for your commercial projects ;) when required to save tree structures (cakephp3) what do you do? |
# |
May 25th 2016, 12:01 |
hmic |
ionas, i dont like them really, there are other means than sql databases to store trees. |
# |
May 25th 2016, 12:01 |
ionas |
jippi looking forward to meet you too :) |
# |
May 25th 2016, 12:00 |
jippi |
@neothermic: feel free to do so :) |
# |
May 25th 2016, 11:59 |
ionas |
anyone using such https://www.postgresql.org/docs/current/static/ltree.html |
# |
May 25th 2016, 11:58 |
ionas |
see you later |
# |
May 25th 2016, 11:58 |
ionas |
probably last |
# |
May 25th 2016, 11:58 |
ionas |
fertile forest, closure table, materialized path |
# |
May 25th 2016, 11:58 |
ionas |
I am inclined to NOT use nested setsâ?¦ too error prone and bad on writing to large data sets |
# |
May 25th 2016, 11:58 |
hmic |
as i said, the cityinn express next to the mariott |
# |
May 25th 2016, 11:58 |
ionas |
what do you use to store trees in SQL? |
# |
May 25th 2016, 11:57 |
ionas |
;p |
# |
May 25th 2016, 11:57 |
ionas |
hmci one last question |
# |
May 25th 2016, 11:57 |
ionas |
okay enjoy |
# |
May 25th 2016, 11:57 |
ionas |
I am 20mins to walk (shorter by public transport) from the conference place |
# |
May 25th 2016, 11:57 |
hmic |
need to catch something for lunch now, can meet up later |
# |
May 25th 2016, 11:57 |
ionas |
where will you reside? |
# |
May 25th 2016, 11:57 |
ionas |
hmic I ll be there at 15:30 |
# |
May 25th 2016, 11:57 |
hmic |
ionas, im in amsterdam already. just arrived at the cityinn express next to the mariott |
# |
May 25th 2016, 11:50 |
ionas |
https://github.com/cakephp/cakephp/pull/8753 |
# |
May 25th 2016, 11:50 |
ionas |
it should work |
# |
May 25th 2016, 11:50 |
ionas |
stopMe: if you can figure out why the two tests are not correct |
# |
May 25th 2016, 11:49 |
ionas |
it might be taught to return non UTC datetimes on reads |
# |
May 25th 2016, 11:49 |
ionas |
as it stores real UTC datetimes |
# |
May 25th 2016, 11:49 |
ionas |
stopMe: also Iâ??d ask in postgresql |
# |
May 25th 2016, 11:48 |
ionas |
however I could not manage two of tons of test cases to perform correctly |
# |
May 25th 2016, 11:48 |
ionas |
stopMe: there is a PR about output timezone configuration |
# |
May 25th 2016, 11:47 |
ionas |
do you use nested set for bigger projects? |
# |
May 25th 2016, 11:44 |
lampsBR |
Hi guys! How can I set a cake.i18n.date to past monday? I'm using cakephp 3.2. I'm trying $lol = new Date(); $lol->modify('past monday'); but this way I get an error message |
# |
May 25th 2016, 11:38 |
adamru |
it worked in earlier versions |