My July ‘20 in Review
Published on in ✍️ Posts
Meanwhile the seventh month of this year is over and so here is my monthly review of July 2020.
2020
Published on in 💬 Micro
This day is successful: I created a recursive SQL CTE in SQLite even before noon. 🤓
with recursive f (i, fp, tp) as (select 1, fromPath, toPath
from redirects
where fromPath = ?
union all
select f.i + 1, r.fromPath, r.toPath
from redirects as r
join f on f.tp = r.fromPath)
select tp
from f
order by i desc
limit 1
This is for my new CMS project.
Handle HTML forms through email with MailyGo
Published on in 🔗 Links
It’s nice to see when people fork, modify and actually use your open source projects. Like Emanuel Pina does. He has forked my project MailyGo, which enables receiving form submissions on static sites and sends them via e-mail. He added some nice features (which I will definitely take inspiration from and add some back to the upstream project!).
Published on in 💬 Micro
It was a nice HWC on Wednesday. (I already wanted to post this photo yesterday, but had to repair my Micropub media endpoint first…)
🖼️ View
Published on in 💬 Micro
Today I will participate again at the HWC Europe/London (remotely, but this time with a webcam). I am looking forward to some nice discussions. Until then I’m going to program a little bit on my own CMS.
Writing my own CMS in Golang?
Published on in 💭 Thoughts
After trying to write my own static site generator as an experiment, I now started to write my own CMS. Written in Go, SQLite as database (SQLite is awesome!) and focused on performance and simplicity. Currently I’m using Hugo with a number of dynamic additional services (for Micropub, Webmentions, ActivityPub, …), so it’s almost questionable why I use a static page generator at all. If I use my own lightweight and high-performance CMS, I could save myself all this extra stuff or at least reduce it in complexity.
“7 myths Apple is using to justify their 30% tax on apps”
Published on in 🔗 Links
Pavel Durov, founder of Telegram, published a blog post with “7 myths Apple is using to justify their 30% tax on apps”. He explains quite well why Apple’s practices are not fair and disproves many arguments that you can regularly read from Apple fans on Hacker News or in comments on tech news sites.
Less news
Published on in 💭 Thoughts
I just dropped a lot of feeds (mainly news) from my feed reader. I can’t scroll through about 900 new entries every day and then have 60 bookmarks that I spend all my time working through. Even though there are no algorithms that want to get me addicted to never ending timelines, I have to set limits.
TinyPilot
Published on in 🔗 Links
Michael Lynch is someone who, when he has an idea or a problem, spares no effort to get to the bottom of it and develop a solution, usually with a combination of hardware and software. Recently he developed a project that allows him to remote control a server just by connecting a Raspberry Pi via USB and HDMI. The Pi runs a program with a web interface that forwards the keyboard input to the server via USB and sends the HDMI output back to the browser. This allows it to control the BIOS and even install a new operating system.
Pure CSS Minesweeper
Published on in 🔗 Links
I once wrote about pure CSS paintings. It’s amazing what you can achieve with just HTML and CSS. Another amazing thing is CSS-Sweeper, a Minesweeper clone written in just HTML and CSS. It’s not the fastest implementation but more a “stress test” and will probably have lags on average computing devices. Nevertheless, it’s awesome! You can play it here.