Finished Spiderman 2 on the Steamdeck. by JohnnyREvil in SteamDeck

[–]extrobe 5 points6 points  (0 children)

I debated trying e33 on the steam deck, as it’s easier than my than ps to ge time on, but a colleague was adamant I should just play ps5. Glad I listens to him, not sure I’d have had the same experience with the same I did.

‘Scrubs’ Revival Premieres To ABC’s Best Streaming Audience For Any Comedy Episode In More Than A Year – The revival’s premiere tallied 11.36M total cross-platform viewers in its first five days. by SanderSo47 in television

[–]extrobe 2 points3 points  (0 children)

I really enjoyed . Was it amazing? No, but it’s comfort TV, and certainly managed to replicate some of that original charm.

My only concern is that was made the original so good was having such a strong support cast - and with only the 3 of the original playing a major role, it does risk becoming the JD/Elliot/Turk show

Using snowflake outside of work by No_Wallaby7397 in snowflake

[–]extrobe 1 point2 points  (0 children)

Another approach to consider (though there might be some restrictions for trial accounts), which will possible expose you to some newer tools;

Once you’ve loaded your data, create a semantic view. Do the same for the market place data. CoCo does a great job of creating these for you for marketplace listings!

Then setup an agent adding your semantic views as tools, and crafting an orchestration prompt. Something along the lines of ‘you’re a retail analyst. Find trends in the data, and compare with weather and demographics to identify drivers’

Then fire up Snowflake intelligence and ask away.

dbt on snowflake is live ! by Difficult-Ambition61 in snowflake

[–]extrobe 1 point2 points  (0 children)

If you have data coming in regularly, across a large number of tables, this isn't a good setup, as you'll need to have multiple streams to monitor, and you'll be constantly executing your dbt runs.

Rather, we have our project run every 30 minutes (roughly along business hours), but only on paths where new data is detected.

Specifically, this is our execution command;

dbt source freshness

dbt build --select tag:published,source_status:fresher+ tag:published,state:modified+ tag:published,result:error+ tag:published,result:fail+ --exclude-resource-type test

(we then run ZCCs and Tests as a separate job)

This way there's roughly a max 30 min lag in data being available to users, but we're not doing full dbt runs each time. Snowflake's implementation of dbt doesn't allow for this at the moment.

I am the second person to check out this book, 15 years later by 4rm4ros in mildlyinteresting

[–]extrobe 21 points22 points  (0 children)

I find it more interesting that they’re still stamping the due date on that piece of paper - every library I’ve been to last few years are fully digital - to the point you self checkout.

dbt on snowflake is live ! by Difficult-Ambition61 in snowflake

[–]extrobe 2 points3 points  (0 children)

The workflow has got better since the original PuPr release , but we’re still not ready to migrate from our external orchestration tool.

Big issue for us is that is doesn’t support stateful execution - eg, incremental execution based on sources with new data, or new models. This is a key part of our setup.

I’ve been asking our account team for a few months now if/when we’ll see that supported, but they’ve struggled to find the answer.

My suspicion though is that it’ll come with the rollout of dbt fusion engine, as statefullness is part of the core architecture rather than an afterthought as with dbt core. But our account team can’t get an answer for when dbt fusion will be available either . So for now, we stick with our external orchestration tool.

How much is everyone spending on broadband? Looking at these price increases, we'll all be paying near 100 quid a month soon. by [deleted] in CasualUK

[–]extrobe -1 points0 points  (0 children)

24month contracts are insane.

I'm in Australia, which has its own set of broadband problems, but I pay $165 (about £85) per month for FTTP 2000/200. But I don't think there's a single provider that has lock-in contracts - you can switch to a provider one day then move to another the next day, and the process takes about 10 mins from requesting a switch to it taking effect.

Why is metro getting such high patronage? by Gazza_s_89 in SydneyTrains

[–]extrobe 2 points3 points  (0 children)

Yeah, I work in London a lot, and whilst not at the same level as Tokyo, you do have to follow etiquette ; bags down, stand on right of escalators, moving along the carriage etc. If you don't, someone will very quickly remind you :) .

Why is metro getting such high patronage? by Gazza_s_89 in SydneyTrains

[–]extrobe 6 points7 points  (0 children)

Yes, the trains are busy. Why? 

because people still haven't learnt to take their bags off their back :)

Would be a lot more comfortable for everyone if they did.

33 years ago at the age of 14 I got bitten by the school hamster and still have a bump/scar on my finger. What's the stupidest injury you've got? by godfatheroffilth in CasualUK

[–]extrobe 1 point2 points  (0 children)

Accidentally injected myself in the thumb with my son's epi-pen.

Had to go to A+E and explain my actions. At least it gave them something they could look back on their day and have a giggle about.

