Using a Self-Signed SSL Certificate

You’ve been hacking on your project and you’re about to move it into a client’s environment. You ask them for a valid SSL cert and they say “use self-signed for now”. Okay, alright, I can do that, but now I have to convince my application that’s it’s okay to blow off the lack of authority for this certificate. Until then it’s NET::ERR_CERT_INVALID in the console log every time the API gets accessed.

Setting Up Gitconfig on Windows

Whenever I have to work on a remote system (usually Windows) I’ll do my typical git clone <repo here> routine but then I’m immediately missing my local aliases for doing things. My git co -am "message" falls over and wants git commit instead. My git lga with all the colorful abbreviated output for my logs doesn’t work because none of that formating is here. Normally I’d just fire up vim ~/.

Netlify

I hadn’t updated my blog in a while because it was a terribly painful process and if I made even the slightest mistake I would have to go through the entire thing again and then wait for it to build. Then it would sometimes build and sometimes not build. Very very frustrating. Enter: Netlify I’m using hugo and netlify - it’s p easy when you get it set up — dynamically linked lesbian (@endocrimes) July 4, 2019 I thought I’d give it a try and wow I was really impressed.

Just One Row

There are so many a-ha moments when you’re writing code and I really wish I had started writing them down at some point because I feel like I could write a book by now. Last night I was copying some code from a previously-written function that feeds JSON data to a website via an API endpoint. For some reason no matter how much data I sent, a single row would show up on the page and nothing else.

ISNULL

This tip comes from my friend Laura the uber DBA. If you’re testing a value for being NULL or being an empty string, do both at the same time with this handy dandy magic: WHERE ISNULL(fieldname, '') != ''