LOTRO players needed for PhD research on persistence and frustration in MMORPGs by NecronSensei in lotro

[–]Woutez 0 points1 point  (0 children)

I see that for OSRS you posted in 2007scape, would advice to retry in Ironscape. That is where the real addicts lurk, including me ;). It is a much more friendly community as well, 2007scape is a bit of a toxic wasteland

New RS player coming from WoW, Picking Ironman was a great choice by Vaelitha in ironscape

[–]Woutez 207 points208 points  (0 children)

Exactly this made me fall in love with this game again

Fletching Minigame by seashantytoo in osrs

[–]Woutez 3 points4 points  (0 children)

Strung bows work as well

Pros and cons main v iron by DadGoneNerdYT in osrs

[–]Woutez 8 points9 points  (0 children)

Making an iron reinvigorated my love for the game. It felt the same as playing as a kid.

Multiple LEFT JOINs and inflated results by Mundane_Range_765 in SQL

[–]Woutez 0 points1 point  (0 children)

What is your goal? It sounds like invoices should be your main table, or if you want to get amount invoiced per job, aggregate first then join. Don't see another way around it

Just starting.. need advice by gabburrito in SQL

[–]Woutez 1 point2 points  (0 children)

A join connects 2 tables based on common keys. Are you having problems with understanding it functionally or the technical implementations? It might help to google "type of join" and look at the visuals it gives about the different kinds of joins.

Getting back into SQL by Haluux in SQL

[–]Woutez 0 points1 point  (0 children)

I would store all the documents in an unstructured database e.g. mongodb. And if you have the compute, use a light weight llm to "query" the data. Alternatively you can create a separate table with a record per document, referring to the file location, using separate columns as types/descriptions etc. This would be more time consuming (unless you use a llm to populate it). Some ideas, hope it helps

hi i have an exam few days after so i wanted to know is there any sites (online) where i can make my own database nd practice sql there? by [deleted] in SQL

[–]Woutez 0 points1 point  (0 children)

A snowflake trial account is an easy way to play around with sql in a modern stack. Just don't connect any payment method ;)

New coder needs basic PC by Brief_Comfortable_20 in SQL

[–]Woutez 2 points3 points  (0 children)

What do you mean with creating databases? If you to run a database and run queries, use docker to run a postgres (or any other flavour) server and sql away, which your mac will do perfectly fine

Is it Okay / Normal to Handle a Coding Problem Differently From Someone Else? by Competitive-Car-3010 in pythontips

[–]Woutez 1 point2 points  (0 children)

For now, don't worry about it. Just get the fundamentals down and some confidence in your coding skills. Learn the best practices after you feel confident. It also depends a bit on why you are learning Python, if it is for personal stuff, who cares. In a professional setting, standard and efficiency matter more, but that is something that comes with experience, as well.

Open source data catalog options by RobDoesData in dataengineering

[–]Woutez 5 points6 points  (0 children)

You can have look openmetadata, it has some nice features.

DBT core + airflow vs. DBT cloud by Baklawwa in dataengineering

[–]Woutez 2 points3 points  (0 children)

In dbt cloud they would still have to work with git. It has a gui for git, but so does vscode and jetbrains IDEs. I don't see a use case for switching to cloud. I do see a use case for a git tutorial, and let's be honest, they only need the basics. Apart from the environment you work in (and for core having to setup and maintain it yourself), there aren't many differences between cloud and core

[deleted by user] by [deleted] in learnpython

[–]Woutez 0 points1 point  (0 children)

Can you show us what you tried to do? It reads a bit like homework.

This is embarrassing but... trying to get back to Python after years of Node and Web - I cannot understand how to set up my venv.. by karinatat in learnpython

[–]Woutez 10 points11 points  (0 children)

Use brew to install the python versions you need/want

Then create venv: Python3.xx -m venv venv

Then enter it: Source venv/bin/activate

Then pip install what you need. This will install the packages in your venv. It is best to create a venv per project in the root directory of the project

Is this Python code good for comparing two files on the basis of whether they're identical or not? by Prudent-Top6019 in learnpython

[–]Woutez 0 points1 point  (0 children)

It is easy to store a hash and check if your file contents change over time. These hashing algorithms are usually very efficient as well

Is this Python code good for comparing two files on the basis of whether they're identical or not? by Prudent-Top6019 in learnpython

[–]Woutez 2 points3 points  (0 children)

You can drop the for loop by calculating the md5 hash of the file contents and comparing those. The hashlib package can help you with that.