db Structure

More
12 years 4 months ago #21195 by dezblanco
db Structure was created by dezblanco
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.

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #21205 by ggppdk
Replied by ggppdk on topic db Structure
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


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #21222 by dezblanco
Replied by dezblanco on topic db Structure
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".

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #21223 by ggppdk
Replied by ggppdk on topic db Structure
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


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #21226 by Rooney
Replied by Rooney on topic db Structure

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

Joomla! 3.9.24 and FC 3.3.9

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #21236 by kenmcd
Replied by kenmcd on topic db Structure

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 ! ! !
:D

Still chuckling . . .
.

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.294 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline