4 ms·
Help me here please. I really do not see how WHERE CURRENT_TIMESTAMP BETWEEN start AND end is much better than WHERE deleted_at IS NOT NULL Also, if we are ta
by adontz 2y ago
Help me here please. I really do not see how
WHERE CURRENT_TIMESTAMP BETWEEN start AND end
is much better than
WHERE deleted_at IS NOT NULL
Also, if we are talking about real use case of audit, not a simplified artificial one, my real tables were more like
changeset(id INT, timestamp DATETIME, user ^USER, host TEXT, ip_address TEXT, <other security data>)
datatable1(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)
datatable2(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)
datatable3(id INT, created_at ^changeset, updated_at ^changeset, deleted_at ^changeset NULL, <other fields>)
- b-man 2y agoIt is better, as others have written, because it preserves integrity constraints.