Show newer

> Five minutes after this supposed all-time high [$2,861.80], at 9.40am, SQUID had cratered to $0.0007926 — a fall of 99.9999%.

lol

coinmarketcap.com/alexandria/a

That mixed feeling when you're looking through wiki for a solution to your modern laptop's sleep/suspend problems, and the tips&tricks make use of a hack kernel module you wrote 10 years ago...

Michal boosted

Me: don't you overdo it with coffee?
My S.O.: No, it's just my 4th today, why?

has a federation tester [1] to make sure your homeserver is reachable "from the outside". Does something similar exist for ?

[1] federationtester.matrix.org/

Cloudflare has a "no malware and adult content" version of 1.1.1.1 resolver: 1.1.1.2 (no malware) and 1.1.1.3 (no malware + adult content), naming it "1.1.1.1 for families"

blog.cloudflare.com/introducin

Michal boosted

Found the Elon Musk "I'm a conman" song that Thunderf00t references a lot 🙂

youtu.be/kcIedRXflTY?t=19m19s

Running local experiments on "Developer Memes" it wouldn't have worked well anyway. As soon as it's not dark text on light background, tesseract doesn't detect it.

Show thread

idea - run images through tesseract, to search-index them memes without captions.

Michal boosted

I don't know who needs to hear this, but "Open Source" does not mean that any pull request/contribution has to be accepted

Michal boosted

Year progress: ▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒░░░░ 80.0%

"Flattening" JSON in using json_tree[1], useful for grepping through huge unknown structures:

> CREATE TABLE raw(id TEXT PRIMARY KEY, data TEXT);
> INSERT INTO raw VALUES('x', '{"a":{"b":"hello","c":123},"d":[1,2,3]}');
> SELECT raw.id, j.fullkey, j.type, j.value FROM raw, json_tree(raw.data) AS j WHERE j.type NOT IN ('object', 'array');
id,fullkey,type,value
x,$.a.b,text,hello
x,$.a.c,integer,123
x,$.d[0],integer,1
x,$.d[1],integer,2
x,$.d[2],integer,3

[1] sqlite.org/json1.html

"Everyone pays for a house in their lifetime. Either their own, or their landlord's" 😁

Michal boosted

@enkiv2 @wim_v12e @bhaugen @Sandra @mathew @natecull Yeah I don’t know where this whole notion of SQL being slow and clunky or bloated comes from. SQLite, PostgreSQL, and MySQL/MariaDB have all had engineer-centuries put into them, and they’re rock solid, high-performance databases. They’re incredibly hard to beat. Most “schemaless” databases are extremely immature by comparison.

It turns out OpenSSH dropped support for "ssh-rsa" since "it's not safe anymore", so I can no longer connect to my router:

> Unable to negotiate with 192.168.1.1 port 22: no matching host key type found. Their offer: ssh-rsa

Fortunately they kept the code in, just disabled by default. Put this in your ~/.ssh/config to be able to connect again:

HostKeyAlgorithms +ssh-rsa
PubkeyAcceptedKeyTypes +ssh-rsa

I never realized that Idiocracy, the documentary-that-was-not-supposed-to-be, had no release marketing and basically spread by word of mouth.

youtu.be/qPCHh-ipJ5U

Michal boosted

The Hitchhikers Guide to the Galaxy was published 42 years ago today.

I've just been to a back massage. They had a strange space heater with a "familiar" fan noise. Upon close inspection it was connected to network, and asking out loud, it turns out it was an Ethereum mining rig.

Since there's no public heating in the place and they would have had to use electric heating anyway, might as well put that electricity to good use.

Show older
Mastodon

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!