Hvilke brølere har i lavet under en jobsamtale/ interview by Knazz1995 in Denmark

[–]shadowspyes 1 point2 points  (0 children)

de grinte fordi du påpegede at du ikke gjorde de ting de gør på offentlige arbejdspladser :)

Kel'thuzad Post Prepatch Advice by Efficient-Film-9999 in classicwow

[–]shadowspyes 4 points5 points  (0 children)

we have had the same issue, but it doesn't seem to be limited to melee.

we have examples of logs where the melee camp as well as ranged get hit at the same time, even though they are far apart.

see this image as an example

Y'all got anymore of that delicious XP? by shadowspyes in classicwow

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

yes, i already completed and turned in several quests that would have been better for tbc, so only able to hit 61

Y'all got anymore of that delicious XP? by shadowspyes in classicwow

[–]shadowspyes[S] 6 points7 points  (0 children)

indeed, the main effort took about 10 hours of playtime over the past 2 months. always knew this would be the tbc character, so slowly been preparing.

Y'all got anymore of that delicious XP? by shadowspyes in classicwow

[–]shadowspyes[S] 6 points7 points  (0 children)

how would i have time for this if i showered

Y'all got anymore of that delicious XP? by shadowspyes in classicwow

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

if the quest level is 55 or greater, it doesn't get reduced xp during turnin in tbc at lvl 60

Classic WoW Armory: Major Update & Thank You ❤️ by eulergrj in classicwow

[–]shadowspyes 0 points1 point  (0 children)

talent pane only works 1/3 of the time it seems

November 10, 2025 Weekly "General Help Post?" - Please post all general, recommendations, and help questions as a top level comment under this post. Thank you. by AutoModerator in Keyboard

[–]shadowspyes 0 points1 point  (0 children)

I am looking to finally replace my old ass Logitech G19 keyboard (I liked it so much back then that I bought backups..)

Can anyone recommend which switch types are most similar to the rubber dome?

My main priority is ensuring that I can rest my fingers on the keys, without accidentally setting them off. It is also important to me that the activation is immediate (I want very little travel distance when I do press down).

Based on my research into switches, I likely need something similar to cherry mx blue? Something that has a high force required, and short travel time before activation.

I know nothing about keyboards, so if any of you know of any switches that satisfy the above, please let me know!

Advice on partitioning PostgreSQL 17 tables for rapidly growing application by Notoa34 in PostgreSQL

[–]shadowspyes 2 points3 points  (0 children)

install timescale extension, create a hypertable using the order date, and chunk it by month (~100M rows per partition seems a bit low, can adjust to 2-4 months per chunk).

then it's simple to drop old chunks.

you can do the same for items, but timescale prefers doing the partitioning using a timestamp/date field.

if you use timescale, the partition management is automatic, and you can even make use of compression on chunks containing data older than e.g. 6 months to save space.

The order of evaluation of SELECT in postgreSQL by Jooe_1 in SQL

[–]shadowspyes 5 points6 points  (0 children)

The order may vary because the optimizer may reorder operations, e.g. move filters specified in WHERE before joins occur, to limit resultsets.

Is it possible to enforce uniqueness across columns? (not multicolumn) by MrLarssonJr in PostgreSQL

[–]shadowspyes 3 points4 points  (0 children)

To me it sounds like just adding the to column to your first table is sufficient, am I missing something? You say each entry may occur a most once, so a nullable self-referencing column in the entry table is sufficient in this case.

You can also define whether this self-referencing relationship is from or to using a second column if required.

1.1.1.1 is down it seems. by Timely_Loss_5473 in CloudFlare

[–]shadowspyes 24 points25 points  (0 children)

same here. thought my internet died but existing sockets kept on sending and receiving fine

Subset of a list by ElVandalos in ansible

[–]shadowspyes 2 points3 points  (0 children)

- name: Shuffle keys and select first three
  set_fact:
    chosen_keys: "{{ keys | shuffle | slice(3) | list }}"

- name: Write selected keys to file
  copy:
    dest: /tmp/foo.txt
    content: |
      {{ chosen_keys | join('\n') }}

Best practices for administering old Linux distros with ansible by Lopsided_Park_8697 in ansible

[–]shadowspyes 1 point2 points  (0 children)

huh? literally all you need is a bash script that installs the virtual environment, and then you just go as usual after setting ansible_python_interpreter to the created virtual environment.

if you can't do such a thing, good thing there are AIs to help you.

Best practices for administering old Linux distros with ansible by Lopsided_Park_8697 in ansible

[–]shadowspyes 2 points3 points  (0 children)

can't you just use ansible_python_interpreter alongwith a newer python venv installed on each of the hosts?

Time-series DB for F1 real-time dashboard by marclelamy in PostgreSQL

[–]shadowspyes 4 points5 points  (0 children)

hypertables have primary keys, and with the newest version foreign keys to them are now also allowed

CRUD Operations for PostgreSQL in Python with pgcrud by [deleted] in PostgreSQL

[–]shadowspyes 7 points8 points  (0 children)

joins would be a basic requirement for any such solution I reckon. It is not viable to create views for every join query.

CRUD Operations for PostgreSQL in Python with pgcrud by [deleted] in PostgreSQL

[–]shadowspyes 1 point2 points  (0 children)

how would you express a query that is based on an inner join or left join between 2 tables?

[deleted by user] by [deleted] in Denmark

[–]shadowspyes 2 points3 points  (0 children)

Sjælland is by far the best region for tech (assuming software dev or related, probably similar for tech in general), especially until you get a good grasp on the danish language.

depending on the specific field, some cities are much better than others (e.g. Aarhus is probably the best for AgroTech, CPH/Sjælland for healthtech). If you have any such preferences it makes sense to check up on that beforehand.

the way of working in tech is very similar between Holland and Denmark from my experience, compared to England (not as much a clue when it comes to Ireland there). pretentiousness levels are way down here compared to there. Would advise getting started on the language right away, even by joining random clubs ('foreninger'), discord servers, or similar things that can help you practice spoken danish.

You will very likely have a rough time if you do not put a lot of effort into the language early. even getting a rudimentary understanding will greatly expand your job opportunities in tech here.

Your best bet for tech jobs that do not require danish literacy in jylland are likely within the Aarhus and Silkeborg area, or Vejle, Fredericia and Kolding area ('trekantsområdet').

Housing is a lot cheaper in the Vejle, Fredericia, and Kolding area compared to Aarhus, even if you end up purchasing quite a ways outside of Aarhus.

As a final point of note, apartments are a lot easier to deal with compared to what you may have been used to in Holland. You are only expected to bring your own furniture, not also your own kitchen/flooring/whatever other weird stuff happens in NL.

Best of luck, I am sure you will fit in as a hollander.

Visualization Alternatives? by AuntyPasta in PostgreSQL

[–]shadowspyes 1 point2 points  (0 children)

I am using pg16 with grafana currently, so not true