4

I'm pretty new to swift coding, but I'm working on an app which really needs a database for a large amount of data. I've looked into coredata and it doesn't seem to be what I need. I full database that works with sql statements is really what I'm looking for.

There's plenty of information on the web about setting up an sqlite database within iOS but it looks like things might have changed since Swift 3 and xcode 8 have come out.

I'm not sure how to actually 'connect' to an sqlite database from within the project, all the code I've seen requires a 'path' to the database which is on the computer, but when the app is shipped, users obviously aren't going to be able to access that path. Do you need to create a .sqlite file within the project?

Thanks for your help!

Improve this question

1 Answer 1

Reset to default
2

You surely need some database file, and that database file has a path. Even on iOS.

Now if your application users can modify the database, then it's likely that the database file is stored inside the Documents folder, a special folder that all iOS apps have. Your create a path to a file inside this folder and open the database at that path. SQLite will create an empty database if needed.

If your application users should not modify the database (for an English dictionary app for example), then the database is likely a resource of your application. Resources are files bundled within your application. You ask NSBundle.main for the path of this resource, and open a connection to it.

You can use GRDB.swift library in you need support: https://github.com/groue/GRDB.swift. It supports Swift 2.2 / 2.3 / 3.0.

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.