Tag Info  New answers tagged   Frankly, I probably wouldn't use
a database in the first place. It doesn't sound like you have
any need for ACID, which is one the main things which databases
provide and which doesn't come cheap in terms of performance.
Nor does it sound like you need complicated indexes. What I
would do (and have done, an awful lot) is just loop over the
files with Perl ...   To answer your question yes I'm sure it is
possible to employ a scheme like jkavalik suggested where you:
Import the entire file into a single column/cell in a temp table
Parse the malformed csv string using increasingly obtuse
trickery as each edge case is discovered. I'm sure a smarter
person than me could write an event driven, real-time, web-
enabled, ...  Top 50 recent answers are included