Databases
StackOverflow2013
Postsdbo
POUse CMS for Relational Data management?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUse CMS for Relational Data management?
    primarykey
    data
    text
    <p>Should one use a CMS (Such as Joomla or Wordpress for example) to enable displaying, categorization, searches and manipulation of data etc.? </p> <p>I have ha need to create a solution for taking an excel sheet online with basic relations between data for example Country -> Project -> Info, Project -> Project participants. </p> <p>Very basic, maintenance by non develop people necessary hence my investigation of a CMS. </p> <p>I have tried to investigate and compare different CMS but most exemplify by showing static content pages like small business, bloggs or wiki site. I use to develop Java MVC and SQL databases but I believe custom made is over kill and not the right way to go in this case. </p> <p>I would very much appreciate examples of sites using CMS this way, suggested CMSs or other suggested solutions. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEL Yusubov
    1. USdjcj
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COOne of the main benefits of relational databases is not just the storage of data but the maintaining of the relationships between that data, which I don't believe CMS systems generally do. The closest database analogy may be a document database, where a CMS basically stores a schema-less set of content which you'd define. But even that analogy is a bit of a stretch, because any database is going to have more structure than a system that pretty much just holds a string of formatted displayable content. In short, I wouldn't think that a CMS is the tool for this part of the job.
      singulars
      1. POUse CMS for Relational Data management?
      1. USDavid
    2. COok, I was hoping that I could somehow categorize my CMS articles/data/info. I would then have a country category and then under the country category have a project category and a user can then add a new project or country. Under that project add info & project particiapants. The relationship in the CMS would be very linear but I would be able to define relationships so that when searching for example a project participant I would see that he/she is working in projects in multiple countries. It feels like it should be possible to at least have hierarchical categorization!?
      singulars
      1. POUse CMS for Relational Data management?
      1. USdjcj
    3. COHierarchical categories should definitely be possible. You're mainly just going to be missing any referential integrity between the data entities. You also may run into a lot of data being "stringly typed" instead of strongly typed as well. If that's ok, then no big deal.
      singulars
      1. POUse CMS for Relational Data management?
      1. USDavid
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload