Regional Indicator Symbols in Unicode are the codes starting at U+1F1E6 to U+1F1FF. If you combine two of them in a valid ISO-3166-1 alpha-2 codes, they produce the flag corresponding to that code. We want a function flag_emoji() that takes such a two-letter code and emits the appropriate Unicode codepoint: SELECT flag_emoji('GB') AS gb, flag_emoji('us') AS us, flag_emoji('de') AS de \G gb: 🇬🇧 us: 🇺🇸 de: 🇩🇪 1 row in set (0.00 sec) MySQL For that, we define a helper function ...| Die wunderbare Welt von Isotopp
Cheap and integrated CO2 sensors are finally available. I got mine from Athom . They cost $25 per device. The device uses an ESC32C3 (4M) as a foundation and sports a Sensirion SCD 40. It does measure CO2 in range from 400-2000 ppm with 5% accuracy (that’s the Sensirion Spec), and also acts as a Bluetooth Proxy (because the ESP32 can do that). Unpacking is easy enough. Connecting to the Wifi AP offered by the unconfigured device with an iPhone did not work (“Cannot join …”), but confi...| Die wunderbare Welt von Isotopp
It has now been two years since we got the Megane e-Tech . Renault Megane e-Tech parked in Zandvoort aan Zee at the beach promenade in rainy weather. The car uses Google Automotive Services (GAS). It is basically an Android with a really big battery pack. Energy On long-distance drives in the Netherlands, we use about 14.4 kWh/100 km at the maximum allowed speed of 100 km/h. In Germany I usually dial in 115 km/h, and we end up at about 15.8 kWh/100 km. In the city, energy consumption varies, ...| Die wunderbare Welt von Isotopp
I have not been doing PHP in a long time, and so I am writing this here as a memo to self, in order to remind me what features are “new” in PHP, with “new” meaning 7.0 and newer. Features PHP versionCategoryFeature 7.0Typingdeclare(strict_types=1) directive 7.0TypingScalar type declarations 7.0TypingReturn type declarations 7.0OperatorsNull coalescing operator (??) 7.0ClassesAnonymous classes 7.0ErrorsThrowable and Error hierarchy 7.1TypingIterable pseudo-type 7.1TypingNullable types ...| Die wunderbare Welt von Isotopp
I’ve hacked together a horrible thing in Python, and made it available in mysql-release-notes on GitHub. It’s a Python project (done with uv) that downloads all MySQL release notes, dumps them into a release_notes folder, and then parses them, pushing everything into a database. It uses SQLAlchemy and mysqlclient to connect to the database. It generates a schema (not preserving any data), and fills it with all the release notes we have. The schema is a simple star. For each release, we ha...| Die wunderbare Welt von Isotopp
China stands out—unlike EU countries—as a nation with rapidly growing energy demand. According to Our World in Data, its electricity production is dominated by coal: https://ourworldindata.org/grapher/electricity-prod-source-stacked?country=~CHN&tableFilter=countries&tableSearch=China “OMG! So much coal! China dooms us all!” Well, no. We are looking at growth in a growing market, and that is complicated. Let’s switch to percentages… Coal’s market share peaked at about 80% in 200...| Die wunderbare Welt von Isotopp
An unpopular opinion: Revolt is a chat that ultimately tries to emulate and displace Discord as an alternative. Revolt is not E2E encrypted and not federated. That is a big plus. Federation and E2E encryption are features that make an implementation much, much more complicated without need. Most people do not want to organize a women’s shelter or abortion support or the antifash resistance. They just want to have a public guild server for their gaming guild or chat about 3D printers. Don’...| Die wunderbare Welt von Isotopp
Kris Köhntopp's blog (Fedi: @isotoppinfosec.exchange)| Die wunderbare Welt von Isotopp
Kris Köhntopp's blog (Fedi: @isotoppinfosec.exchange)| Die wunderbare Welt von Isotopp
ADVERTISEMENT| United Kingdom
Censorship and language have a long, intertwined history, and the linguistic innovations on TikTok are only the latest chapter.| Babbel Magazine
Kris Köhntopp's blog (Fedi: @isotoppinfosec.exchange)| Die wunderbare Welt von Isotopp
Kris Köhntopp's blog (Fedi: @isotoppinfosec.exchange)| Die wunderbare Welt von Isotopp
Kris Köhntopp's blog (Fedi: @isotoppinfosec.exchange)| Die wunderbare Welt von Isotopp