Add an SQLite database to an iPhone app

by

First of all you need to create your database.
From the command line create your db file.

sqlite3 mydb.db

Then create the tables within your database

CREATE TABLE tags (id int(5), name varchar(255), created_at datetime, updated_at datetime);

Repeat that for any tables that you want in your database.

Then you need to include the database file in your project. Add the existing database file to your project as you would any other existing file.

Next you will have to link in the framework to interact with the database. This can be found under you current iPhone SDK folder.

/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS2.2.sdk/usr/lib/libsqlite3.0.dylib

Finally you have to include the header file sqlite3.h from

/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS2.2.sdk/usr/include/sqlite3.h

It should now be possible to write code to access your sqlite database from within your iPhone application.

More Related Contents:

  1. Best Cocoa/Objective-C Wrapper Library for SQLite on iPhone [closed]
  2. Synchronizing an SQLite client database with a MySQL server database
  3. Tab bar controller inside a navigation controller, or sharing a navigation root view
  4. How to programmatically determine iPhone interface orientation?
  5. Use CoreData or SQLite on iPhone? [closed]
  6. NSTimer doesn’t stop
  7. What are best practices that you use when writing Objective-C and Cocoa? [closed]
  8. Transforming a rectangle image into a quadrilateral using a CATransform3D
  9. Open Source Cocoa/Cocoa-Touch POP3/SMTP library?
  10. Arguments in @selector
  11. How to disable touch input to all views except the top-most view?
  12. What is the use of -[NSUserDefaults registerDefaults:]?
  13. Figure out UIBarButtonItem frame in window?
  14. How do I use CaptiveNetwork to get the current WiFi Hotspot Name
  15. Enabling crash logs symbolication in Xcode 4.2
  16. How to resize a tableHeaderView of a UITableView?
  17. Best radio-button implementation for IOS
  18. HTTPS with NSURLConnection – NSURLErrorServerCertificateUntrusted
  19. Sorting NSString values as if NSInteger using NSSortDescriptor
  20. Bootstrap Server Error in Xcode IPHONE [duplicate]
  21. How do I auto size a UIScrollView to fit its content
  22. UITextField for Phone Number
  23. How is a rounded rect view with transparency done on iphone?
  24. Deactivate UIScrollView decelerating
  25. Offset on UIWindow addSubview
  26. How to get UIMenuController work for a custom view?
  27. sqlite database update when app version changes on Appstore in iPhone
  28. How to handle duplicate symbol error from 3rd party libraries?
  29. How to tint UIBarButtonItem background color? [duplicate]
  30. UISwitch in a UITableView cell

Leave a Comment