Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Haynes, Dave (Cloud Services)
+1. Let's do it. If we need to add some extra tests to protect against regressions, then so be it. I will help. I also think better use could be made of the notifications system. A properly defined topic namespace would go a long way to assist that. -Original Message- From:

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Doug Hellmann
On Wed, Oct 3, 2012 at 4:46 AM, Haynes, Dave (Cloud Services) dave.hay...@hp.com wrote: +1. Let's do it. If we need to add some extra tests to protect against regressions, then so be it. I will help. I also think better use could be made of the notifications system. A properly defined

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Pitucha, Stanislaw Izaak
@lists.launchpad.net [mailto:openstack-bounces+stanislaw.pitucha=hp@lists.launchpad.net] On Behalf Of Johannes Erdfelt Sent: Tuesday, October 02, 2012 6:12 PM To: openstack@lists.launchpad.net Subject: Re: [Openstack] Discussion / proposal: deleted column marker On Tue, Oct 02, 2012, Pitucha, Stanislaw Izaak

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Day, Phil
: openstack-bounces+stanislaw.pitucha=hp@lists.launchpad.net [mailto:openstack-bounces+stanislaw.pitucha=hp@lists.launchpad.net] On Behalf Of Johannes Erdfelt Sent: Tuesday, October 02, 2012 6:12 PM To: openstack@lists.launchpad.net Subject: Re: [Openstack] Discussion / proposal: deleted column

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Doug Hellmann
: openstack-bounces+philip.day=hp@lists.launchpad.net] On Behalf Of Pitucha, Stanislaw Izaak Sent: 03 October 2012 13:09 To: openstack@lists.launchpad.net Subject: Re: [Openstack] Discussion / proposal: deleted column marker Hi Johannes, I know the names collide here, but since

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Federico Innocenti
+1 to the design proposed here. Even without embracing anything nova specific but simply from a database perspective the soft-delete approach is proven to be a poor solution to most of the problems it promises to solve. In addition to what Stan already pointed out, let me recap something

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Joe Gordon
+1 to the design proposed here Looks like there is already a session proposed for Grizzly summit: http://summit.openstack.org/cfp/details/63 best, Joe On Wed, Oct 3, 2012 at 10:07 AM, Federico Innocenti federico.innoce...@hp.com wrote: +1 to the design proposed here. Even without

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-03 Thread Robert Collins
On Wed, Oct 3, 2012 at 5:42 AM, Pitucha, Stanislaw Izaak stanislaw.pitu...@hp.com wrote: ... - Add a system similar to notifications, but for auditable events - who did what with which resource at what time - in some semi-structured way that allows reviewing and summaries (basic information as

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-02 Thread Johannes Erdfelt
On Tue, Oct 02, 2012, Pitucha, Stanislaw Izaak stanislaw.pitu...@hp.com wrote: I'd like to open a discussion on a topic that's been bugging me for a number of reasons - soft deletes (by that I mean marking rows with deleted=1 in the db) and related - actions audit. This is a subject I'm

Re: [Openstack] Discussion / proposal: deleted column marker

2012-10-02 Thread Johannes Erdfelt
On Tue, Oct 02, 2012, Pitucha, Stanislaw Izaak stanislaw.pitu...@hp.com wrote: Does anyone know why soft-delete is still in place? Are there any reasons it can't / shouldn't be removed at this time? If it's possible to remove it, would you miss it? I'm certainly not a fan of the database