Should Android use csv? or better sqlite?

I have a table in excel. I think whether to use csv or better to convert it into sqlite?

Closed due to the fact that it is necessary to reformulate the question so that it was possible to give an objectively correct answer by the participants Yuriy SPb ♦ , Andro , aleksandr barakin , user194374, cheops July 17, '16 at 6:42 .

The question gives rise to endless debates and discussions based not on knowledge, but on opinions. To get an answer, rephrase your question so that it can be given an unambiguously correct answer, or delete the question altogether. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • And what you do not like using the database? The speed of work with it is higher, more reliable and so on. What are your reasons for using csv? - pavel
  • @pavel, they just send me csv from the beginning. And to make db from csv. I have to manually use SqliteBrowser. In the internet I saw ReadCSV or SuperCSV. For direct reading. So I thought. What yes is better. Just as interesting as a pro programmers do in such cases - Andro
  • I would advise using ORM. (Best of all - realm). The number of template code will be reduced. - no news

1 answer 1

It all depends on what you are going to do with the data, if you need the ability to query a sample from a table, often read data, or update individual rows / columns of a table, then it makes sense to use SQLite. If you just need to occasionally read the entire table to a list, it doesn’t filter it when you request it and you will only update the entire table, then there’s no point in bothering using the database.