Articles
Content for your web-enthusiast brain.
Seeding a MySQL 8 table with geographic coordinates using Laravel
Today I learned that MySQL 8 has column types to store geographic coordinates, the simplest of them probably being POINT. It’s less straightforward than what I expected, so here’s how I managed to seed my database using Laravel.
GitHub Markdown syntax for alerts considered harmful
Article updated on
I had multiple options for the title of this note, from being neutral to opinionated, or even pedantic. I deliberately kept the worst.
The rant has been written before having discovered this comment and its answers on the related GitHub community discussion. If you’ve already read what’s there, you won’t learn anything new here. (I am actually glad my observations were all backed by others before I even published them.)
Continue readingDownloading Xcode Simulators on macOS Sonoma when the bandwidth is slow
Article updated on
Since macOS Sonoma (macOS 14), Xcode doesn’t include any iOS Simulator anymore, so it’s now 50% lighter to download (3.2 GB instead of 7 GB), which is nice… except that downloading the Simulator separately sucks if your bandwidth is slow and will peak below 5 MB/s no matter your bandwidth.
Recover a lost Git stash in two steps
Losing in-progress work is one of the fastest ways to feel helpless in front of a computer. This article about recovering lost git stashes was initially published 5 years ago on Dev.to and has a steady 10000 views per year, so I guess it happens to a lot of persons.
Continue readingUsing Vitepress cleanUrls option on a Nginx server
cleanUrls option on a Nginx serverWe share, receive and see URLs all the time, so it’s nice to have human-readable URLs like example.tld/yeah instead of example.tld/yeah.html.
On this blog using Vitepress on a Nginx environment, it works rather well (with a minor trade-off).
Continue reading