Making KioskPi — custom Raspberry Pi OS image using Pi-Gen
How to make use of Pi-Gen, a tool used to create Raspberry Pi OS images. Today, we’re gonna create our own Pi OS image featuring a Web-Based Kiosk with HDMI-CEC control. Minimalistic and performance-oriented. No desktop environments or Chromes to slow us down.
My specific use case is making a digital menu card to be displayed at three portrait mounted TVs in my friend’s canteen.
MySQL as smart JSON storage
I’ve been using this semi-relational, or SemiSQL, if you’d like, approach to SQL since around 2009. At first, I’d store the data as text or longtext types using PHP’s serialize(), but then I quickly moved to JSON.
In late 2015, with MySQL 5.7.8, our prayers were answered and the native support for JSON datatype was introduced. 🙏
Let’s have a look at the best practices using JSON in MySQL 8.
Cron backups into remote chroot using rsync [Linux how to]
A lot of us use cron & rsync -e ssh for backups. On the backup server, we’d love to chroot for many obvious reasons, but chroot breaks rsync. I’m sure you’ve tried & seen something like this:
protocol version mismatch -- is your shell clean?
Here’s my full solution on automated backups using chroot.
TLDR; if you’re only interested in making rsync work, head near the end.