If you take data that has date and time and goes back several years and plot it on a chart, the current year is likely to lag behind in numbers, because unlike other years, it won’t have data for all 12 months. This is where the so-called Year-on-Year or YoY reports come in handy. To… Continue reading Year on Year (YoY) charts in Google Looker Studio
Forwarding MySQL from local port to remote server
If you have access to a MySQL server which allows whitelisting only a few IP addresses and you need to allow a whole range, you can use a tiny separate "proxy" VPS that would receive the connections and forward them to your MySQL server. You will then only have to whitelist the "proxy" VPS IP… Continue reading Forwarding MySQL from local port to remote server
Cheapest MySQL database hosting for a hobby project?
If you search for cheapest mysql database, you will get results on Reddit, where the most common advice is to get a Digital Ocean VPS for $5/mo. Cheapest mySQL hosting? Which is the cheapest MySQL hosting in cloud? Cheap database hosting for hobbyist? While $5/mo. is kind of cheap, it’s not the cheapest. Here are… Continue reading Cheapest MySQL database hosting for a hobby project?
Forcing mysqldump to _really_ skip comments
I wanted to do a diff on two database structures, and one answer suggested running mysqldump on both databases and then doing diff on the resulting scripts. The problem is that comments will clutter the output and get in the way, and even explicit –compact, –skip-comments, –skip-set-charset etc. won’t help. You will still be getting… Continue reading Forcing mysqldump to _really_ skip comments
nvm, npm, node: Command not found
The problem I had gatsbyjs, node and npm installed on a Debian system. Now I’m getting this error: -bash: gatsby: command not found -bash: node: command not found -bash: npm: command not found Troubleshooting Check npm installation using the package manager: apt-cache policy npm npm: Installed: (none) Check nvm installation: nvm –version 0.39.3 This means… Continue reading nvm, npm, node: Command not found
Asking ChatGPT how does prompt politeness affect response quality
I am curious whether using words like "please" in ChatGPT prompts affects the response quality. I can see how this can be the case, although I do realise it’s a program and it doesn’t have any feelings (yet). Sadly, mosof the things you find on the net when you search for it, are the jokes… Continue reading Asking ChatGPT how does prompt politeness affect response quality
Persistent ZPL commands that set default values for subsequent fields
Here are the most common or widely used ZPL commands that have a lasting effect on the fields or actions that follow them; they continue to affect subsequent fields or actions until they are explicitly overwritten or the label format ends. ^BY: Sets default values for the width of the narrow bar, the width ratio… Continue reading Persistent ZPL commands that set default values for subsequent fields
Macbook Pro 13-inch Early 2015: keyboard and trackpad
(Lex Fridman Voice) The following… is my conversation with ChatGPT. I have a problem with my Macbook Pro. This is a 13-inch early 2015 model that is updated to the latest macOS it supports. It has never been disassembled or otherwise repaired. It has never had any kind of water damage. Sometimes, after I move… Continue reading Macbook Pro 13-inch Early 2015: keyboard and trackpad
Disabling the new Trello WYSIWYG editor
The new Trello WYSIWYG editor is hot garbage, dumbed down to suit 20 yr old SMM managers who can’t wrap their heads around Markdown. For those who do know markdown, the new editor is less functional, less predictable and less usable. Overall, using the visual editor implies using your mouse or trackpad, and that negatively… Continue reading Disabling the new Trello WYSIWYG editor
Forcing desktop or legacy HTML Gmail on iPad
I have multiple Google accounts on my personal iPad, and the work account is not the main one. The main account is also my personal and it does not have Gmail (it’s a Google account with @hotmail.com login). Using the regular UI buttons, it’s nearly impossible to switch to a. work account and b. have… Continue reading Forcing desktop or legacy HTML Gmail on iPad