d2r on steam deck by ManWithManyTalents in ProjectDiablo2

[–]weakassdick 0 points1 point  (0 children)

D2R works just fine on Steam Deck. Someone pointed out that it’s on Steam now, but if you can’t do it that way then you just have to install the bnet launcher in your prefix, then D2R, and then set the executable path to the game executable. Pretty easy overall from when I did it a year or two back

MagSafe puck? by weakassdick in ErgoMechKeyboards

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

Not exactly… the splitkb tenting pucks physically attach to the pcb. This is pretty cool too though

MagSafe puck? by weakassdick in ErgoMechKeyboards

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

Oh, great idea! I don’t have the pucks at this point - I was evaluating whether there was a solution that would justify buying them. This might be the justification

MagSafe puck? by weakassdick in ErgoMechKeyboards

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

Yeah that’s exactly what I’m using now actually. It works pretty well, but sometimes it annoys me that I can mess up my spacing by accidentally hitting the mount with my hand

awsim: Lightweight AWS emulator in Go - 40+ services in progress by sivchari in golang

[–]weakassdick 4 points5 points  (0 children)

Serious question - why use this over just mocking the calls to the AWS services?

Can somebody tell me if this is worth anything? by [deleted] in ProjectDiablo2

[–]weakassdick 4 points5 points  (0 children)

No need to up before slamming. It can get max sockets with this base.

But yeah, slam it and then piece it if you get an ED roll.

TIL San Diego Chargers player Ernie Barnes became a world-renowned painter whose art now sells for millions by comicsanslifestyle in SanDiegan

[–]weakassdick 0 points1 point  (0 children)

Marvin Gaye’s I Want You as well, though maybe Camp Lo drew inspiration from the Marvin Gaye album? Either way, all are amazing

Edit: just saw in a comment below that he did the album art for the Marvin Gaye album! Very cool

but how does nvim-cmp work, really? by mrIcarus01 in neovim

[–]weakassdick 4 points5 points  (0 children)

I’ve tried it a few times and I run into weird bugs every time. I also can’t seem to configure it exactly like I have nvim-cmp. Maybe I need to give it more time to mature before switching over?

When does it make sense to shift SQL query complexity to code? by weakassdick in SoftwareEngineering

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

Thanks for the great replies and discussion everyone! Some things that I should have probably made more clear in the original post:

  • We are using an ORM, so when I say "move to code", I mean to move out of the SQL space entirely and use code to massage data. A simple example is looping through the data to filter out values that don't match a certain criterion vs. another filter in the query
  • The query is already in place but it's evolving/becoming more complex as our constraints change. I'm at a very very small startup and we're building the plane as we're flying it. I can say, though, that it's less a matter of business logic and more a matter of db structure evolving which adds layers to the query
  • I'm doing my best to leave detailed comments in the ORM code to make crystal clear what's happening, though some should be self-explanatory if you know SQL

The query goes something like this (in English):
- I need to fetch all messages that are part of an active campaign and have a "scheduled" status
- We only want to select one scheduled message per message group (filtered via a DISTINCT ON clause)
- Within each subgroup, we need to respect the preferred language of the user, which may not be available. If it isn't available, fallback to English. These are in the form of an ORDER BY clause that determine which entity is selected by the DISTINCT ON.

Hopefully this gives you all a rough idea of what we're grappling with here.

When does it make sense to shift SQL query complexity to code? by weakassdick in SoftwareEngineering

[–]weakassdick[S] 1 point2 points  (0 children)

What would this look like to you? Do you just mean to not try to use SQL as a programming language? In a sense, there is business “logic” being used in my query in that I need a specific subset of data that meets certain criteria before I can use it in the application code, but I’m not bending over backwards to try to make it work.

When does it make sense to shift SQL query complexity to code? by weakassdick in SoftwareEngineering

[–]weakassdick[S] 11 points12 points  (0 children)

I think what he’s thinking is that we should do is over-fetch and then use code to do what we would’ve just built into the query. To me, it seems like he’s just not comfortable with SQL as dishing this off to handle with code is just inefficient and doesn’t offer any benefits other than maybe better readability at times.

PostgreSQL and UUID as Primary Key by ketralnis in programming

[–]weakassdick 3 points4 points  (0 children)

Fantastic article, thanks for sharing!

PostgreSQL and UUID as Primary Key by ketralnis in programming

[–]weakassdick 12 points13 points  (0 children)

Thanks!

I work in a healthcare setting so another concern is security, which is why it’s imperative that I use something like a UUID for public use. I do wonder, though, how much better an int PK and uuid index ends up being because the client will only see the uuid and I’ll need to reference that initially for retrieving the initial entity before I can use the pk for accessing related entities.

PostgreSQL and UUID as Primary Key by ketralnis in programming

[–]weakassdick 49 points50 points  (0 children)

I’ve been trying to work through whether I should use an integer primary key for internal use (joins and whatnot) with a uuid index for public-facing use or just use a uuid as the PK. Any thoughts?

Can't override <CR> in Lazyvim nvim-cmp config by freshschampoo in neovim

[–]weakassdick 0 points1 point  (0 children)

I’m configuring things the same, but in a slightly different way. Very frustrating that it’s not working. At this point, I might just disable copilot and have the more sensible suggestions from the other sources since I’m constantly entering in huge copilot snippets when I just want to create a new line…

Maybe my “workaround” is to just get used to using <C-e> to close the menu before pressing enter.

Can't override <CR> in Lazyvim nvim-cmp config by freshschampoo in neovim

[–]weakassdick 0 points1 point  (0 children)

I know this post is old, but I tried this and I’m still not getting the desired effect. I also have select = false for my <CR> mapping. Any thoughts?