Mailing List Archive: [Bricolage-General] trash left in DB

[Bricolage-General] trash left in DB

Mar 21, 2002, 4:34 PM

Post #1 of 4 (1044 views)

Creating a story and stopping at the "save" point of the creation
seems to result in the story disappearing from view via search. The
database show most of the "story*" tables contain the newly created
story ID but it is not retrievable unless moved to a "desk".

Likewise, if a story is moved to one of the desks and the deleted
(whether or not checked out) , the entries in table "story*" remain.

I can see this eventually filling the DB with crap. Is this normal??

Michael
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

Re: [Bricolage-General] trash left in DB [ In reply to ]

sam at tregar

Mar 21, 2002, 4:37 PM

Post #2 of 4 (1019 views)

Permalink

On Thu, 21 Mar 2002, Michael wrote:

> I can see this eventually filling the DB with crap. Is this normal??

Yes. Bricolage very rarely deletes anything from the database. Instead
it marks them with "active = 0".

-sam

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

Re: [Bricolage-General] trash left in DB [ In reply to ]

michael at insulin-pumpers

Mar 21, 2002, 4:48 PM

Post #3 of 4 (1018 views)

Permalink

> On Thu, 21 Mar 2002, Michael wrote:
>
> > I can see this eventually filling the DB with crap. Is this normal??
>
> Yes. Bricolage very rarely deletes anything from the database.
> Instead it marks them with "active = 0".
>
> -sam
>
>
Ok.... so at some point when it is full of stuff, how does it get
cleansed?? Examining the story table shows unpublished stories to
have "active=0" so no assumption can be made about it being "dead".
Hows does one differentiate between an un-published story that is a
work in progress and one that has been deleted. Since there appears
to be no way to ressurect a deleted story, what's the point??

What am I missing.

Michael
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

Re: [Bricolage-General] trash left in DB [ In reply to ]

sam at tregar

Mar 21, 2002, 4:58 PM

Post #4 of 4 (1015 views)

Permalink

On Thu, 21 Mar 2002, Michael wrote:

> Ok.... so at some point when it is full of stuff, how does it get
> cleansed??

It doesn't.

> Examining the story table shows unpublished stories to
> have "active=0" so no assumption can be made about it being "dead".

Look again - only deleted or unsaved stories should have "active = 0".
Unpublished stories have "publish_status = 0".

-sam

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general