Forum OpenACS Development: "soft delete"

18: "soft delete" (response to 10)
Posted by Andrew Piskorski on
Tom, your "soft delete" thing - aka, leave the acs_object references dangling so we can immediately re-use them later - sounds interesting. In your particular example, I'm not clear on why you couldn't upgrade the table in place. But regardless, maybe "soft delete" is something the data model should eventually explicitly support, to aid in upgrades or whatever.
Posted by Tom Jackson on


I may not have needed to do it, but one attribute was varchar and needed to be text. I also added a few not null attributes. I thought by the time I figured that out, for several tables, I could write the save/restore script. Then a few days later I made more changes and only spent a few minutes on the save/restore.

I think this also points to the fact that developing with real data can make you realize shortcomings pretty quickly.