开发者

Dynamic DB storage based on unknown result from source

开发者 https://www.devze.com 2023-01-14 11:12 出处:网络
I have a source of data that I get from a webService. I开发者_Python百科 can never know when it\'ll change and I need to store it in a DB as soon as I get it. What is the best way to make the storage

I have a source of data that I get from a webService. I开发者_Python百科 can never know when it'll change and I need to store it in a DB as soon as I get it. What is the best way to make the storage solution adapt to what I put there. I am using mySQL. Would serialization be the key?


I would store the context in a column using the TEXT data type, and consider MEDIUMTEXT or LONGTEXT if the content is over 4000 characters. MySQL 5.1 has XML functionality to get values out of the XML payload...

Ideally, I'd consume the webservice and populate tables appropriately.

0

精彩评论

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

关注公众号