What's the best way to store "spreadsheet data" in MySQL
I'm looking to store spreadsheet type data in a mysql database. Basically it would be a grid, with x/y c开发者_开发问答oordinates, and each cell can have various different properties to it.
The grids can be of all different sizes, and I'd like this system to be fast and flexible, though some sort of caching isn't out of the question if necessary.
Finally, a requirement of this project is to use mysql, and a restriction against any document style storage solutions(anything nosql really).
I'm curious if anyone has any sort of standard solution for this that I'm not seeing. I'd like to avoid a big table along the lines of column1_data1 column1_data2 column1_data3 etc etc for however many columns I can safely account for.
Sounds like a job for an Entity-Attribute-Value model
精彩评论