Converting CSV files to sqlite
Sometimes we only have huge number of .csv files. To load these files into memory can take some time.
Even if you decide to load it with some spreadsheet software such as Excel, there are limitations. First of all, your system will notice a surge in RAM consumption and running applications will take a hit. The maximum number of rows Excel can handle is 1,048,576. Imagine loading 10 such files at once!