Very nice, just as expected it was one of the first renditions on the Floppotron 3.
https://youtu.be/3KS02q0BUnY
Did you know you can run #SQLite queries on CSV files directly? 😍
https://til.simonwillison.net/sqlite/one-line-csv-operations #cli #sql
$ sqlite3 :memory:
sqlite> .mode csv
sqlite> .import thermometer.csv therm
sqlite> .schema
CREATE TABLE therm(
"date" TEXT,
"time" TEXT,
"temperature" TEXT
);
sqlite> SELECT date, MAX(temperature) FROM therm GROUP BY date;
2022-06-19, 35.4
2022-06-20, 42.8
2022-06-21, 49.3
Or in one line:
$ sqlite3 :memory: -cmd '.mode csv' -cmd '.import thermometer.csv therm' 'SELECT ...'
I was researching NOTAMs (Notices To Airmen) and couldn't find historical data.
If you want to know about high drone flights, big cranes, lasers, fireworks - NOTAMs are where they're announced.
These are all things I like, so I built a public archive: https://github.com/Jonty/uk-notam-archive
Ist euch aufgefallen, dass bei der Ankündigung zwar das übliche Datum steht, aber kein Jahr definiert ist?
Gnihihihi.
'Our scanners are picking up an anomaly.'
'Give us a visual.'
Empty starscape blinked onto the screen. Distant stars like glitter. None of the expected confetti of asteroids. No planets or ships.
'What is that?' The captain pointed to a glitching pixel. 'Enhance.'
The image locked onto the point. Zoomed.
'Prrt?' said the anomaly.
'Is that ... ?'
The glitching space cat rolled over and trotted across empty space toward the ship, tail quirked in a friendly greeting.