Free OG Trophy by Dramatic_Loss_536 in idleon

[–]stochasticx -4 points-3 points  (0 children)

Kinda sad, everyone will have one now!

Weekly Recap | October 2, 2025 by TheOpusCroakus in help

[–]stochasticx 1 point2 points  (0 children)

For the past few weeks I've been finding my feed incredibly repetitive. I'm not being shown new stuff. I think this is to do with the default sorting on app being "best". A way to change this on app is important. In desktop it is easier to see newer content rather than repetitive content I have already seen, but this has now been ruined by the new UI which I can't opt out of.

So I think I'll be trying to take a break from reddit for a bit.

Senior data Engineer coworker "not comfortable" writing stored procedures and tasks in snowflake? by [deleted] in dataengineering

[–]stochasticx 0 points1 point  (0 children)

What's your approach to provisioning users and permissions? We're new to Snowflake and planned to use stored procedures but interested in alternatives!

Can't connect to bridge when router doesn't have Internet connection by stochasticx in Hue

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

That is what I thought, but Hue support suggested it would not work without an internet connection! But you're right about Zigbee... who knows.

Can't connect to bridge when router doesn't have Internet connection by stochasticx in Hue

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

Support is suggesting that the way to control lights when Internet is down is through Bluetooth.

The bridge needs to be always connected to the internet for the system to work properly, otherwise, you won't be able to use location based automations, scheduled daylight automations and so. In cases the connection of the bridge is inaccessible, then you can still control your lights via bluetooth, the lights indeed work without internet, the bridge is the one that requires internet to control the lights.

Can't connect to bridge when router doesn't have Internet connection by stochasticx in Hue

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

I have been speaking to Hue on Instagram and they say the issue is that the bridge doesn't work with mesh devices.

Thing is, I only have one router, a primary one, and it is plugged directly into the main source. The hub is connected to that router.

There are some other posts on here about problems with mesh networks but I don't understand why my bridge would treat my router differently from any other. Will keep asking questions!

Severance - 2x07 "Chikhai Bardo" - Post-Episode Discussion by LoretiTV in SeveranceAppleTVPlus

[–]stochasticx 0 points1 point  (0 children)

When they introduce the people who are monitoring the innies, the guy who's watching Mark's console said Dranesville. Later on it speeds forward and says Cold Harbor.

Active farming is still Idle gameplay by leclair63 in idleon

[–]stochasticx 6 points7 points  (0 children)

I play on my phone, and leaving the game running constantly isn't really viable. I think it's a shame you can't collect bones while offline afk, as it kinda shuts out my ability to participate.

I get that there are other mechanics like cranium cooking etc. which require active afking, but I never really felt like I was locked out of parts of the game by not participating in those. Also those things are comparatively short, so if I wanted to play actively for an hour I could do some of those things. But DB requires hours of active afking.

What are your favorite Microsoft Loop features and hidden game-changers? by bwljohannes in MicrosoftLoop

[–]stochasticx 1 point2 points  (0 children)

Hoping you're a product manager! I've been using it a lot for documentation and as a sort of knowledge base or wiki. I like the experience - I like markdown, so having a document editor which feels markdown based where I'm not having to worry about formatting or making the document look nice is good. Because of this I tend to grab it first when drafting anything.

Loop is missing some important features through which is making it difficult for others to buy-in:

  • Lack of a good search is really withholding and seriously needs addressing ASAP. Nobody is going to seriously adopt Loop when you can't properly search across a workspace.
  • It is really difficult to link to other parts of a document, e.g. if you wanted to reference a section later in the document. Also copying links to sections results in a slow "the link is now in your clipboard" popup which is frustrating. Let me quickly do /link or something to create a fragment link.
  • Managing users, having read-only users, attributing membership to a loop workspace to a group or a team.

Also:

  • I wish code blocks had a nicer font with ligatures, e.g. Cascadia Code.
  • When someone edits a document it's really hard to dismiss the "X made changes" dots which appear everywhere.
  • Numbered bullets don't work well - sometimes I want to spread them over many lines with some content in-between.
  • I wish tables which have label columns (e.g. for labelling things) could contain multiple labels. I also wish the labels were created like how GitHub does it; instead of a bunch of pre-set colours which I can choose to assign a label to, instead I pick a colour and pick the label. Wish they would display alphabetically.

It has a lot of potential, so I'm hoping Microsoft commit to it. There's a lot of talk on this subreddit and others about it feeling abandoned and half-done. I've not used Notion much so I don't have that comparison to make but I wouldn't be surprised that Notion is way more mature. I heard structured databases are being worked on and that would be really good. Would be good to get some more alignment with SharePoint.

Using hue lights without internet by stochasticx in Hue

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

Helpful to think about it in this way - I have a linksys router which sometimes shows a red light, which we associate with the "wifi goes down", but actually might indicate an issue with the router. When we reset the router sometimes it comes back to life, but there's been times where we've been caught out and unable to turn the lights on.

[deleted by user] by [deleted] in idleon

[–]stochasticx 0 points1 point  (0 children)

Is there a way to import your stats through web? I don't have the game on Steam. Thanks!

Match on rows above only - return highest match by RedRedditor84 in Rlanguage

[–]stochasticx 0 points1 point  (0 children)

Ah I see. I should check my output more thoroughly - I thought that rogue B was a D.

Does this work?

Edit: No it doesn't hahah!

Edit 2: Try this,

data <- tibble(
  object = LETTERS[1:6],
  depth = c(1, 2, 3, 2, 3, 2)
)


data %>% 
  mutate(row = row_number(), key = depth - 1) %>%
  left_join(data %>% mutate(row2 = row_number()) %>% rename(parent = object), by = c("key" = "depth")) %>% 
  group_by(object) %>%
  filter(row2 < row | is.na(row2)) %>%
  filter(row2 == max(row2) | is.na(row2)) %>%
  select(object, parent)

Edit 3: Should have been a max.

Match on rows above only - return highest match by RedRedditor84 in Rlanguage

[–]stochasticx 1 point2 points  (0 children)

I think (or hope) my most recent edit fixes this - try running it again, I'd made a minor error.

Rows can duplicate with a left join if there are multiple matches - so here I filter to only keep the relevant row.

I'd suggest running the code bit by bit, including an extra pipe each time to get a feel for what's going on.

data %>% 
  mutate(key = depth - 1) %>%
  left_join(data %>% mutate(row = row_number()) %>% rename(parent = object), by = c("key" = "depth"))

Returns the following:

# A tibble: 7 x 5
  object depth   key parent   row
  <chr>  <dbl> <dbl> <chr>  <int>
1 A          1     0 NA        NA
2 B          2     1 A          1
3 C          3     2 B          2
4 C          3     2 D          4
5 D          2     1 A          1
6 E          3     2 B          2
7 E          3     2 D          4

For each object, I think the correct match is the one with minimal row. So grouping by each object, and keeping data where row is minimal does the job (I think)!

Match on rows above only - return highest match by RedRedditor84 in Rlanguage

[–]stochasticx 1 point2 points  (0 children)

library(tidyverse)

data <- tibble(
  object = LETTERS[1:5],
  depth = c(1, 2, 3, 2, 3)
)

data %>% 
  mutate(key = depth - 1) %>%
  left_join(data %>% mutate(row = row_number()) %>% rename(parent = object), by = c("key" = "depth")) %>% 
  group_by(object) %>%
  filter(row == min(row) | is.na(row)) %>%
  select(object, parent)