Database implementation using SQLite in iOS Applications


SQLite: 
I have worked on Core Data and SQLite both, but i personally feel that using SQLite is a good choice.
Working on Database directly using SQLite is better than working on Core Data which actually works as a wrapper above SQLite.
We can easily fire complex sql queries on Database using SQLite to store, update or fetch data; which is a pathetic job using Core Data. 

 Below is a simple demo app which will help you understand how to use SQLite to create database, store, update, fetch and delete records from database.

 For using SQLite database in iPhone, iPad App first you need to link libsqlite3.0.dylib to your build target. 
To do this select 'Project' at top left navigation panel -> 'under Targets' select your build target -> then click on 'Build Phases' tab -> then in 'Link Binary With Libraries' click on '+' button and add libsqlite3.0.dylib.



 There are number of C functions contained within the libsqlite3.dylib library which can be used for sqlite implementation.

 1. sqlite3_open() - This function is used to opens database. In case database does not exist, it creates one.
2. sqlite3_prepare_v2() – This function is used to prepares a SQL statement for execution.
3. sqlite3_step() – This function is used to executes a SQL statement previously prepared by the sqlite3_prepare_v2() function.
4. sqlite3_column_<type>() – This function is used to returns a data field from the results of a SQL retrieval operation. Where <type> is the type of the data to be extracted (int, text, blob, bytes, etc).
5. sqlite3_finalize() - This function is used delete a previously prepared SQL statement.
6. sqlite3_exec() – This function is used combine the functionality of sqlite3_prepare_v2(), sqlite3_step() and sqlite3_finalize() into a single function call.
7. sqlite3_close() – This function is used to close a database file previously opened.
Below is the code snippet for using sqlite implementation:

 In header file:

 In implementation file:





In xib file:
Here is the sample code: SQLITE_CODE

Comments

  1. Unknown20 August 2014 at 12:37

    Create your SQL statements using [NSString stringWithFormat] makes the app vulnerable to SQL Injection attacks. Use bind variables instead.

    ReplyDelete

Post a Comment

Popular posts from this blog

payUmoney Payment Gateway Integration in iOS App (Objective C)

Image
We have many Payment Gateways available such as Paypal , CCAvenue , Zaakpay , etc. payUmoney is the best Payment Gateway available in India now; according to me. I am saying this with my personal experience with  payUmoney  Technical Support Team. They offer 2.9% Transaction charges without any Enrolment, Setup, AMC or other Hidden charges. payUmoney Home Page Link:  Home_Page payUmoney Contact Details:  Address:   5th Floor, Pearl Towers Plot 51, Sector 32 Gurgaon, 122002  Phone:   0124-6624956,  0124-6624970  Email:   techsupport@payumoney.com Steps to integrate payUmoney gateway: 1. Create a new iOS Objective C app in XCode. 2. Open Main.storyboard in you app. 3. Add UIWebView and set its Delegate. [Screenshot 1] 4. Set Frames & Constraints as per design requirements. 5. Link UIWebView by creating IBOutlet to either .h or .m file. [Screenshot 2] 6. Signup ...
Read more

UITableView - Add or Remove Rows Dynamically (Objective C & Swift Source codes)

Image
In some situations we need to add or remove rows dynamically from a UITableView. We can achieve it very easily, just got through the tutorial : 1. Create a new project. 2.  In AppDelegate implementation file create an object of UINavigationController (navController here). 3. Add object of UIViewController (viewController here) as rootviewcontroller of UINavigationController. 4. In ViewController.xib nib file take a UITableView. 5. Set delegate and datasource of UITableView to File's Owner. 6. Create an IBOutlet to UITableView (tableViewForScreen here) in ViewControler.h header file. 7. Declare an object of NSMutableArray (arrayForTableContent here) in ViewControler.h header file. 8. In ViewController.m file in viewDidLoad method set edit and add buttons as leftBarButtonItem and rightBarButtonItem respectively. 9. Initialize arrayForTableContent array and add objects to it. ...
Read more

Check Internet Connectivity Using AFNetworking 2.0

I have created  NetworkRechabilityMonitor class to get the Internet Connection status in my app using AFNetworking 2.0 library. 1. Create an NSObject class naming  NetworkRechabilityMonitor , add below code in respective Header & Implementation files.   NetworkRechabilityMonitor.h #import <Foundation/Foundation.h> @interface NetworkRechabilityMonitor : NSObject +( void )startNetworkReachabilityMonitoring; +( BOOL )checkNetworkStatus; @end NetworkRechabilityMonitor.m #import "NetworkRechabilityMonitor.h" @implementation NetworkRechabilityMonitor #pragma mark - Start Monitoring Network Manager +( void )startNetworkReachabilityMonitoring {     [[ AFNetworkReachabilityManager sharedManager ] startMonitoring ]; } #pragma mark - Check Internet Network Status +( BOOL )checkNetworkStatus {     return [ AFNetworkReachabilityManager sharedManager ]. reachable ; } ...
Read more