1. Several months back, AWS re-worked the web console. You can get sparkline-style graphs for CPU usage, memory, storage, and database connections at the top level, instead of having to drill down to the Cloudwatch metrics for the instance.
I find this really handy – but for one quirk with the graphs:
There’s white space to the right of the red line. Therefore, I was interpreting the red line to mean “trouble is brewing & I should do something about this”.
Turns out that red line is the limit; there’s nowhere else to go. Whoops!
2. This week I finally had a reason to try out pgloader: One of my analysts needed some help loading some ugly fixed-width data1.
Installing was super-easy on my mac (`brew install pgloader`). I worked through the examples before starting to work with my actual dataset2.
The data to be loaded came bundled as several text files: the data, plus three or four additional files describing the layout. I wrote a truly glorious string of cut, sed, paste, and awk to create a pgloader control file that would work. And it did!
field1 | field2 | field3 --------+--------+---------- [null] | D | IMITRI [null] | G | ABRIELLE [null] | M | ARK [null] | S | ELENA
The data descriptions had character counts starting at 1, and pgloader expects them to start at 0 (as they should). (For extra fun, the first column in all records of this dataset was nothing but spaces.)
3. This week’s hilarious recruiter spam:
“Hey there Gabrielle! I was doing my homework on sites like Meetup, GitHub, etc. and I noticed your Java skills.”
I’m pretty sure you didn’t.
1 – Is that redundant?
2 – 600 columns of fixed-width data? Who does that?!
3 – Why couldn’t it all be in one file? Again: who does this?!4
4 – People who hate DBAs, that’s who.