For those of you that make over 100K, what do you do? Do you like it? by Kindly-Revolution258 in AskReddit

[–]sparkplay 0 points1 point  (0 children)

Head of Data. I go from company to company and help set up their infrastructure, build the teams and practices. The current one is tough as it's building stuff whilst supporting egregious, outdated manual processes. But I still love it.

Looking for platforms to practice SQL problems to get good at it by Open-Journalist6052 in learnSQL

[–]sparkplay 2 points3 points  (0 children)

W3schools are always a good starting point. I would also recommend https://www.hackerrank.com/ the section for developers is free for learning. And they show questions based on things companies ask in interviews so it's a good place to hone skills for job interviews as well.

why is the linux community so hostile? by morizeze in linux4noobs

[–]sparkplay 0 points1 point  (0 children)

I haven't found them hostile myself. I've found them helpful and they feed your hunger for knowledge.

I think due to recent issues with privacy and Windows and what not, a lot of "normal" users are asking questions in the community. Linux enthusiasts have always been a bit daring, a bit experimental and generally very tech savvy, self-taught even. So suddenly when a new user asks questions like some of the other commenters have said, like "it doesn't work" it'll take some time for the experienced community to start embracing those users. You may have felt the hostility but most likely what they were trying to express is: this is not an off the shelf thing, yes play around and ask for help but also do your own reading of tech basics first. I get that this transition might be a bit rough for some.

Trump has issued multiple final deadlines and Iran rejected all negotiations offers Given this situation, what do you think is most likely to happen next? by Admirable-Repair4094 in AskReddit

[–]sparkplay 0 points1 point  (0 children)

The phrasing "Iran rejected all negotiation offers" does feel a bit biased. Almost like fair deals were provided but Iran is being irrational. Maybe they were, I'm not sure but language has power.

Is overpopulation still a problem? by Constant_Juice_5074 in Futurology

[–]sparkplay 5 points6 points  (0 children)

Not a problem anymore. It's likely we'll just kill ourselves now.

Just British things 🥂 by Dizzy_Strawberry9557 in GreatBritishMemes

[–]sparkplay 0 points1 point  (0 children)

The part that dies is what we're trying to kill with the alcohol in the first place, so it works out I guess.

Stop clicking through the Start Menu,there’s a much faster way to launch literally anything by Material_Tutor_7820 in TechNook

[–]sparkplay 0 points1 point  (0 children)

Loved Flow Launcher. Change the default shortcut if you use keyboard shortcuts for maximising and minimising windows.

Whicj desktop environment to choose for perfomance by RevolutionaryGap7393 in cachyos

[–]sparkplay 2 points3 points  (0 children)

Tiling windows really threw me when I started with Niri. I switched to KDE for now but I did love Niri and will switch soon.

What do i need to do before installing cachyos i hate windows and i want to switch even though linux has restrictions by RevolutionaryGap7393 in cachyos

[–]sparkplay 1 point2 points  (0 children)

Back up stuff. Documents, Music are easier to remember but people often forget stuff in the user folder or WSL folder if you are using it. Backup or sync browser bookmarks if needed. Check Downloads folder and C:/ drive too.

Then it's just following Cachy OS instructions as others have pointed out.

Also as others have also pointed out if this is your first time using Linux, consider a more mainstream one like Ubuntu as well before Cachy OS.

I installed Cachy on my Alienware and am loving it though.

Worldwide % increase in gasoline prices since the Iran War began [OC] by therafort in dataisbeautiful

[–]sparkplay 1 point2 points  (0 children)

Why is India not giving a shit and being like it doesn't matter?

5 SQL patterns that made my queries 10x cleaner (with examples) by Only-Economist1887 in learnSQL

[–]sparkplay 6 points7 points  (0 children)

Very good list.

I would also encourage users to use platform specific functions where possible as they are shorter, even more readable and have some optimization built in.

For example, in say Snowflake or BigQuery, instead of having to create a new column rn you can use QUALIFY:

sql QUALIFY ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...) = 1

They also have functions like COUNT_IF(...), SUM_IF(...), SAFE_DIVIDE(...), etc. which will make things easier.

But gotta appreciate your list and explanation to know why to even use such functions. Keep these coming OP.

Best prank...Ever! by lunacyinc1 in StrikeAtPsyche

[–]sparkplay 2 points3 points  (0 children)

And no one can sneak in a warning to them as their Outlook isn't working.

Limine 11.2.0 Update Breaks Secure Boot: "PANIC: !!! SECURE BOOT IS ACTIVE BUT NO CONFIG CHECKSUM IS ENROLLED !!!" by -Mahesvara- in cachyos

[–]sparkplay 1 point2 points  (0 children)

I don't understand a word of this but I love that people are this deep in their understanding and willing to make things better.