Creating simple database for iOS application

Question

I'm planing to create an app for iOS which will be kind of informative application for public transport in my city. People will enter street name from where they want to get public transport and will get list of buses and minivans, which are traveling by that street.

My problem is that I'm just started developing for iOS and want to find easy method to create a database/table with simple information as streets name and bus numbers that will connected with those streets.

So basically I need to create database/table and an search-box which will be connected to that database.

From where I need to start? Thanks.

p.s. - sorry for my bad english ;)

One important question: Will this database be solely on the phone, solely on a web server, or some sort of "hybrid"? Another question: How will the database be updated, and who will do the updating? — Hot Licks
– Hot Licks, Commented Mar 2, 2014 at 15:10

Bryan · Accepted Answer · 2014-03-02 15:06:42Z

2

SQLite is quite popular and supplied by Apple. This lets you manage your table, and allows most standard SQL queries. You can also link to Core Data if you want to treat your data as objects.

See the Apple overview

There are many tutorials to build a simple app with a table view using SQLite, e.g. here or here

I found the Stanford University videos a good way to learn this stuff, e.g. here on YouTube or there are later versions available in iTunes U.

edited Mar 2, 2014 at 15:06

answered Mar 2, 2014 at 14:50

Bryan

12.4k5 gold badges57 silver badges79 bronze badges

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

Comments

Hot Licks · Accepted Answer · 2014-03-02 15:15:34Z

0

Yep, for an on-phone database SQLite is the way to go for a full-featured database, or Core Data if you want some "hand holding". And, of course, if you don't need persistence you can make a pretty good database simply using NSMutableDictionary and maybe a few custom classes.

answered Mar 2, 2014 at 15:15

Hot Licks

47.8k19 gold badges96 silver badges156 bronze badges

Comments

Damouse · Accepted Answer · 2014-03-02 16:31:21Z

0

Learn to use CoreData. Its not there to "hand hold" you, its there to provide a complex and optimized ORM interface for the underlying SQLite database-- there are a number of optimizations implemented to improve efficiency. You could pick it up in a night following tutorials and online instructions.

answered Mar 2, 2014 at 16:31

Damouse

611 silver badge6 bronze badges

Collectives™ on Stack Overflow

Creating simple database for iOS application

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related