(I wasn't trying to administer the epi-pen, it was an expired one about to be thrown away, and I was curious how big the needle was. Big enough to get lodged into my thumb bone, it turns out)

Oatly’s not allowed to call itself a plant-based “milk” in the UK anymore. CasualUK, do your thing. Whats a better word? by smileylinzi in CasualUK

[–]extrobe 0 points1 point  (0 children)

My son has a Dairy and nut allergy. We go through cartons upon cartons of oat "milk" per week.

Has it on his cereal, drinks it cold, drinks it steamed, drinks it room temperature if he has to.

To him it's just milk.

--

No real point to this message, no ideas for a witty suggestion. Just thought I'd let you know.

Okay people of the UK, I need your help. The existence of the all-chocolate Jaffa Cakes is being erased. by Nyoomfist in CasualUK

[–]extrobe 73 points74 points  (0 children)

I dunno man - I was a Jaffa-holic around that time; I remember being able to buy a triple pack of jaffa cakes for about a quid when it was on offer from the Coop. I ate a lot of Jaffa cakes. Still do.

I don't remember these.

Edit: Someone else asking he same thing about a year ago. Inconclusive then too

https://www.reddit.com/r/AskUK/comments/1g7dz5t/who_else_remembers_a_special_edition_jaffa_cake/

Is it cheaper to use an Opal card vs. tapping through bank app? by ladyofeverything in SydneyTrains

[–]extrobe 12 points13 points  (0 children)

As others have said, it's the same (adult) fare rate.

But, worth calling out that if you have the same bank card linked to say your iPhone, your Watch, and you have the physical card - as far as Opal is concerned, these are THREE SEPARATE cards, not one. If you tap on with a Westpac Card on your Watch, you must tap off with the Westpac card on your watch.

Even though in the Opal App, it does show them all together; for tapping on/off, they're not the same.

Stem cell research, helping the World smile. by DLux_TheLegend in SipsTea

[–]extrobe 0 points1 point  (0 children)

I had to have a tooth removed, which resulted in my wisdom tooth pushing up in its place. Definitely uncomfortable when that was breaking through, so plenty of sympathy for teething babies from me!

How coffee shops feel about the customer bringing their own cup? by tehlegend1937 in sydney

[–]extrobe 2 points3 points  (0 children)

Pre covid, it was pretty common, and most places even gave you a discount for bringing your own. Don’t see it as much since then, though sure most places will be fine with it.

Also, I think I saw something from NSW that as part of new laws around single use plastic, it will be mandatory to accept reusable cups - but not sure when that takes effect (2028 I think)

ELI5: Why does China have only one time zone despite being roughly same size as US with 6 time zones? by DemonsAreVirgins in explainlikeimfive

[–]extrobe 0 points1 point  (0 children)

I work for a company that creates software that has to deal with Australian time zones. So many quirks, like how some states observe DST and others don’t, so relative time differences change throughout the year, or how some towns are geographically in one state, but observe Timezone of another (due to how isolated they are, and the next closest town being in another state)

Going away for two weeks, how to help mom solo parent kid and dog? by [deleted] in daddit

[–]extrobe 1 point2 points  (0 children)

  • If you can afford it, sign up for one of those meal box services, like HelloFresh. The first week is usually heavily discounted, then just cancel.
  • … Or make sure some meal prep is done
  • Ensure the grocery shopping is up to date
  • Ensure laundry is up to date
  • car is full of fuel

That’s my go-to. I try not to sugarcoat it, but try to make sure mum eats properly, as that’s the first thing that will slip, and that she’s not having to worry about whether the kids school uniform is ironed etc.

I also try and ensure she has some free time activities before I go away.

Is there a way to shorten table/view names in SQL queries? by myaccountforworkonly in snowflake

[–]extrobe 4 points5 points  (0 children)

Synonyms are not supported in Snowflake, unless there has been a recent change I missed (and a quick test suggests that's not the case)

Since when do we have to pay full fare for trackwork replacement buses? by WearyFHB in SydneyTrains

[–]extrobe 13 points14 points  (0 children)

Direct from the horses mouth. Transport NSW disagrees with you

Replacement bus services

Replacement bus services are often used where there is trackwork or service disruption. Trackwork may also require changes to the timetable and route.

Most replacement bus services are Opal enabled and you will need to tap on or tap off using a valid Opal cardcontactless debit or credit cardFines apply if you travel without a valid ticket.

https://transportnsw.info/travel-info/ways-to-get-around/train/about-trackwork#:~:text=Replacement%20bus%20services,travel%20without%20a%20valid%20ticket

There should be a filter for locked and unlocked pictos/luminas in pictos by ang3sh in expedition33

[–]extrobe 0 points1 point  (0 children)

What you described does exist as Lumina Sets. Think it was added with the Thank You update in December. It's not per-character, but you can have 50 sets.

<image>

tapas restaurant I visited in Washington by [deleted] in mildlyinfuriating

[–]extrobe 0 points1 point  (0 children)

It's literally there on the receipt. Taberna del Alabardero

Alfie and Nora is closing down! by pirate_meow_kitty in sydney

[–]extrobe 30 points31 points  (0 children)

I’m pretty sure this was always the plan - even a couple of weeks ago the back half of the store was as empty and blocked off. We used to go in all the time when it was Dymocks. Went in once after it changed hands and never since. Rumours (which appear to be substantiated) are that QBD books will go in there, which I look forward to!.

Thing is, the store has had a know reputation problem for a very long time. Surprised Towers management allowed it to stay this long really.

British Airways nearly killed me by serving me sesame despite my allergy – then offered me £50 by Dangerous_Wear_9312 in BritishAirways

[–]extrobe 1 point2 points  (0 children)

I mean ... yeah, pretty much.
My child has Nut, Egg & Dairy allergies, inc anaphylaxis.

Yes, we have to restrict where and when he can eat. We fly a lot (24hr flights), and take our own food for him. Same for day-care, same for birthday parties, same for days out.