ln's postgres optimization tip
put "EXPLAIN ANALYZE" in front of your query, paste output to https://explain.depesz.com/ and look for values in the exclusive column which look way too high. then check in the node column what it is doing and maybe add an appropriate index.
*poof* yer a postgres witch now :3
I still think what I wrote there, my thesis, still holds up 10 yrs later:
> If your app doesn't have a URL, who's going to use it?
I just realized that I wrote this
TEN YEARS AGO
https://sequentialread.com/pragmatic-path-towards-non-technical-users-owning-their-own-data/
jeeezus im getting old
streaming work on a web application to provide students with an instant development and deployment environment (vscode in the web browser).
my first fermented drink project :X
https://sequentialread.com/fancy-homebrew-grapefruit-energy-drink/
#GoToSocial 0.3.0 aka Stimky Sloth is out now
https://github.com/superseriousbusiness/gotosocial/releases/tag/v0.3.0
This release includes pubic profile pages at last! Migration to the new version is pretty easy, see the release for details.
Have fun with your new profile pages!
streaming again today https://stream.sequentialread.com/
war
im studying history right now
1994 https://en.wikipedia.org/wiki/Budapest_Memorandum_on_Security_Assurances
2013 https://en.wikipedia.org/wiki/Euromaidan
2014 https://en.wikipedia.org/wiki/2014_Crimean_status_referendum
2020 https://picopublish.sequentialread.com/files/ukraine-president-decree-392-2020-translated/
I started making these silly images for mainstream social media platforms when I announce my streams because my friend told me that text-only posts (especially containing links) will be buried automatically by them and its much better to post an image and then post the link as a comment. IDK if this is still true, I think its silly but whatever, when in rome....
https://stream.sequentialread.com/
Implementing support for serial console access to vms in capsul-flask
ππΌββοΈπ¨πΏβ𦲠Fracus and Darwin πΏποΈποΈπΏ
I liked the idea of golang's module system (every module is just a url) because it seemed to invite more decentralization in packaging, welp, today I discovered firsthand just how wrong I was: https://github.com/golang/go/issues/51174
listening to sunn O))) and working on capsul
I worked in tech for ~5 years, saved up a bunch of money, and quit.
I'll probably run out of money eventually but for now I'm just working on my own things and trying to make the practice of self-hosting much easier for everyone.
PGP fingerprint: F320 6D74 BCE2 8E9E 647C 8678 2D26 6F0E FADC 37