mysql: storing arbitrary data
- by Hailwood
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?
