4 ms·
I get it, you don't have typing control over your data exchange. somebody might send you an unquoted-string CSV with multiple data types in the same column: i
by dekhn 4y ago
I get it, you don't have typing control over your data exchange. somebody might send you an unquoted-string CSV with multiple data types in the same column:
id,location,name
1,90210,Tori Spelling
2,Schitt's Creek,Eugene Levy
and you use sqlite to quickly explore the loaded data to check the set of types used in a column, and maybe even glean what the meaning is.
- ratrocket 4y agoExactly. The thing I'm talking about is necessarily a semi-manual process (data exploration, usually prior to migrating data from one system to another). In the example you give, when you've done all the exploration you need, there's a program interpreting that CSV that ensures the location column values are strings. At least, that's how I do it!