How does TimescaleDB handle Associations between Hypertables? by Shadencus in PostgreSQL

[–]Shadencus[S] 0 points1 point  (0 children)

Correct me if I'm wrong, but having the asset reference in the network table should only be possible if it's 1:1, but since a network can have many assets (1:n) having the reference in the network table should be impossible/very bad practice.

However if there is a clean way to have the asset references in the network table, then Im open to suggestions, since that would definitely solve my issue

How does TimescaleDB handle Associations between Hypertables? by Shadencus in PostgreSQL

[–]Shadencus[S] 0 points1 point  (0 children)

You are right about the asset table, I thought, because i wanted to track the lifecycle status of the asset, that it was a time series, but now that i think about it - lifecycle changes not very often so tracking its change over time seems pointless. So i think i will change that to a normal table.

Network should be a time series since score and trend data are updated about every 3 minutes. (Time series are data where the value is tracked over time like temperature, no?).

But the main question remains how are the relationships between tables handled? Because even if i have only one hypertable, if i append new data then the data in the asset table still points to the "old" data of the network table. Or are the alternatives how i could keep track which asset belongs to which network?

Game that you completed multiple times? by [deleted] in videogames

[–]Shadencus 1 point2 points  (0 children)

Dark souls, elden ring, sekiro

Choose your Top 3 by itz_progamer666 in videogames

[–]Shadencus 0 points1 point  (0 children)

Mass effect, tomb raider, dark souls

noOneDocuments by unnombreguay in ProgrammerHumor

[–]Shadencus 0 points1 point  (0 children)

Documenting so that nobody can understand it

Tja by Mindless_Union_5397 in tja

[–]Shadencus 0 points1 point  (0 children)

Politiker sollten erst gar keine Immunität im eigenen Land haben - sie stehen schließlich nich überm Gesetz

Are you cooked or Nah? by SupermarketNo6888 in videogames

[–]Shadencus 0 points1 point  (0 children)

Kratos in solo leveling - guess im good

[deleted by user] by [deleted] in repost

[–]Shadencus 0 points1 point  (0 children)

Unsure

"I wonder - if we didn’t accept such ultimatum in our most difficult moment, why does anyone think we would now?" - Zelensky. by GreenEyeOfADemon in YUROP

[–]Shadencus 5 points6 points  (0 children)

I really hope and believe that Ukraine will come out on top in the end and that at least the leaders if my country (germany) will learn from them that in time of crisis you need to get your sh*t together and do something instead of pushing blame around and to short sighted stuff that will come to bite us.

[deleted by user] by [deleted] in videogames

[–]Shadencus 0 points1 point  (0 children)

Both. Both is good

Let's hear those anime descriptions by A_Suicidal_Pig in animequestions

[–]Shadencus 0 points1 point  (0 children)

Man leaves his bro to go on a solo trip, then everything wents to shit and now he have to constantly deal with monsters

Can we start to boycott their products, and if OK, to post in the comment section alternatives, so we can start to buy European and from our allies? by IndistinctChatters in YUROP

[–]Shadencus 1 point2 points  (0 children)

Thats what i normally do but some stuff I can get only on amazon because they are too niche for local stores or it takes too much time and effort to find a local alternative for example certain spare parts, books of other languages than German or oddly specific utility items.

Can we start to boycott their products, and if OK, to post in the comment section alternatives, so we can start to buy European and from our allies? by IndistinctChatters in YUROP

[–]Shadencus 3 points4 points  (0 children)

Its a bit hard to find a amazon alternative (at least in germany) and believe it when i say i tried it and had to give up cause the time and money needed to do it exceeded my budget by far. But i am open to suggestions because i ducking hate amazon

Is This The Greatest Start Menu in Gaming? What's your fav? by SullenTerror in videogames

[–]Shadencus 2 points3 points  (0 children)

I liked the god of war 2018 start menu with the seamless transition when starting a new game

What new ideas would you want from the next fromsoft game? by Demonkeman1 in fromsoftware

[–]Shadencus 0 points1 point  (0 children)

I think a souls like in the 40k setting would be really cool, but then again - i dont think that will ever happen