History of LibertyPackage

A new feature for Clyde, the "common" package allows wiki, blogs, articles, and more to store their data in the same table, called tiki_content. This table holds the text data for all content - blogs, wiki, articles, etc. all in one column. This permits super fast searching, as well as simplified data storage/retrieval & text processing via a common base class.

{img src=http://www.tikipro.org/imagegals/show_image.php?id=28 align=center }

Here is what the tiki_content table looks like:

Table "tiki.tiki_content"
Column | Type | Modifiers
-----------------+------------------------+--------------------------------------------------------------------
content_id | integer | not null default nextval('tiki.tiki_content_content_id_seq'::text)
content_type_id | integer | not null
created | bigint | not null
last_modified | bigint | not null
language | character varying(2) |
title | character varying(160) |
data | text |

And here is the initial contents of the tiki_content_types table:
=> select * from tiki_content_types;
tiki_content_type_id | content_type
----------------------+--------------
1 | Wiki
2 | Blog Post

A few notes:
* Variable languages for the same content_id is not currently implemented. In fact, content_id is a PRIMARY KEY. Eventually, the PRIMARY KEY for tiki_content will probably be (content_id, language)
Page History
Date/CommentUserIPVersion
18 Dec 2008 (03:09 UTC)
new page link
Will69.203.72.16143
Current • Source
laetzer85.178.14.21642
View • Compare • Difference • Source
Kozuch85.207.244.16041
View • Compare • Difference • Source
Will69.203.72.16139
View • Compare • Difference • Source
laetzer85.178.62.11738
View • Compare • Difference • Source
Will206.83.76.1536
View • Compare • Difference • Source
Will206.83.76.1535
View • Compare • Difference • Source
Will206.83.76.1534
View • Compare • Difference • Source
dspt213.184.224.332
View • Compare • Difference • Source
spiderr66.93.240.20431
View • Compare • Difference • Source
spiderr66.93.240.20430
View • Compare • Difference • Source
spiderr68.125.207.11628
View • Compare • Difference • Source
spiderr66.93.240.20427
View • Compare • Difference • Source
Stephan Borg218.214.1.11324
View • Compare • Difference • Source
spiderr66.93.240.20423
View • Compare • Difference • Source
SEWilco207.195.192.922
View • Compare • Difference • Source
SEWilco207.195.192.920
View • Compare • Difference • Source
spiderr66.93.240.20419
View • Compare • Difference • Source
spiderr66.93.240.20418
View • Compare • Difference • Source
spiderr66.93.240.20417
View • Compare • Difference • Source
spiderr66.93.240.20416
View • Compare • Difference • Source
spiderr66.93.240.20415
View • Compare • Difference • Source
spiderr66.93.240.20414
View • Compare • Difference • Source
spiderr66.93.240.20413
View • Compare • Difference • Source
spiderr66.93.240.20412
View • Compare • Difference • Source
spiderr66.93.240.20411
View • Compare • Difference • Source