I need to extract data entries from a server-based sqlite database into different objects in my project. I have only been able to find tutorials and write-ups on how to feed data to a Table View through a local database.
- Say the database has 5 rows, each with 10 columns. How do I take the text from e.g. column 3, row 5 and make it show in a UILabel, and other content to show up in another UILabel?
- The database will be very small. We're talking a few KB. Is is possible to extract data from a sqlite database directly from the server?
- If #2 is not possible, how do I download and overwrite the existing database in the app's sandbox?
- For both #2 and #3, can I set specific days and timestamps for when to update the content in the views, so a new database is not download on every time the app is loaded?
Any links/tutorials/advice/code examples you have will be of much use to me