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: 241
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