Database Store Topics

This topic will serve as an index for topics discussing database storage for TWiki 5.0

There are 100s of documents on Codev that contains the word "database". Some are old and not relevant some are good inspiration and some are hot and new. If you add more please provide a one-liner what it is.

Old but still relevant

• AddDBMFileHandling - a good idea to learn from where it is suggested to use DBM Files for the User Database
• DBIStoreInterface - short but good message about implementing storage in DB also creates new problems
• PerlDBI - another DBI discussion
• ExtractingTopicDataToADatabase - gives a good reminder of other requirements of DB storage than just gaining performance
• HowToUseFormsforDBApp - again a topic to remind us that some people may see the DB itself as a feature
• MetadataSucks - discuss putting meta data incl form data in a database.
• DatabaseForMETA - also discuss putting meta data incl form data in a database.
• DatabaseForPreferences - discuss prefs in DB and also some experience that tell us how we should not do it
• DatabaseForAccessControl - discuss the access controls in DB

Hot and/or newer

• DatabaseStore - a feature proposal topic on the subject
• MultiStoreRefactor - an accepted feature proposal which contains important technical backgroud info related to the technical implementation of DB store.
• PluggableAccessControlImplementation - is worth taking into account when we talk the DB part handing access controls.
• TWikiCommunitySummit2008Q1 - contains minutes related to roadmap and DB storage
• TWikiCommunitySummitBerlin2008Q3 - next Summit where Kenneth would like some one hour session on this subject
• TWikiRoadMapDiscussionFiveDotZero - a roadmap discussion topic written in January 2007 but content is 100% relevant and with a good follow up discussion
• TopicObjectModel - when you discuss DB storage is it difficult not also to consider this old but still highly relevant wish.

To be written

Kenneth suggests these new topics. He willk start them all with an intro what they are meant as. It will take some days before these get created - especially because I will be travelling back to Denmark the next 1.5 days.

• WhyWeNeedDatabaseStorage - A list of the problems we try to solve with a DB storage modela
• WhyWeNeedTxtFiles - A list of arguments why not to give up on .txt files totally
• RequirementsDatabaseStorage - A list of short sections describing the requirements for the DB storage as we collect them from the community
• DatabaseStorageArchitecture - A topic that describes at high level how the DB store will be implemented
• DatabaseStorageUsers - A topic that describes how the user database will be implemented
• DatabaseStorageAccessRights - A topic that describes how the access rights to topics and webs are stored
• DatabaseStorageFormData - A topic that describes how the form data stored in topics will be stored including how the databases will be designed to allow the complex combinations of many different form definisions that can be created as a TWiki installation developes and still build indexes that can be searched.
• DatabaseStorageTopicContent - How to store the actual content of topics in databases. Prepare for TopicObjectModel
• DatabaseStorageMetaData - How to store the non-form meta data such as date edited, author, revision etc to allow for fast sorting by date and search by author. Also consider that plugins define meta
• DatabaseStoragePreferences - How to store the preferences that are today defined in configure, misc preferences topics, user topics and in individual topics. Should it be on its own or integrated with meta data?
• DatabaseStorageAttachments - How to handle attachments

Summit 2008 Q3 related

• TWikiCommunitySummitBerlin2008Q3DatabaseStorageDiscussion - A place holder where we can prepare specifics where face to face can be a help to brainstorm ideas as a suplement to the Codev discussion.

-- Contributors: KennethLavrsen - 18 Aug 2008

Discussion