开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