Rose here. Also @umbraroze for non-kbin stuff.

  • 0 Posts
  • 8 Comments
Joined 1 year ago
cake
Cake day: June 14th, 2023

help-circle




  • Technically, SQL is case-insensitive.

    Practically, you want to capitalise the commands anyway.

    It gives your code some gravitas. Always remember that when you’re writing SQL statements you’re speaking Ancient Words of Power.

    Does that JavaScript framework that got invented 2 weeks ago by some snot-nosed kid need Words of Power? No. Does the database that has been chugging on for decades upon decades need Words of Power? Yes. Words of Power and all the due respect.


  • Scrivener is still the absolute best word processor for ginormous writing projects. There are FOSS projects that do some parts of it right, but fall far behind in the others. It’s particularly frustrating because my usual FOSS approach would be to use other tools that make up for the inadequacies, but Scrivener pretty much nails the “what to include and what to leave out” equation. It’s a great combo of a word processor, project management tool and a research/notes tool, all rolled into one.



  • I have a Zyxel NAS server that just offers a SMB share. I’m just dumping my photos there under YYYY/MM/DD scheme, and converting all of my Nikon NEF files to DNG. (For importing photos to the NAS and generating backups, I have a PowerShell script and a PowerAutomate action. Also mild usage of Dropbox to transfer files from my cellphone.)

    For actual management of photos, I use ACDSee Photo Studio Professional, and it just writes all tag information to the files themselves, so I can basically use any other software for photo management. For actual photo editing, I use DXO PhotoLab and Affinity Photo most of the time.