HNHacker News
TopNewBestAskShowJobs

username1407

15 karma · joined January 1, 2023

submissionscomments
username1407··on BBEdit: Where Respect Is Due
Me neither, and thanks to Apple’s idiotic thought of 1 country = 1 language I’m not even allowed to read it my the language of choice. Thanks Apple!
username1407··on Delegaid – package your favourite prompts in simple UI
I've read the landing page and I have no idea what this does or who the target audience is.
username1407··on Easy, alternative soft deletion: `deleted_record_insert`
That's true.

To give an example for your 1st point: If you have the schema users->messages->message_attachments and message_attachments does not store the user_id, you'll have trouble finding all attachments from a specific user.

username1407··on Easy, alternative soft deletion: `deleted_record_insert`
Can't you use json operators [1] for this?

-- Permanently delete message sent by jon

DELETE from deleted_record where table_name = 'messages' and data->>'sender' = 'jon';

[1] https://www.postgresql.org/docs/15/functions-json.html