Jump to content

MYSQL Database schemas


Recommended Posts

Hi all! this is more of a general MYSQL Schema discussion but i noticed that PW does a pretty good job of handling flexible objects (pages) by creating a new table for each object property (field).

I was wondering what other options there are out there for storing flexible but efficient objects in MYSQL.

I noticed that Wordpress uses it's wp_postmeta table extensively for storing flexible schema.

Also according to Facebooks engineering there's a simplified schema overview of it's TAO based system that uses MYSQL as it's underlying datastore for it's graph data. (https://www.facebook.com/notes/facebook-engineering/tao-the-power-of-the-graph/10151525983993920)

So as i say i was just curious really as to different setups and indexing options anyone has used to be able to handle flexible objects within MYSQL.

Link to comment
Share on other sites


  • Create New...