开发者

What's the best way to store "spreadsheet data" in MySQL

开发者 https://www.devze.com 2023-03-16 11:07 出处:网络
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.

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

精彩评论

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