Avatar
semisol
52b4a076bcbbbdc3a1aefa3735816cf74993b1b8db202b01c883c58be7fad8bd
👨‍💻 software developer 🔒 secure element firmware dev 📨 nostr.land relay all opinions are my own.

I need a blob store meant to handle millions of small files.

SeaweedFS is good but it has bad crash recovery leading to often manual recovery being needed.

Any other good options?

The column is there with what? Absolutely nothing! That column is about as good as gone even if you forensically analyse the files.

Please take an image of yourself holding a fish on your index fingers

The column is there with absolutely no data and only remaining there as a tombstone. To remove it would require significant effort that has minimal benefit

that, or you will die of a mysterious heart attack caused by bird pecking

There are real birds scattered along with fake ones. The fake ones exhibit measures against verification including faster escapes

Any attempt to capture will also lead to them exploding

Okay so what? The data is gone. The name is gone. The data type is gone. Everything about the column except that there was SOME column is gone.

And you’re telling me this is not true deletion?

Birds are not real.

nostr:note1ykj6g2vx2lde6scdt6ffh6meaakvl437k9lmwxgylrug35etgtzsc5xhwz

That blog post just proves my point. Vacuum full does remove the data.

All that remains is a tombstone of the column.

Tell me you don’t know how DBs work without telling me you don’t know how DBs work.

The dropped columns are deleted once a row containing the value is updated, or for the entire table once a full vacuum is ran.

After that the only thing that remains is the column having existed. Rewriting the entire table immediately on drop column would be disruptive (just do a vacuum if you care!), and removing the record of the column existing would require a similar operation that has negligible benefits

nostr:note18gvcptru52dfgej79khgrpwfxhjdys54qarv2y2kn54s27wkh0dq9r8etp

I am aware Noswhere is having issues. The disk is failing and it’s still running on the old DB engine

Replying to Avatar jon doe

nostr:nprofile1qqs99d9qw67th0wr5xh05de4s9k0wjvnkxudkgptq8yg83vtulad30gpzamhxue69uhkuenyvghxummnwa5x2un99e3k7mgpp4mhxue69uhkummn9ekx7mqpz3mhxue69uhhyetvv9ujuerpd46hxtnfdujm6acf Relay seems to be down. Getting two kinds of errors for several hours now. "Bad Gateway" "Failed to Connect" Just reporting over to ya 🫡

Which one?