Store JSON data as Text in MySQL -

this more of concept/database architecture related question. in order maintain data consistency, instead of nosql data store, i'm storing json objects strings/text in mysql. mysql row this

id, time_stamp, data 

i'll store json data in data field. won't updating rows, instead i'll add new rows current time stamp. so, when want latest data fetch row max(timestamp). i'm using tornado python mysqldb driver primary backend application.

i find approach straight forward , less prone errors. json objects simple , not nested heavily.

is approach fundamentally wrong ? there issues storing json data text in mysql or should use file system based storage such hdfs. please let me know.

mysql, know, relational database manager. designed being used in way data related each other through keys, forming relations can used yield complex retrieval of data. method technically work (and quite fast), (based on i've seen far) considerably impair possibility of leveraging technology you're using, should expand complexity of scope!

i recommend use database redis or mongodb designed document storage rather relational architectures.

that said, if find approach works fine you're building, go ahead. might face blockers ahead if want add complexity solution either way, you'll learn new! luck!