11 reputation
2
bio website
location
age
visits member for 2 years, 1 month
seen Jul 18 at 19:23

Jul
7
comment How do I add versioning to this CMS I'm designing?
I've never heard of table inheritance. Does that exist in MySQL? Or only in more advance systems like PostgreSQL? Can you link me a page that explains how that works?
Jul
7
comment How do I add versioning to this CMS I'm designing?
That means that every widget I make has to re-implement versioning, right? And that also means that if I change a page by changing 2 of its blocks then that change is reflected into 2 different tables. So the rolling back process would need to look at a lot of different tables. Would it be possible to do it all in one table?
Jul
7
awarded  Student
Jul
7
asked How do I add versioning to this CMS I'm designing?
Sep
27
comment Combining a tree structured Group model with its HABTM User model in one VIEW
Would you like to share both your SQL and your Perl code with me?
Sep
20
comment Combining a tree structured Group model with its HABTM User model in one VIEW
Well I know I can very easily do it with option 3, but I thought that MySQL is faster at these things than PHP. That is why I wanted to do it with MySQL. However, if you say that it makes no difference performance wise between option 2 and 3 then I will take option 3. What do you think?
Sep
19
comment Combining a tree structured Group model with its HABTM User model in one VIEW
Well, for the Group model I have that covered with a behavior in CakePHP. However, for the VIEW that shouldn't be a problem. The idea is that the VIEW is generated on the fly via some sort of super-complex query. So the lft/rght values of the VIEW should also be calculated on the fly by the query.
Sep
19
comment Combining a tree structured Group model with its HABTM User model in one VIEW
Fixed the example. Why do you doubt that? I thought SQL was capable of doing very complicated stuff?
Sep
19
awarded  Editor
Sep
19
revised Combining a tree structured Group model with its HABTM User model in one VIEW
corrected my example view
Sep
19
revised Combining a tree structured Group model with its HABTM User model in one VIEW
added tag
Sep
19
asked Combining a tree structured Group model with its HABTM User model in one VIEW