Using pre constructed sqlite database inside iOS app

Question

I need to include a sqlite database in my app (pre-made) and make changes further into it as the app is used. So my question is, is there any way to include a pre populated sqlite DB in the app's working environment and then use the native sqlite framework to edit/update/delete data from it ?

Some tutorial references for this will be appreciated.

@ElTomato i already did. Not to waste time, can we get an answer ? — Pulkit Sharma
– Pulkit Sharma, Commented Mar 13, 2016 at 13:39

Pulkit Sharma · Accepted Answer · 2016-03-14 05:28:10Z

1

I was looking for something like this Sqlite. Although it isn't upto the mark as i needed a tool or something for easily creating a large DB which i could later embed in my app. But still this tutorial does clear away some confusion.

P.S. there is a tool which you can use to view your DB. I don't believe we can edit a DB using it. Its called SQLite Client. Its available on the app store.

edited Mar 14, 2016 at 5:28

answered Mar 14, 2016 at 4:54

Pulkit Sharma

5551 gold badge6 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RJV Kumar · Accepted Answer · 2016-03-14 06:23:13Z

0

Yes, you can include pre-populated SQLite file in your app.

Steps to include sqlite

Drag and drop the sqlite file(with the data) to the app bundle. Add the framework libsqlite3.dylib
Using NSFileManager, copy the file to documents directory to modify the sqlite data.
Then do your changes using sql queries.

Refer this link for more details->Sqlite tutorial

answered Mar 14, 2016 at 6:23

RJV Kumar

2,4081 gold badge21 silver badges28 bronze badges

Collectives™ on Stack Overflow

Using pre constructed sqlite database inside iOS app

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related