loading big CSV file to SQLITE database

I have a very big CSV file (25 MB) with 90K lines and i am trying to make an Android app that will load this What would be the most efficient way to load it to SQL db? Is that even possible? Any idea how long loading it will take?

Thank you

Answers


If you're looking for a way to ship data with you app you can include a prepopulated db in the apk, which is a much better experience for the users: Ship an application with a database


Need Your Help

Using a this pointer in a generic lambda capture

c++ lambda c++14

I have an issue in which Clang (3.6) and G++ (5.1) have a differing opinion:

Getting Vim to syntax-check boost libraries

vim boost

I am a fairly novice programmer who recently started using boost. After successfully linking the libraries with cmake, I have noticed that my vim (syntastic plugin I think) which does a great job at