Spyke

Replies

Comment on

ChatGPT Changed How I Write Software

One thing I used ChatGPT for recently was generating test data.

Hey ChatGPT, I use SQL Server and here is my table structure, please generate an insert query with 10 rows of fake test data.

It wasn't perfect, but honestly nor is the test data I would have written. It was a great starting point and saved me a lot of time since this is a legacy app with some wide tables (30+ columns).

lemmy

Comment on

*Permanently Deleted*

so if the operator of rambo goes “man fuck this” and shuts it down, the posts/comments are gone? there’s no way to replicate them or sync them or whatever?

My understanding is that if a user on a different instance is subscribed, then that second instance will keep copies of previous post / comments.

But there also appears to be a download limit, so over time the non-original instances will lose those copies.

It's a strange new world over here!

sql

Comment on

Guess the intent

Reply in thread

The client table has around 100,000 rows each with a unique clientId, none of which are returned from the CAST / ABS / SIN

I think you are right and this is a 'fix' for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for

Comment on

Redditors, how do you like Lemmy?

So far really good! It has some quirks, and there are some bugs and some teething issue with the large influx of people (specifically on lemmy.ml)

It is a mind-set change working with a different system and the whole instance idea is still very new for me

As an Australia, it was very quiet last night (10ish hours ago), but that will improve as more people join

sql

Comment on

Guess the intent

Reply in thread

I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId is also 0

It certainly doesn't for any of the 100,000 existing rows

sql

Comment on

Guess the intent

Update: The original dev does not remember exactly. However they have said that clientId was originally a VARCHAR, so this may have been checking for both '0' or ''

So an over-engineered workaround to a bad datatype perhaps?

linux

Comment on

I somehow broke my ssh keys

Let me make sure I understand first

  1. You are attempting to passwordlessly SSH from Window to a group of servers using Powershell
  2. Something stopped working and you regenerated your Windows SSH keys

i added my private key, and tried to connect

This concerns me, as the server should have the user's public key, not private. Private should be exactly that, private

Is the Powershell user / SSH key the same as the Putty user / SSH key that still works?

When you run the Powershell script, does it give any error messages?

I know with Linux -> Linux SSH you can log verbosely with -v, is that something you can do under Powershell?

Is password auth enabled? Does that still work from Putty, and can you do the same from Powershell?