CODEWITHSUNDEEP
database-designcontent-management-system
Smith
Smith

Reputation: 3164

How to approach building a versioning system for a custom CMS?

I am very interested in how to approach building a database schema that would allow a CMS/SharePoint type version control for the data.

Unfortunately, I am having a hell of a time finding and informative articles on the matter.

What I would like to learn are good approaches that can scale well as the DB schema grows more complex.

I mean, is it really as simple as just adding a version column to each table?

Any help would be greatly appreciated.

Upvotes: 0

Views: 260

Answers (1)

Fabio Poloni
Fabio Poloni

Reputation: 8371

The simplest solution is with an additional column version in each table which is part of your primary key.

You can also build something more complex or use a database which already does the work for you (e.g. Apache CouchDB).

Upvotes: 1

Related Questions