Xcode Swift use of .db database in project

Question

I have a database with the db extension(file.db) I have to use in my iOS project. I have to read from it, not write anything in it.

My question is: can I use it like this, or does it have to have the extension .sqlite?(I have found examples with this one) My other question: do I have to use CoreData in my project in order to access this db database or is there no need for CoreData?

Thank you.

PS: any tutorial regarding using db databases in iOS Swift is welcomed. I have found many, but nothing exactly on this.

You have tagged the question with [sqlite]. Does that mean that "file.db" is a SQLite datebase? — Martin R
– Martin R, Commented Apr 6, 2017 at 7:52
You won't be able to use Core Data directly with your SQLite DB. Core Data requires a specific undocumented table structure, which your file won't match. I haven't used it in a while, but FMDB is a solid project for SQLite on iOS. — Dave Weston
– Dave Weston, Commented Apr 7, 2017 at 4:38

CL. · Accepted Answer · 2017-04-06 07:48:02Z

1

SQLite does not care about the file name. (But humans might.)

Core Data is a framework on top of SQLite, but you certainly can access the SQLite library directly. Whether to use Core Data or not depends on what API would fit your DB operations better.

answered Apr 6, 2017 at 7:48

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Xcode Swift use of .db database in project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related