Skip to main content

Where"s the best SQLite 3 tutorial for iPhone-SDK?



I'm looking for an complete tutorial which not just tells me how an query is executed, but also how I set up the whole thing including setting up the library, creating an database, and so on.





Where can I find it?



Source: Tips4all

Comments

  1. Using SQLite 3 on the iPhone is really not that different from using it on any other platform. You should read the general SQLite documentation.

    In your iPhone app, you usually open your SQLite database in the applicationDidFinishLaunching: method of your application delegate. After that, you can just use your database.

    I've used Gus Mueller's FMDatabase classes on the iPhone. They provide a thin wrapper around SQLite.

    A final note: It seems CoreData will become available on the iPhone with OS version 3. You can use SQLite through the CoreData framework.

    ReplyDelete
  2. Take a look at this book:

    Beginning iPhone Development: Exploring the iPhone SDK by Dave Mark (Nov, 2008)

    There is a section dedicated to SQLite.

    ReplyDelete
  3. I really like the tutorials from:

    http://www.iphonesdkarticles.com/search/label/SQLite

    it should get you started in no-time.

    ReplyDelete
  4. Stanfords cs193p iPhone application development previous semester showed how to setup and use sqlite3 with iphone.

    I haven't checked the latest lecture's but there is a reference to sqlite in latest semester. There are lecture notes and video in iTunesU - check out cs193p web site for links/references/example code/lecture notes.

    ReplyDelete
  5. iCodeBlog's has got a very well written tutorial on SQLite 3 as well.. Check out the first part at iPhone Programming Tutorial – Creating a ToDo List Using SQLite Part 1.

    ReplyDelete
  6. Apart from Peter Quade's excellent answer, may I also suggest you to check out http://www.iphonekicks.com/tags/SQLite - here you would find many bookmarks to SQLite topics.

    And just FYI, iPhone Kicks is a social book marking site, a Digg clone but purely for the iPhone SDK links :-)

    ReplyDelete
  7. I have some iPhone SQLite links in my Delicious bookmarks. There should be enough links there to teach you all the SQLite you will ever need. Lots of the tutorials are pretty simple and easy to understand. There are a few wrappers out there too. I haven't used any of the wrappers, but they look interesting. Also, check out other bookmarked items tagged SQLite on Delicious.

    ReplyDelete

Post a Comment

Popular posts from this blog

Slow Android emulator

I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?

CCNA 3 Final Exam => latest version

1 . Which security protocol or measure would provide the greatest protection for a wireless LAN? WPA2 cloaking SSIDs shared WEP key MAC address filtering   2 . Refer to the exhibit. All trunk links are operational and all VLANs are allowed on all trunk links. An ARP request is sent by computer 5. Which device or devices will receive this message? only computer 4 computer 3 and RTR-A computer 4 and RTR-A computer 1, computer 2, computer 4, and RTR-A computer 1, computer 2, computer 3, computer 4, and RTR-A all of the computers and the router   3 . Refer to the exhibit. Hosts A and B, connected to hub HB1, attempt to transmit a frame at the same time but a collision occurs. Which hosts will receive the collision jamming signal? only hosts A and B only hosts A, B, and C only hosts A, B, C, and D only hosts A, B, C, and E   4 . Refer to the exhibit. Router RA receives a packet with a source address of 192.168.1.65 and a destination address of 192.168.1.161...