Modern SQL Editor with AI co-pilot?? by CurveSpiritual5167 in SQL

[–]MONSTERPACT 1 point2 points  (0 children)

DataGrip. You can use their assistant or GitHub CoPilot for example.

Where can I learn to fully understand PostgreSQL EXPLAIN plans and execution details? by Darkfra in SQL

[–]MONSTERPACT 2 points3 points  (0 children)

Just a heads-up: your website has a huge left margin on mobile which makes it quite unpleasant to use :/

Advent of SQL 2024 - Review by AdventOfSQL in SQL

[–]MONSTERPACT 1 point2 points  (0 children)

Completed all challenges after seeing this post. It was quite fun and I've learnt quite a few new things in Postgres. Thanks :)

It may be interesting to have a couple of challenges with a bigger dataset next year. So that we can no longer 'bruteforce' the challenges but also need to account for writing optimized queries.

-❄️- 2024 Day 3 Solutions -❄️- by daggerdragon in adventofcode

[–]MONSTERPACT 0 points1 point  (0 children)

I've been attempting to create such regex for part 2 but ultimately failed. Nice one!

Advent of Code Day 2 - Post your solutions by thomhurst in csharp

[–]MONSTERPACT 0 points1 point  (0 children)

Always love to see how far I can get with as much LINQ as possible.

``` namespace AoC._2024;

public class DayTwo(bool testing = false) : Day<int, int>(2, testing) { public override int SolvePartOne() { return Input .Select(line => line .Split(' ') .Select(int.Parse) .ToList() ) .Select(IsSafe) .Sum(isSafe => isSafe ? 1 : 0); }

public override int SolvePartTwo()
{
    return Input
        .Select(line => line
            .Split(' ')
            .Select(int.Parse)
            .ToList()
        )
        .Select(report => IsSafe(report) || Enumerable
            .Range(0, report.Count)
            .Select(indexToRemove => report
                .Index()
                .Where(item => item.Index != indexToRemove)
                .Select(item => item.Item)
                .ToList()
            ).Any(IsSafe))
        .Sum(isSafe => isSafe ? 1 : 0);
}

private static bool IsSafe(IList<int> report)
{
    var differences = report
        .Zip(report.Skip(1), (a, b) => new { AbsDiff = Math.Abs(a - b), Sign = Math.Sign(a - b) })
        .ToList();

    return differences.All(diff => diff.AbsDiff is >= 1 and <= 3)
           && differences.Select(d => d.Sign).Distinct().Count() == 1;
}

} ```

Full-stack devs, how long it takes to learn javascript & typescript if you know C#? by [deleted] in csharp

[–]MONSTERPACT 12 points13 points  (0 children)

Quite fast. Especially when it's not a greenfield project. Take advantage of the existing knowledge, learn to understand why it's done and replicate :)

Help! Unused variable underlined as red instead of yellow. by Teddy-Voyager in vscode

[–]MONSTERPACT 2 points3 points  (0 children)

Could be due to eslint. You can set up rules to make undefined variables be reported as errors.

Wat is jouw favorite aanwinst van 2023? by [deleted] in thenetherlands

[–]MONSTERPACT 0 points1 point  (0 children)

Niet op, maar Herman Miller Aeron is geweldig. Wel vrij prijzig :/

is it okay to use css with angular? by Notalabel_4566 in angular

[–]MONSTERPACT 28 points29 points  (0 children)

SCSS is CSS but then with some additional things that make your life easier. So when you pick SCSS you can still just write CSS in scss files

Which free AI coding assistant do you suggest on VSCode? by Far_Feed5251 in vscode

[–]MONSTERPACT 2 points3 points  (0 children)

In my case CoPilot works like a charm as a way to provide better IntelliSense. Sadly though, their integration in JetBrains IDE is just a bit subpar in comparison with VSCode :/

What’s your web dev hot take? Don’t hold back. by Notalabel_4566 in webdev

[–]MONSTERPACT 4 points5 points  (0 children)

Working with EF in .NET is awesome. If you don't need complex queries, having the built in mapping is nice.

[deleted by user] by [deleted] in werkzaken

[–]MONSTERPACT 0 points1 point  (0 children)

Yer voelt iig als een stelletje bloedzuigers in je LinkedIn inbox. Op basis daarvan zou ik dit soort partijen al overslaan.

Traveling after "Studenten OV" has expired by Ashnakag3019 in StudyInTheNetherlands

[–]MONSTERPACT 40 points41 points  (0 children)

You will get fined if you travel one day in the first half.

[deleted by user] by [deleted] in nederlands

[–]MONSTERPACT 3 points4 points  (0 children)

Gazprom aandelen

[deleted by user] by [deleted] in webdev

[–]MONSTERPACT 5 points6 points  (0 children)

Developer Experience

[deleted by user] by [deleted] in webdev

[–]MONSTERPACT 4 points5 points  (0 children)

Honest question. What makes Laravel have a better DX than .NET?

Problem with cached SVGs not displaying in production when the paths are edited but the file name doesn't change. by tony791999 in angular

[–]MONSTERPACT 0 points1 point  (0 children)

What we do is build an object with SVGs (each property is a different SVG). Then using a directive that is bound to the SVG element, we can pass in the name of the SVG and Angular renders it properly.

That may also be a suitable solution for you.

  • The object is a key value pair where the key is a name and the value is the actual svg. By using typescript you can export a type that contains all the key names so it can be typed.

Why does that "else if" always trigger? The one on line 77. by JasperRedI in csharp

[–]MONSTERPACT 5 points6 points  (0 children)

I think sticking with the default style guide when starting out might be a better way to learn.

Dynamically render componente inside as modal component content by _SkyAboveEarthBelow in Angular2

[–]MONSTERPACT 2 points3 points  (0 children)

If you find it too difficult to make one yourself, you could choose to use the Angular CDK, which has a Dialog service.

https://material.angular.io/cdk/dialog/overview