# |
May 25th 2016, 12:54 |
hmic |
its raining hard :-( |
# |
May 25th 2016, 12:54 |
hmic |
http://pasteboard.co/1bAIz3Up.jpg |
# |
May 25th 2016, 12:46 |
phpnut |
hmic I never noticed that |
# |
May 25th 2016, 12:29 |
stopMe |
welcom to the Amsterdam :D |
# |
May 25th 2016, 12:23 |
hmic |
wow, this is hillarious: i've just looked at the amsterdam city map the hotel has... it has 2 distinct tourist information signs: "tourist information" (red quare with an embedded i) and "gay tourist information" (rose triangle, upside down with an embedded i) |
# |
May 25th 2016, 12:19 |
stopMe |
I can´t figure out how to "adapt" dates with this PR |
# |
May 25th 2016, 12:18 |
ionas |
so awesome of a RDMBS |
# |
May 25th 2016, 12:18 |
ionas |
working after only doing CREATE EXTENSION ltree; in postgres |
# |
May 25th 2016, 12:18 |
ionas |
SELECT path FROM test WHERE path <@ 'Top.Science.Astronomy'; looks quite good |
# |
May 25th 2016, 12:18 |
ionas |
stopMe: yes I am |
# |
May 25th 2016, 12:17 |
stopMe |
ionas: are you there? |
# |
May 25th 2016, 12:15 |
ionas |
hmic: understood - so people weak up and make hmic leave his laptop for food |
# |
May 25th 2016, 12:15 |
ionas |
hmic must evolve around indexes |
# |
May 25th 2016, 12:14 |
hmic |
anybody wants to play some hardware projects during cakefest? - i've got some nice stuff with me ;-) |
# |
May 25th 2016, 12:13 |
hmic |
the question about lunch options was for the group, as i suspect ppl already be nearby |
# |
May 25th 2016, 12:12 |
hmic |
thats what i said: go with the tree behaivor, its tested and working and does not eat your data ;-) i can tell you the quick hint on insert perfomrance later... |
# |
May 25th 2016, 12:12 |
ionas |
Iâ??d try to look for a falafel place personally ;P |
# |
May 25th 2016, 12:11 |
ionas |
sadly not I havenâ??t been to amsterdam for years |
# |
May 25th 2016, 12:11 |
hmic |
any recommendations? local fast food in the area? - walking distance |
# |
May 25th 2016, 12:11 |
ionas |
then stop being ;) |
# |
May 25th 2016, 12:11 |
ionas |
I try biting my nails once and then probably will try to do 100% vanilla treebehavior |
# |
May 25th 2016, 12:11 |
hmic |
still in the hotel at my notebook... |
# |
May 25th 2016, 12:11 |
ionas |
enjoy your lunch |
# |
May 25th 2016, 12:11 |
ionas |
hehe |
# |
May 25th 2016, 12:09 |
hmic |
exactly like that |
# |
May 25th 2016, 12:09 |
hmic |
composite keys are a thing on its own |
# |
May 25th 2016, 12:09 |
hmic |
you dont need composite keys for storing multiple trees in a table |
# |
May 25th 2016, 12:09 |
ionas |
I should have just created one root node per â??foreign keyâ? |
# |
May 25th 2016, 12:09 |
ionas |
well basically composite primary key and storing multiple trees in one table |
# |
May 25th 2016, 12:09 |
hmic |
you might have had, if not/misunderstandings happened or you screwed your data beause of manual interactions, sure |
# |
May 25th 2016, 12:08 |
hmic |
tell about them |
# |
May 25th 2016, 12:08 |
ionas |
I had bad xp with nested sets - you did not? |
# |
May 25th 2016, 12:08 |
ionas |
hehe |
# |
May 25th 2016, 12:08 |
ionas |
(stroke reading) |
# |
May 25th 2016, 12:08 |
hmic |
i can help you on insert performance on large trees, if you need to |
# |
May 25th 2016, 12:08 |
ionas |
hmic huh when I move parts of the table only those parts are affected in terms of reading and writing |
# |
May 25th 2016, 12:07 |
hmic |
if you have a show stopper with it, lets talk about it! |
# |
May 25th 2016, 12:07 |
hmic |
my 5ct on the topic: if you can go with a nested set and use tree behavior, by all menas do so! |
# |
May 25th 2016, 12:07 |
hmic |
ionas, your materialized path is nothing but a written down nodelist, that is a nested set still! |
# |
May 25th 2016, 12:06 |
ionas |
I ll take a harder look at https://www.postgresql.org/docs/current/static/ltree.html hmic and in case it takes too long just opt for build in treebehavior |
# |
May 25th 2016, 12:05 |
lampsBR |
bernat1: It works! Thanks dude |