Wednesday, February 28, 2024

Address Validator

Here in Czechia we have around 3M addresses, which is few enough to do an offline local validation. In MySQL it's around 250 MB, so if you're limited in database size, you can parse it from files.

Czech Office for Surveying, Mapping and Cadastre offers a ~62 MB ZIP archive with CSV files, one for each municipality, identified by its numeric ID, so you need to know it first.

I've decided to use Czech postal code database, provided by Czech Post as a single CSV files in ZIP archive, so I can search not only by municipality name, but by postal code as well.

Thursday, February 29, 2024

MacBook Air

For years I've been struggling with iOS development, as I didn't have a direct access to a Mac, so I had to circumvent this issue and it wasn't always easy. I feel like I've spend similar amount of time coding and getting to be able to.

My daily driver is now entering it's second decade of service and there wasn't a sufficient replacement so far. It's a really reliable workhorse, but as time goes by, I'm getting afraid it can kick the bucket any day - in the past I had some issues during bootup, so I don't even turn it off any more, only put it to the Sleep Mode, and restart just few times a year, usually to resolve some annoying issue that couldn't be resolved in any other way.

Travel device, not that light (1.24 kg / 2.7 lbs, 3 times Apple Magic Keyboard) but almost as small as my old ThinkPad X31 (3 cm wider, but 1 cm shallower and 2 cm thinner)


MacBook Air 13" in "Starlight" color

I also kinda dislike a second device, when I prefer to have everything just in my phone. But the tech simply isn't there yet.

Phone with kbd is clunky, turning on, no on-lap possibility

Dev debug device

Xcode dev

Great tech - Apple Silicon, larger display with workable resolution, TouchID power button, backlit keyboard, Magsafe as well as USB-C charging, ridiculous battery life

No OLED

Sync files - daily backup to USB (broken USB port), via phone

At home I keep it i “clamshell mode”, connected to a simple dock with passthrough power and HDMI cable to my LCD screen as HDMI2(?), use my Magic Keyboard and second position on my Logitech mouse.

M3 for xcode, months of support, latest macos