As you get older, you stop using LEFT JOINs in your queries and eventually find yourself using RIGHT JOINs
Category: Uncategorised
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
Download links to (some) old Hubstaff versions still online
I need to put Hubstaff on an older Windows PC and I’m looking for a respecively older release thinking it’d consume less resources. The official Hubstaff website links to 1.6.11, which is the newest now in January 2023. The direct download link format is https://hubstaff-production.s3.amazonaws.com/downloads/HubstaffClient/Builds/Release/${version}/Hubstaff-${version}.${extension}, where ${version} is 1.6.11-35d12459. And because the build code/hash is… Continue reading Download links to (some) old Hubstaff versions still online
Switching Hotmail.com/Outlook.com to the lightweight version
Below is the answer to this question from 2020. To force Hotmail.com/Outlook.com load the lightweight web versions, open your mail via one of these links: https://mail.live.com/?layout=light https://outlook.live.com/owa/?layout=light Both are working as of now (January 2023) Sadly, it doesn’t work for all accounts. I have two @msn.coms, and for one of them it throws Something went… Continue reading Switching Hotmail.com/Outlook.com to the lightweight version
Expired SSL certificates on older iOS devices
Many websites these days use the free SSL certificates from LetsEncrypt. These are fully automated, (again) free and very convenient. On the downside, if something gets changed on their end, it may affect a lot of users. One of such changes happened with their ROOT certificate back in September 2021: DST Root CA X3 Expiration.… Continue reading Expired SSL certificates on older iOS devices
Kindle stuck on “Weak Battery” and won’t take charge
I haven’t used my kindle for a while and when I opened it, it gave me the "Batterie Faible" ("Weak Battery") error message, asking me to connect it to a power source, which made sense after a month of inactivity so I’ve put it on charger. However, an hour went by but the error didn’t… Continue reading Kindle stuck on “Weak Battery” and won’t take charge
How to jump to a specific git commit?
To jump to a specific commitId: git checkout <commitId> To return to the tip of the branch: git checkout <branchName>
Quick and dirty Raspberry PI desktop
apt-get update && apt-get upgrade apt-get install –no-install-recommends xorg openbox lightdm fbpanel onboard Enable Desktop Autologin and HDMI audio sudo raspi-config Fix HDMI audio for old TVs sudo vi /boot/config.txt Autostart fbpanel: echo "fbpanel &" > ~/.config/openbox/autostart More: https://www.reddit.com/r/openbox/comments/7zizxn/cant_get_openbox_to_turn_off_antialiasing/
Openbox: Failed to open the display from the DISPLAY environment variable
Problem when running openbox-session: Openbox-Message: Failed to open the display from the DISPLAY environment variable. Solution: startx