vrek

joined 2 years ago
[–] vrek@programming.dev 25 points 3 weeks ago (3 children)

I feel like there should be a "if you're happy and you know it" parody here somewhere but I can't find it...

[–] vrek@programming.dev 15 points 3 weeks ago

Sys internals also... So many useful features for free but you have to know to install

[–] vrek@programming.dev 2 points 3 weeks ago

Ah ok. I was more wondering if it related to the bit density on magnetic tape or speed of the stepper motor available for a reasonable price at the time or something like that.

[–] vrek@programming.dev 11 points 3 weeks ago (4 children)

Interesting, is this a coincidence or is there a logic/reason it works out that way?

[–] vrek@programming.dev 19 points 3 weeks ago

They did it with ps3 also although in research to make sure I was no mis-remembering I found out I was wrong. It was 33rd fastest super computer not #1.

https://en.wikipedia.org/wiki/PlayStation_3_cluster

[–] vrek@programming.dev 27 points 3 weeks ago (3 children)

I heard at one point in time the fastest super computer in the world was a cluster of 900 ps3. It was cheaper then buying a single computer and in the beginning of the ps3 era you could easily format and run Linux on them.

[–] vrek@programming.dev 1 points 4 weeks ago

Like I said on the response it's like six on one hand half a dozen on the other just with poor math skills

[–] vrek@programming.dev 1 points 4 weeks ago

Yeah I get that but it's has some meaning. Like it could be the number of some sport star or a reference to some show with a hero team with 67 in the name or could be even darker like with the number 88...

[–] vrek@programming.dev 1 points 4 weeks ago (3 children)

Ah like "six on one hand and half a dozen on the other" but purposely with bad math?

[–] vrek@programming.dev 5 points 4 weeks ago* (last edited 4 weeks ago) (8 children)

I'm getting old, what is 6/7?

[–] vrek@programming.dev 1 points 1 month ago

I actually find the opposite is true. I don't mean it's bad but you get much better results with some basic starting point.

For example at my last company we had a database which for a VERY small example had a table with device serial, test type, test result(pass/fail), and an ID to another table. For each test in the other table there was a series of rows with that id which had all the details of test. For example unit 123 might be circuit board with 5 test points testing voltages at various points, all tested at one test station.

So you would go into table 1, select all lines with serial 123 and test type "electrical test", copy the test ID, go into table 2 and select all results for that ID.

One day my boss sent me a list of 500 serials and told me to pull all the details and present it in a table.

Doing that manually would be hours. So people with some sql knowledge might recognize you could use a sub query. Problem being the list sent to me was just a table copied and sent over teams. Would probably take atleast half an hour to copy that into ssms and correct all the formatting to be valid sql.

I wrote a script that pulled the details for 1 serial using a sub query and pivot the results , copied that and the list of serials into chatgpt and asked it to modify the query to include all the serials in the table in correct sql format. It worked great( I got results for 500 unique serials and a test of a random 10 of them got the same results). It took maybe 5 minutes.

Now trying to get chatgpt to do that from scratch would be painful but with some idea of structure of data, an idea of what I wanted to do and an example to follow it worked wonderfully.

[–] vrek@programming.dev -4 points 1 month ago (6 children)

I'm not really against but I think instead we should just ban anyone over 60 from voting...

view more: ‹ prev next ›