Anonymous ID: 0bcc94 Jan. 14, 2023, 1:49 p.m. No.18144821   🗄️.is 🔗kun

What is a soft delete? A soft delete marks a record as no longer active or valid without actually deleting it from the database. Soft deletes can improve performance, and can allow “deleted” data to be recovered. Did this article help you?

Anonymous ID: 0bcc94 Jan. 14, 2023, 1:52 p.m. No.18144837   🗄️.is 🔗kun

Using soft-deletion even for one entity will lead you to a bunch of new development conventions. You need to keep in mind that the delete process is not just delete, but sometimes the update, and not all data in a database table should be available for the application.

Anonymous ID: 0bcc94 Jan. 14, 2023, 1:57 p.m. No.18144858   🗄️.is 🔗kun

What Is Soft Delete? Soft delete performs an update process to mark some data as deleted instead of physically deleting it from a table in the database. A common way to implement soft delete is to add a field that will indicate whether data has been deleted or not.

Anonymous ID: 0bcc94 Jan. 14, 2023, 2:02 p.m. No.18144885   🗄️.is 🔗kun   >>4916

Hard Deletes — The entire record is deleted from the table. After the delete, users will not be able to see that the record ever existed. Soft Deletes — The record is not removed from the table, but a field on the table indicates that it is deleted.