Log message #536706

# At Username Text
# Feb 19th 2009, 14:36 jperras so if we're going all AI, great
# Feb 19th 2009, 14:35 jperras it's about mixing char(36) with int in cake's acl system
# Feb 19th 2009, 14:34 jperras it's not about being able to guess
# Feb 19th 2009, 14:34 alkemann jperras: given how we will implement permissions and that things are either public or not, i dont see any problem with "guessable" urls. ie we can just use AI for all ids
# Feb 19th 2009, 14:20 jperras as long as we're not mixing uuid and auto increments, I'm happy with that
# Feb 19th 2009, 14:18 alkemann dont see a problem using autoincrement for article id
# Feb 19th 2009, 14:18 AD7six id or a numeric sequence then.
# Feb 19th 2009, 14:17 markstory id/slug only works if you have numeric keys though.
# Feb 19th 2009, 14:17 AD7six excellenty
# Feb 19th 2009, 14:16 gwoo wfm
# Feb 19th 2009, 14:16 gwoo id/slug
# Feb 19th 2009, 14:16 alkemann making friendly urls should only go so far
# Feb 19th 2009, 14:15 alkemann i agree
# Feb 19th 2009, 14:13 AD7six one thing I'd like to ask about before I go today is how url navigation should work - I think it would be v beneficial to move from slug lookups to the same as the book (id lookups, using the slug as seo fodder)
# Feb 19th 2009, 14:09 gwoo ACTION thinks we can find some consenses
# Feb 19th 2009, 14:03 AD7six gwoo: being one of them :D
# Feb 19th 2009, 14:03 AD7six I'm not going to demand that people giving their time for free do things my way or not at all for a number of reasons :)
# Feb 19th 2009, 13:58 alkemann seeing as i already wrote both behaviors and think this is the way to go, i dont plan on implementing it another way no. but im not adamant about it. if a consensus to do it some other way can be reached
# Feb 19th 2009, 13:56 AD7six alkemann: shadow tables are usfule with massive amounts of data - I don't see the bakery fitting that need. but since you're likely to be implementing that, I can guess what's going to happen.
# Feb 19th 2009, 13:55 alkemann any changes a user does to an article page is saved in the draft table. when a moderator accept. the draft version is moved to live and the live to revision
# Feb 19th 2009, 13:55 AD7six anything else wrong/missing?
# Feb 19th 2009, 13:55 AD7six but in many regards it doesn't matter how it's implemented so long as the effect is the same
# Feb 19th 2009, 13:54 AD7six I thought the bakery logic (for edits, because that's the only time revisions are important) was user edits (submits a draft ?) moderator approves, previous version either marked as previous or deleted
# Feb 19th 2009, 13:54 alkemann this way you only access the other versions when you need to
# Feb 19th 2009, 13:53 alkemann AD7six: u could off course have it all in one table. that would just create a big one..
# Feb 19th 2009, 13:53 AD7six alkemann: I don't follow why that necessitates 3 tables
# Feb 19th 2009, 13:52 alkemann AD7six: 3 sets of data. revision table holds previews versions of the article. live table holds current live version, draft table holds users latest edit that has not yet been made live (and will become a revision when a new editition is pushed live)
# Feb 19th 2009, 13:52 gwoo so pages
# Feb 19th 2009, 13:52 AD7six articles have a status flag for draft, pending, published, rejected
# Feb 19th 2009, 13:51 AD7six I'm only talking about the data in the db
# Feb 19th 2009, 13:51 gwoo yes
# Feb 19th 2009, 13:51 AD7six gwoo: when you say revision - are you attaching additioanl meaning such as "revisions are visible to others"?
# Feb 19th 2009, 13:51 gwoo and that would be a revision
# Feb 19th 2009, 13:51 gwoo otherwise its just on hold for moderation
# Feb 19th 2009, 13:51 gwoo if we are to have true drafts
# Feb 19th 2009, 13:50 AD7six gwoo: I don't understand what you mean
# Feb 19th 2009, 13:50 alkemann AD7six: yes. maybe the name is wrong. we are not making drafts. author is publishing it, but we are moderating that publishing
# Feb 19th 2009, 13:50 gwoo it does not become a revision until its out of draft status
# Feb 19th 2009, 13:50 AD7six is featured superceeded by the vote up/down logic?
# Feb 19th 2009, 13:50 gwoo AD7six: no
# Feb 19th 2009, 13:49 AD7six a draft is a revision