HackerTrans
TopNewTrendsCommentsPastAskShowJobs

pettijohn

6 karmajoined bulan lalu

comments

pettijohn
·kemarin·discuss
I always define a primary key, integer or otherwise, and prefer the be explicit and consistent.
pettijohn
·kemarin dulu·discuss
CREATE TABLE ... STRICT WITHOUT ROWID is my default, I don't know why I'd ever do otherwise.
pettijohn
·7 hari yang lalu·discuss
I think I got lucky -- look for "revival" series on their web site. I happened to see it one time and pulled the trigger.
pettijohn
·7 hari yang lalu·discuss
$4k is pretty darn spendy. I recently purchased a refurbished Corsair AI Workstation with almost the same hardware (same chip, same 128GB RAM, but only 1TB storage) for $2160. Pretty good deal! Codex and I wrote a Linux driver to report the power mode of the device:

https://github.com/pettijohn/corsair-ai-workstation-performa...
pettijohn
·bulan lalu·discuss
A Linux kernel module and userspace app to read the performance level of my Corsair AI Workstation PC (Strix Halo). Corsair only ships a Windows on screen display app and I was flying blind. AI helped me look over the Windows installer, decompile ACPI tables, and identify the WMI events. Built it all in Rust. When done I asked a different AI model to perform a security assessment and help me harden it. Way out of my wheelhouse, yet an afternoon project with AI.

https://github.com/pettijohn/corsair-ai-workstation-performa...