Sunday, 25. February 12024
p3k dots

Fighting Phantasms for over a decade.

Why We Can’t Build Better Cities.

Python Dependencies Are Fixable.

I was shocked when I started working with NodeJS teams at how aggressively and (frankly) recklessly they would add dependencies to a project. However NPM and Node are designed around that model of lots of external dependencies and they’ve adopted a lot of things that people have come to expect.

Relevant: pip-compile --generate-hashes

GPT in 500 lines of SQL.

What is a generative large language model from a technical perspective?

Really Large Git Repositories.

Relevant: git maintenance

You say you’re trying to find the fire.
But to me, it looks like burning.

osquery exposes an operating system as a high-performance relational database. (Via lobste.rs.)

This allows you to write SQL queries to explore operating system data. With osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes.

Saturday, 24. February 12024
p3k dots

Subprime Intelligence.

This industry is money-hungry, energy-hungry, and compute-hungry, yet it doesn’t seem to be doing anything to sustain these otherworldly financial and infrastructural demands, other than the fact that people keep saying that “artificial intelligence is the future.” And while some claim that AI can help fight climate change, it’s impossible to argue that “suddenly using more and more power for a negligible return” is good for the environment.

Friday, 23. February 12024
p3k dots

mzmzmz 🕺

htmx, htmy, htmz.

Killed by Google is the open source list of dead Google products, services, and devices. (Via adactio.com).

Just learned about MariaDB’s create table like and insert select syntax – and an easy way to save a corrupted InnoDB table:

create table shiny_table like tragic_table;
insert shiny_table select * from tragic_table;
drop tragic_table;
rename table shiny_table to tragic_table; # Not so tragic anymore 😅