How FMDB makes sqlite more simpler iOS?

i want to use fmdb in my iPhone application. What are the differences in using sqlite with fmdb without fmdb?

i need to be able to write queries.

how the fmdb is easier/effecient to use than single sqlite? if there is any source code or guide to it please post its link

-------------Problems Reply------------

FMDB is a wrapper on top of SQLite's C API with an API more in Objective-C style. Which API style is "easier" is more up to you, it would depend greatly on your programming background and personal preference.

There's a guide showing how to use FMDB at its GitHub page which shows the API off pretty well, you should definitely read that before deciding.

It should also be noted that the author of sqlite (D. Richard Hipp) never intended the sqlite api to be used directly by programmers. The idea was to create a low level API that higher level wrappers would use inside their applications (and I think that's largely why we see sqlite in just about everything these days!).

So even if you don't use FMDB, you should find another wrapper around SQLite. Your life will be easier in the long run.

Category:objective c Views:0 Time:2012-03-11

Related post

  • How Should I Secure a SQLite Database in iOS? 2010-11-27

    I'm developing a healthcare iOS app. I'd like my users' data to be encrypted so if their iPhone is stolen, the thief won't be able to access their health info. The rightful owner SHOULD be able to access their information (so different than this ques

  • Is SQLite built into iOS? 2011-06-01

    I have created a application which uses Sqlite database. Now i wanted to deploy the application on iPhone and iPad. I wanted to know whether the Sqlite is inbuilt or not in iPhone/iPad device? --------------Solutions------------- Yes, iOS includes th

  • How to overwrite a SQLite DB in iOS when a new version of app is released 2011-06-15

    I have an iOS app that uses a SQLite DB to store its data model. The user cannot change the contents of this DB in any way. The only way contents of the DB will change is when I add more content in future app updates. (The app never writes content to

  • Improve performance of Sqlite DB on iOS by defining indexes? 2011-02-25

    My table represents a hierarchical structure with following columns: int ID (PK, unique, not null) int ParentID int MasterID (not null) smallint Type (not null) varchar(255) Name I need to query this DB by: Getting one entry via ID Getting all childr

  • I cannot get the staffs from the SQLIte DB to iOS table view 2011-06-21

    I am stuck in iOS application that works on SQLite. I have created a Coffee table with different types of coffee names and prices along with the coffee ID which acts as the primary key. In SQLite I could run the SQL queries and got the correct answer

  • Protect an sqlite file on IOS 2011-06-23

    I have some data I’ve spent months collecting, cleaning and structuring. The app I'm building will be able to search the data. So far I'm storing the sqlite file in the users filesystem and not on a remote server because I want the search result to b

  • What tools & libraries to use for building a simple iOS and Android app using web technologies? 2011-08-23

    I would like to create a mobile app for iPhone, iPad and Android (don't need other platforms for now). I am a web developer, so building something using web technologies is great, but the end result must also be as native like as possible (the user s

  • Web-based back-end for simple iOS app? 2011-11-19

    I made my first (super trivial) iOS application on a plane ride home last night. If any of you have ever read iOS Programming, it's the first one in there. Basically, it's a quiz app - there are two buttons and two labels. The first label is a questi

  • How can I speed up or optimize this SQLite query for iOS? 2012-02-02

    I have a pretty simple DB structure. I have 12 columns in a single table, most are varchar(<50), with about 8500 rows. When I perform the following query on an iPhone 4, I've been averaging 2.5-3 seconds for results: SELECT * FROM names ORDER BY n

  • sqlite fetching on ios device slow but fast on simulator 2012-02-29

    I have a database with 3 tables having 700000 records each. I have added a search feature in the app which uses query... const char *sqlstatement="select * from artist where name like ?"; sqlite3_stmt *compliedstatement; if(sqlite3_prepare_v2(databas

  • How to Convert using of SQLite to Simple SQL command in C# 2010-04-04

    I want to get start with DayPilot control I do not use SQLite and this control documented based on SQLite. I want to use SQL instead of SQLite so if you can, please do this for me. main site with samples

  • SQLite wrapper in iOS? 2011-04-26

    I have an iPhone app that stores information to a SQLite database. It works splendid on my phone as well as my brothers. Stuff get's written to it and it can read from it. However, when running it on other people's phone's, it just crashes. Why? I am

  • How to take a picture and save in SQLite database on iOS 2011-05-31

    I have a camera application in which when I click on the camera button the camera opens and user can take picture from camera or from photo-library. I have done the camera part such that when user clicks on the button the camera opens and he can take

  • Simple iOS layer subclass doesn't position right 2011-06-06

    What appears when I run this thing is a little off on positioning. It is a simple CALayer subclass with a drawInContext function and positioning it in the view controller. When I create the layer and add it, it is done with this code in the controlle

  • Multiple SQLite Queries on iOS 2011-08-28

    I have more than 3 views. My database looks like this: Category: CatID | CatTitle ---------------- 1 | XYZ 2 | Sample Content: ItemID | ItemCatID | ItemText | ItemText2 | ItemText3 | ItemText4 ---------------------------------------------------------

  • sqlite query in iOS 5 2012-02-17

    We have the following query to fetch some programs from a channel guide based on whether they lie between certain date and time: SELECT TITLE,duration, start_time FROM guide where (start_time between '2012-02-17 09:00:00.0' and '2012-02-17 11:30:00.0

  • Simple ios animation: rotate window and reverse 2012-02-22

    I'm trying to perform a simple animation using Cocoa. One button causes an image to flip over its y-axis when pressed, and then flip back when pressed again. The other button should cause the window to flip over its x-axis and back the same way. The

  • SQLCIPHER sqlite encrypted iphone ios converting un-encrypted database to encrypted database 2012-04-11

    I know that there are a few postings on this, but just want to make sure there is something that I am not missing / current. Using sqlcipher, with an unencrypted database, want to encrypt it. Encrypting a new database is working fine. Am trying the s

  • How to Retrive and Store NSArray from sqlite DB in iOS 2013-05-03

    I have an array itemQtyArray which i am storing in SQLITE table As: NSData *toData = [NSKeyedArchiver archivedDataWithRootObject:self.itemQtyArray]; NSString *insertSQL = [NSString stringWithFormat: @"INSERT INTO ORDERTABLE(ITEMDESC,ITEMQTY)VALUES( \

Copyright (C), All Rights Reserved.

processed in 0.098 (s). 11 q(s)