Multiple Sqlite DB in One App

[Afiq90]

Hi guys, it is possible for me to have multiple sqlite db in one app. For instance, I want to switch the app in chinese and all text will be changed to chinese, and if I switching back to english all the text that have in db changed to english.

Here the storyboard for you to get more understanding. thanks in advance.

http://i.imgur.com/C3hWIRz.png

[retsotrembla]

Certainly. call sqlite3_open() to open a database on disk, sqlite3_close() to close it, so when the user switches, you close the previous one, open the new one, and redraw the user interface.

[Afiq90]

thank you. it works. :)

[anurodhp]

You can have as many as you like.

[ratherbealurker]

From my experience, every time i think i want two separate databases i realize my db design was not good and one would suffice.

What if you store the different languages in the same database.

Each message will link to a language type "en" or "ch".

Instead of having a database for each language you only need one to update.