MYSQL Database schemas

[mrjasongorman]

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.

[adrian]

Just a quick response - you might find this ORM module by teppo interesting.

http://modules.processwire.com/modules/red-bean-php/

[mrjasongorman]

Hey, yeah looks pretty good!