What I have been working on since a couple weeks...
https://npub1etctwmz7lnpynz7h02erex3lf3jtz0me48xhvv7wpr742muvffps7vcr6n.blossom.band/2eb2c8b38c1da191361b9dc9a4e817edb902112b6be9662f02decb03a19de2e4.mp4
Katja Lutz
katywings@iris.to
npub1etct...cr6n
Altruistic anarchist, down-to-earth, independent hobby astronaut π§βπ and amazingly lively, passionate web developer in the stand against the technocrats.
Also founder of nitropage.org, the FOSS visual website editor.
Notes (11)
Status update, second to last.., only for Nostr enjoyers π»
I am still suffering from never ending phantosmia, and the latest experiments showed no signs of improvement. This week again I was forced to stay in bed for 50% of my time, fighting with seizures. Even having one right now, hanging my head 180 degrees rotated from the side of the bed, while writing this text. Next year my WG friends will move to a different place and I can't follow them. Since my financial situation only has gotten worse I am realistically speaking game over.
Over the past months couple people, even from this community and OpenSats, contaced me regarding work, but all my answers take 4 times as long as people expect. As the weeks come and go, and i am seeing how little I am able to do, I wonder how I ever could be able to make them happy and how working for them would reduce my suffering. People have absolutely no idea how bad my health situation is. So my OpenSats request is still in draft, and while I really want to submit it, in the same time I fear that it would just be an absolute waste of everybodies time, since I am neither a Bitcoin, nor a Nostr maxi π« . Positive news is that I joined the Solidjs fellowship, helping on the work for the next SolidStart version π!
Meanwhile Switzerland just accepted E-ID and all I can think of since last sunday is how I could leave this failed country, with no money and instead with a damned disability that nobody ever has heard of.
Call me a doomer, but I think my last hour has come.. Anyhow... keep stacking, even if it is cardboard under a bridge π. Have a sunny friday π€.
The longer I think about it, the more I come to the conclusion that the only difference between democracy (as it is practiced today) and oligarchy is that oligarchs in a democracy no longer have to fear losing their heads.
GM πββοΈ
Switzerland just voted for electronic id and it was approved with 50.39%. Friends... I am soo tired of this society βΊοΈ...
Finally I wrote again π. This time it's about God. (Unfortunately in german :P)
https://lufrai.org/blog/antwort-von-gott
To be fair, after further research, most databases actually do not delete data properly. If you wanna get rid of sensible data, in Postgres and Sqlite you have to run an extra "Vacuum" command, in Mysql you have to "Purge".
Feels like the only scalable way for guaranteed deletion is to either use no db at all or to go multi-tenant and create dbs per entity. E.g. in my app I wanna properly delete chat rooms after some expiration time, so maybe the way to solve this is to create one db per chat room π€.
nostr:nevent1qqs0fta3qla77g0jgy9mvlhpfm22zph9nupct5gcut32dz9y5dsjdscpzamhxue69uhhyetvv9ujumn0wd68ytnzv9hxgtczyr90pdmvtm7vyjvt6aaty0y68axxfvfl0x5u6a3necy064t0339yxqcyqqqqqqg0t0plj
Or to make it short: most humans are hypocrites π.
nostr:nevent1qqsggqy8p7phup0svrukl5n82ck7rzmwmr4k8ngpuntpyz4gsnzs5ygpzamhxue69uhhyetvv9ujumn0wd68ytnzv9hxgtczyqzvj9w6alhrsvtl5u6ygjkwuwg2sf5lukqskgjpuhnd6dpal0kvjqcyqqqqqqgplvne6
> In PostgreSQL, an UPDATE or DELETE of a row does not immediately remove the old version of the row.
Aiaiai π, using postgres for sensitive data maybe isn't a great idea after all? π₯΄
https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-SPACE-RECOVERY
So what do you prefer for nostr apps, nostr-tools or ndk? π€
I am building a proof-of-concept for an e2e encrypted, anonymous chat room with the ability to optionally sign messages with your nostr identity π.
Simple solution to the Fermi paradox: they looked at our "leaders" and came to the conclusion that we are not worthy π
.
GM πββοΈ
The system will get better by destroying itself. Perhaps the goal for us free-spirited humans should not be to stop the system, but to survive it, together.