Storing reading data

[barx]

Hi everyone,
I'm wanting to store multiple table of information. They don't need to be writeable, they are just lookup tables. Been thinking and reading up what would be best way to store them. First thought file readmap and writemap, But now thinking of using DBUtils and storing in a database. This leaves me with 2 questions. I will continue to read up on this and may eventually answer my own questions, But thought I would post here as well.

1) Is there a way to build the database on pc then add to project?

2) Would this be the best way to achieve my goal.

Most of the tables are 2d and not just key - value pairs. This is what put me off ReadMap / WriteMap.

Thanks

 

[Erel]

There are many SQLite tools available for Windows. You can then add the database to your project and use DBUtils.CopyFromAssetsFolder to copy the database if needed (it is not possible to open the database directly from the assets folder).

I think that this is the best option.

 

[barx]

Cheers Erel.
My questions may appear simple. But the answers are much appreciated.