links for 2010-03-15

Posted byWaldo Jaquith
  • Reddit: Soft deletes in SQL
    In response to a question on Reddit about how to delete with faux deletions in SQL, somebody offers this clever solution: create two views of the table, one listing all deleted records, and one all active records. Use those, and never the source table.
    (tags: sql mysql programming)

Published by Waldo Jaquith

Waldo Jaquith (JAKE-with) is an open government technologist who lives near Char­lottes­­ville, VA, USA. more »