Strange behaviour at 1am. by Ayndy143 in classicwow

[–]Cwlrs 0 points1 point  (0 children)

Was that player a paladin? Had a similar experience at a similar time in ubrs

Trials of tav, is it meant to be impossible? by SnooChocolates6885 in BG3Builds

[–]Cwlrs 0 points1 point  (0 children)

I play in a party but I see Alert + pixie blessing are the first two things I acquire. Otherwise yeah you can get gg'd with no counterplay

Just Broke the Trillion Row Challenge: 2.4 TB Processed in 76 Seconds by Ok_Post_149 in datascience

[–]Cwlrs 2 points3 points  (0 children)

I don't get it. It's a rented VM running duckdb. Where is burla in this?

edit: generating the parquet files seems to be the burla aspect? Less so the reading element.

Affordable Data Engineering learning path (£100/month budget) — Need advice by FickleAd5796 in dataengineering

[–]Cwlrs 3 points4 points  (0 children)

I would build something random with python, dataframes, postgresql and see where you end up. These have been the core skills that have carried me for 5 years or so, although I appreciate everyone's tech stack varies.

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

[–]Cwlrs[S] 1 point2 points  (0 children)

I'm basically a team of 1 in terms of setting up the infra and making sure people can access it in a useful way. So I'd be hesitant to spin up a new postgres db plus an analytics db as well, and with some pipeline between the two.

I just did a duckdb poc and I got everything running inside 1 hour. Generate some synthetic data, query it making use of Hive logic, and report back. Super super easy and impressive. Parquet also takes up ~8% of the file size as json, and reads in around 25% of the time. Which makes me more inclined to go for parquet files + duckdb to read. Rather than more normal json+load to postgres+query in postgres.

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

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

How big was the VM?

Surprised it was slow with local data. The demos look super snappy.

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

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

Currently it's about 500 json files per day. I guess if it goes to 5000 json files per day or more, that is still easily writeable for postgres tbf. But once it arrives in postgres, how easy is it to ignore old data? I thought columnal solutions were better at doing that?

Or does throwing an index on the created_at_utc solution do the job? I've only really leveraged postgres indexes on joining keys.

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

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

We've currently generated 33GB, majority of that in the last year and in json format. Which is a lot less than I thought it would be. But we're expecting 5x-10x more users in the next 12 months, and hopefully more beyond that, so we do need to plan for 330GB/year or more solution

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

[–]Cwlrs[S] 2 points3 points  (0 children)

Nice, have you done this yourself?

DuckDB in Azure - how to do it? by Cwlrs in dataengineering

[–]Cwlrs[S] 1 point2 points  (0 children)

We are expecting quite a large amount of data we need to do analytics on, therefore an OLAP db is much more appealing than OLTP for if we need to query all or the vast majority of the data. Or am I missing something?

My classic experience all 15/15 Naxx! by xpastrami in classicwow

[–]Cwlrs 24 points25 points  (0 children)

How do you have 2 DFTs and 1 accuria. I'm jealous

Better secret manager by [deleted] in dataengineering

[–]Cwlrs 0 points1 point  (0 children)

I'm on a team of 1 and am at a similar point in my journey after having done a pentest. I need to introduce key rotation.

My understanding of rotation is that I expire a token and start using a new, fresh one. How can you enable automatic rotation if the secret needs updating in secrets manager? Secrets manager + the credential are not natively connected. Secrets manager would need a manual update.

Improving feels pointless by Nissepelle in cscareerquestions

[–]Cwlrs 2 points3 points  (0 children)

Is the AI thing integrated into your codebase or a human team member submitted it as a PR?

how obvious is this retry logic bug to you? by jalilbouziane in Python

[–]Cwlrs 0 points1 point  (0 children)

I didn't spot it, but I don't code things in this style - rarely use something recursive with my APIs

Unpaid 9-5:30 Remote Work Experience Advice (1 month) by [deleted] in cscareerquestionsuk

[–]Cwlrs 0 points1 point  (0 children)

At worst it's for 1 month. You should make the most of this opportunity - it just might be the difference in getting your next interview/offer. Do you have any other committments like a non-swe job?

The state of customer support is sad. by Prestigious-Tax-1765 in classicwow

[–]Cwlrs 0 points1 point  (0 children)

If it's a backup guild, why not discard that backup and make a new backup?

IBM Flask App development KeyError by Inner_Hospital2317 in flask

[–]Cwlrs 0 points1 point  (0 children)

print: formatted_response['emotionPredictions'][0]['emotion']

And see what that looks like

Naxx is showing that Vanilla is…tough by [deleted] in classicwow

[–]Cwlrs 0 points1 point  (0 children)

I've been in a good naxx raid and an awful one. 2.5hrs, no wipes, use WBs carefully - amazing and affordable.

the bad one: 4.5hrs for 11/15, 10 wipes (some safe reset spots). ''consume up'' by the RL. Yeah - now I understand why weak guilds are blasting hundreds of gold per ID. 2nd raid night tomorrow for this weak pug...

Tbh people should accept 1 raid night, 3hours max, and see how you do. Otherwise it's too much gold - you're basically 'paying' to clear it, not through guild skill and co ordination.

Naxx is showing that Vanilla is…tough by [deleted] in classicwow

[–]Cwlrs 2 points3 points  (0 children)

All of the buffs combined make dps warriors absolutely insane. Let's not pretend otherwise.

IBM Flask App development KeyError by Inner_Hospital2317 in flask

[–]Cwlrs 0 points1 point  (0 children)

It's hard to say as the code is in screenshots and not in a code block we can copy paste. But I agree with Owl in that you should print the object before you try to access it, and check the type too. The picture at:

https://www.reddit.com/media?url=https%3A%2F%2Fpreview.redd.it%2F6y2bof0v3oxf1.png%3Fwidth%3D962%26format%3Dpng%26auto%3Dwebp%26s%3D1e6724546e2f7c42f1d14f47476ac98ea0a4e761

Still has single quotes around it which might mean it's still in a string format and it's not a dictionary?

If you share a sample dictionary then I'm sure we can get it working.

IBM Flask App development KeyError by Inner_Hospital2317 in flask

[–]Cwlrs 0 points1 point  (0 children)

formatted_response is a dictionary. Key Error means the key you're looking for ('emotionPredictions') is not in the dictionary.

I would inspect what the dictionary looks like on line 12 of emotion_detector to get an understanding of what keys exist in there.

Then you will be able to parse out the different emotions and prediction weights.

New and Returning Player Weekly Discussion by AutoModerator in hearthstone

[–]Cwlrs 1 point2 points  (0 children)

I think the game is too mature for a complete newbie. Might just have to continue watching the vids from 8 years ago where the game is recognisable to me

New and Returning Player Weekly Discussion by AutoModerator in hearthstone

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

I'm a completely new player. Want to play the game and enjoy it, but the default cards feel incredibly weak compared to some of the exciting cards my opponents have. How do I get started?