Ionic app with a SQLite database on the device

Hi, I’m new to Ionic/Android development and for learning purposes I would like to build an app that will depend on a database stored on the device. I have some questions before I embark on this journey:

  • am I correct in thinking that if I need the database to be stored on the device (so that the app would work offline) I must use SQLite?
  • my database will be created from csv file with 30.000 rows and 50 columns (and growing). Does it make sense to develop an offline app like this or it would be too big/slow with search related task?

Thank you.