mysql: storing arbitrary data

Posted by Hailwood on Stack Overflow See other posts from Stack Overflow or by Hailwood
Published on 2011-01-17T03:45:17Z Indexed on 2011/01/17 3:53 UTC
Read the original article Hit count: 224

Filed under:
|
|
|

Background:
I was asking a question on stack overflow regarding creating tables on the fly where this conversation ensued:

This smells like a terrible idea! In fact, it smells just like this one.
What in the world do you want to use this for? – deceze


@deceze: very true, However, How else would you store the contents of these CSV files.
They must be stored in mysql for indexing. The only solid fact about them is that they all have a mobile column with a standard format.
The CSV can have an arbitrary amount of columns with an arbitrary amount of rows.
They can (with no exaggeration) range from a single row, 35 column csv to an 80k row single column CSV. I am open to other ideas. – Hailwood
There are many solutions for this, from attribute-value schemas to JSON storage and NoSQL storage. Open a new question about it. Whatever you do though, don't dynamically create tables! – deceze

Question:
So my question is, What would you say is the best way to store this data?
Are you in agreement with deceze about not creating dynamic tables?

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql