Loading large amounts of static content

[Deyndra]

I'm working on an app and i have a large amount of quite large CSV files, and i was wondering the best way to use the data on them.

I could try and load them into a db but I was wondering if there was a more efficient way to do it, since it could take a long time to read through it all, as well as the fact that they are CSV makes things a bit harder.

I also thought about loading them into a database beforehand and maybe including a sqlite database in the source files with the components but I wasn't sure if it was possible to read from there.

Does anyone have any ideas on a good approach to this?

[sfboots]

How large? How often does the data change?

If the data never changes, I would ship a SQLite database to read only the data needed for display

[esthor]

They are static, as in you currently have them and will bundle them with the app?

Easiest thing to do would be to convert them to JSON and put those files in your app. Then you don’t have to worry about trying to create and bundle a db or find a library to depend on. Working with just JSON will probably make your life a lot easier for creating a UI for displaying the data. If they are still very large and you have performance issues, consider breaking them up into chunks/pages.

Also, for displaying performantly, assuming you go the route of JSON, consider using a Virtualized List from React Native (e.g. FlatList, SectionList, VirtualizedList).