title: Hide rows in postgres
body: <p>I have decided that instead of deleting rows from a postgres database, I rather hide the rows so that in case the rows were deleted by accident, I can still retrieve them. What is the best approach to hide rows from a database? Do you recommend creating a column named "Active" and giving it a value of either 1 or 0, 1 meaning active and 0 meaning deleted and hidden. I'm also using sqlalchemy if that matters. </p>