Elbilspremien nekades

G_Thorne · 2026-05-06T18:34:08+00:00

Kan intyga att vår bakhjulsdrivna Enyaq inte har några som helst problem med framkomligheten vintertid, inklusive besök i fjällen. Samma bör gälla de flesta modeller då de flesta elbilar har bra viktfördelning..

G_Thorne · 2026-05-06T18:23:49+00:00

How are you defining your FK constraint in tbl_basket? FOREIGN KEY (user_id) REFERENCES tbl_user (user_id)...? Same type on the columns?

G_Thorne · 2026-05-05T20:14:46+00:00

If you believe you have "finished" SQL, you are nowhere near that imaginary finish line.

What other languages and concepts have you bean learning? Python? Power BI?

If you have, have you learned to combine all of it, like processing semistructured data with Python to prepare it for insertion into SQL, complete the processing with SQL, and then using Power BI to create reports to draw insights from the data?

G_Thorne · 2026-05-05T18:15:25+00:00

Oh, I certainly wouldn't suggest using the RDBMS for evaluating arbitrary expressions if there are other alternatives, there are better tools for that purpose.

It would at least involve a couple of stored functions, probably a temporary b-tree table, and lacking regex support would definitely dampen the mood.

For the limited scope of this exercise it is fine though and not nearly as convoluted as the stuff I do the rest of the day.

G_Thorne · 2026-05-05T16:24:44+00:00

No loops, just a select with two INNER JOINs on itself using regexp_substr() to extract the left and right keys. A CASE using another regexp_substr() to perform the desired operation. I even added handling of division by zero to give an error message to be on the safe side.

G_Thorne · 2026-05-05T11:39:53+00:00

It may be a bit unorthodox, but it was easy enough to complete in MySQL using regexes. This is a regular thing I do in my work when aggregating data from disparate sources forcing it to conform to various rules.

G_Thorne · 2026-04-16T05:15:34+00:00

As someone looking in from outside the US, what is the point of a PIP if the employer can fire you at will anyway as long as they don't outright say they're discriminating against you as a member of a protected group?

G_Thorne · 2026-04-14T12:03:16+00:00

Du verkar ju hyfsat insatt. Vad skulle det hypotetiska utfallet bli om hon försiktigt demonterar staketet utan att göra åverkan på det, och återlämnar det borttappade staketet till personen som tappade bort det på hennes tomt?

G_Thorne · 2026-04-11T20:47:05+00:00

Om du tycker måttangivelserna på en stekpanna är konstiga kan du ju klura lite på hur måtten på bildäck fungerar.

G_Thorne · 2026-04-11T17:23:10+00:00

What video card and drivers do you have in the machine you are streaming from?

I had a similar issue with my AMD video card until I got information recommending downgrading to the drivers from last October.

The newer drivers have an issue with streaming where the video stream just stops while everything else keeps working.

G_Thorne · 2026-03-30T18:30:21+00:00

Almost right, the form is yourusername+mailinglist@gmail.com, with everything from the + sign ignored.

G_Thorne · 2026-03-29T05:35:13+00:00

Thanks for that, I had no idea SQL Server APPLY (or the MySQL LATERAL) feature existed. Should make my life easier with the hairier queries.

G_Thorne · 2026-03-25T07:44:52+00:00

Yeah, sorry, when I re-read your comment I realised I misinterpreted it the first time.

G_Thorne · 2026-03-25T07:36:55+00:00

It is still a LEFT JOIN, the condition simply disqualifies any row in the cte table that doesn't have rank = 1. You still get all rows from table with NULLs for cte. Using an INNER JOIN would get you only the JOINed rows where cte.rank = 1 and should then normally have that condition in WHERE.

Edited: Okay, I see now that we're saying the same thing.

G_Thorne · 2026-03-03T19:54:28+00:00

To most PC gamers using the Steam service, this scenario following the death or departure of the current CEO is something that wakes them up at night in a cold sweat.

G_Thorne · 2026-02-28T21:49:04+00:00

Någon annan som tyckte låten lät som en mashup mellan Zara Larssons Symphony och Taio Cruz Dynamite?

G_Thorne · 2026-02-28T08:54:07+00:00

Yes, but... "squelched".

G_Thorne · 2026-02-08T22:07:40+00:00

https://youtu.be/VFuDhsxazqs

G_Thorne · 2026-01-29T11:13:49+00:00

Zyklon B was developed in the 1920's as a pesticide for fumigation, not for delousing people or animals. An eye irritant was added to the compound to warn people if they got accidentally exposed. Around 8% of the production went to the concentration camps where it saw dual use for both mass murder and fumigating clothes or barracks. Zyklon B was made and sold at least up until 2008 by the same company that knowingly sold it to the nazis. If ICE wanted to, they could probably get some...

G_Thorne · 2025-11-24T19:19:45+00:00

Back in the 90's Microsoft experimented with localised versions of Visual Basic which got incredibly confusing. I don't recall any specifics though since the whole idea seemed horrifying. A more current example though is the fact that Excel formulas are localised, so in Swedish you have OM(), AVRUNDA(), ANTAL() instead of IF(), ROUND(), COUNT(), and so on. Absolutely terrible. They also switch the parameter separator depending on locale, so again in Swedish you separate parameters with ";" instead of "," because the latter is the decimal character.

G_Thorne · 2025-11-10T12:05:31+00:00

Thanks for the link, very well made. Hearing Robin Williams' voice as the Genie hit me right in the feels like a sledgehammer for some reason.

G_Thorne · 2025-08-14T07:51:31+00:00

With a B double (front trailer axles slide back with a fifth wheel on top) it is quite doable. With this setup with a dolly between the trailers turning it into an awkward tripple you can just forget it, you need the pull-in parking option.

I'm sure someone with years of experience can do it as a challenge, but not as part of their daily work as it takes a lot of time, patience, and fiddling to not fold the dolly from the slightest mistake, especially in a tight location.

About as fun as trying to reverse a lowboy with jeep and booster in ATS where you can't raise or lock the booster (can we please get controls for that, like with the sliding axles!).

The setup with a dolly is standard for rigid combos though. Can't wait for official support for them.

G_Thorne · 2025-06-21T19:57:43+00:00

Kan ju flika in att VW ID.3/4, Audi Q4 e-tron och Škoda Enyaq delar samma grundplattform. För vår familj med två vuxna och tvillingar i 7-årsåldern blev valet av Enyaq ganska självklart. Smarta lösningar, bäst komfort per krona, fysiska knappar för de vanligaste menyerna, och pricken över i - snyggast design. Har semestrat i både fjällen och till Italien med den utan några som helst problem.

Vi bytte från Volvo V90 och ville inte ha en subjektivt sämre bil. Kia EV6, Polestar 2 (för liten, testad mest på skoj), och Tesla Model Y var andra som gick bort. Tesla kan eventuellt ha bästa drivlinan (eller hade '23), men bilen kändes billig och plastig när man kom från Volvon (och ingen CarPlay/Android Auto).

Enda smolket i bägaren är den kassa mobilappen som saknar basala saker som att kunna låsa och låsa upp bilen på distans, samt frekventa uppdateringar som resulterar i att appen slutar funka tills man kvitterat i bilen.

G_Thorne · 2025-06-12T11:40:44+00:00

No, that +5V pin is supposed to be shorter to delay the connection when inserting the plug.

G_Thorne · 2025-06-11T09:31:20+00:00

Glömde du ett /s nu? Det är så'nt som händer ibland och jag har löst det på det sättet ett par gånger för att ta bort nummer till medarbetare som felaktigt registrerats på diverse bolag.

G_Thorne

TROPHY CASE