db Structure

I'm considering using FlexiContent for the first time, but I was wondering if someone could explain how component structures its data tables.

For instance, assume I have 3 totally non-related groups of information. Does FC compile all the data into one table(relatively speaking} or can each group get its own table structure?

Thanks.

All tables are shared, it does not create new table for every item type.

We have one table per entity, 1 table for
-- For items FLEXIcontent extended data
-- For item types
-- For versioned data
-- For field values
-- For templates
etc
if you look at the db in phpmyadmin or other tool, of course always avoid manipulating a db schema that you know little about. Anyway with FLEXIcontent you will mostly like never need to manipulate the db directly regards

Thanks for the reply. So to be sure I am clear, and perhaps, I should have asked this in my original post, with Flexi, a site manager can or cannot normalize the database consistent with what is generally considered good data structuring?

Based on your earlier response, it sounds as if the answer is "cannot".

Up to what level would you want to normalize ? 1NF, 2NF, and 3NF 4NF? or more?

I don't understand, you wish to join project, and rewrite the core ?

are you are planing on using FLEXIcontent on site with Nx100.000 of content items?

Regards

dezblanco wrote: Based on your earlier response, it sounds as if the answer is "cannot".

Pretty easy. Donwload FlexiContent, install it, look at the database, look at the code, decide. I honestly cannot understand why you come to this conclusion based on ggppdk's reply. Every component has own data base tables!

Rooney

ggppdk wrote: Up to what level would you want to normalize ? 1NF, 2NF, and 3NF 4NF? or more?

I don't understand, you wish to join project, and rewrite the core ?

are you are planing on using FLEXIcontent on site with Nx100.000 of content items?

Regards

This one made me laugh.
Go George ! ! !


Still chuckling . . .
.

I don't understand, you wish to join project, and rewrite the core ?

No, I'm researching possible options to give a client what they need in the most expeditious and efficient manner as possible.

The project will easily exceed 100,000 items. The project involves updating a music industry catalog and related information.

So while the structure of your component may be normalized, my question had to do with the users data. With every entry that is made on the site, we need to minimize the redundancy(normalization). For example for album data, if users would have to enter the artists name and info with each album submitted, the db is not normalized, because the same information is listed several times. In addition if different types of user data is stored in basically one table, its not normalized. Without mentioning any names, they are quite a few components that function this way.

Thanks for your intelligent response George.

For the peanut gallery... ha-ha very funny. Hmmm lets see, spend 2-4 hours installing a component, figuring out how it works to determine if it does what you need it to do, or spend 10 min. asking the developer? :roll:

From your features page:

Please note that FLEXIcontent allows you to associate a same field to multiple types.

This may work. When I submitted my original post, the Features page would not load for some reason, may have been my connection, thus the question to begin with. Although just now, I went to load it, and had to refresh the page to get it to display.

I look forward to learning more and using Flexi.

dezblanco wrote: For the peanut gallery... ha-ha very funny. Hmmm lets see, spend 2-4 hours installing a component, figuring out how it works to determine if it does what you need it to do, or spend 10 min. asking the developer? :roll:

Well, a project with more than 100.000 items sounds like a whole field of peanut trees...

By the way, I do not know if you have experience with Joomla and if yes what components you are using, but installing FlexiContent in an existing Joomla installation takes less than 10 minutes. Anyway, I am out of this thread.

Rooney

a subjestion
use flexi import to convert your database for flexicontent database ...