How to access my existing SQLite database in swift 3

Question

I have a small database in SQLite (1 table, 3 columns, 61 rows) and I want to present it in the app inside a Tableview for read only.

I'v already imported FMDB and created the bridging-header but i have no idea where to go from here. My database sit in my server so if that cause any problem i don't mind to embed it in the app. I need to know how to get the app to recognize the database and how to get the data from the database.

If someone could guide me to the right way or refer me to a step-by-step tutorial that would be highly appreciate and a great help. Thank you all.

Nikita Patskov · Accepted Answer · 2016-11-06 13:12:34Z

1

If this database is immutable, best solution is put it to the app resources. But if u want to change data u should use HTTP requests to get data. You must teach your server recognize that requests from user devices. Look that: Server-side 1) HTTP protocols 2) JSON (JSON rpc) 2) PHP/Python

Client-side: 1) URL requests 2) JSON libraries (Swifty JSON, etc.)

answered Nov 6, 2016 at 13:12

Nikita Patskov

4573 silver badges7 bronze badges

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

1 Comment

Tom G Over a year ago

thank you, I think for now i'll just put it in the app resources seems to me the easiest way

Collectives™ on Stack Overflow

How to access my existing SQLite database in swift 3

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related