Re:Anyone can access deleted and private repository data on ...
by dumbo-octopus on Thursday July 25, 2024 @10:48AM
(#41069355)
I used the first definition of delete I found which, while arguably “archaic”, matches the modern technical term almost exactly. We’d typically call that a well known word with a clear meaning.
And sure, the DELETE FROM statement in postgres - or any other standards compliment sql db I know.
Re:Anyone can access deleted and private repository data on ...
by 8organicbits on Thursday July 25, 2024 @11:12AM
(#41069627)
In technical writing you often don't want to use the dictionary for definitions, similar to how words in a contract can have unexpected meaning in a legal setting.
For Postgres you've got to consider vacuum. Auto vacuum is enabled by default. Deleted rows are removed unless you go out of your way to make it do something different.
Pointing to which database you are talking about should clear this up quickly.
I don't think it's reasonable to talk about backups here. A backup is external to the database so it inherently cannot delete it. Similar to how a piece of paper cannot destroy a photograph of the paper, but burning the paper destroys it.