I'm using FMDB to create a SQLite database on iPhone. I have a initial.sql that is of the form CREATE TABLE Abc ... ; CREATE TABLE Def ... ; I load this by loading the file into an NSString and ...

How can I save NSData into sqlite, I am using FMDB wrapper for saving data. Below is the code which I have tried so far For saving NSData *data = [NSKeyedArchiver archivedDataWithRootObject:mode...

I'm new with iOS Development and i'm also new with SQLITE database. I used FMDB as a wrapper in my project and i have two tables 1) ParticepentsTable and 2) ExerciseTable. ParticepentsTable conta...

I'm using two different types of fmdb connections in my app: FMDatabase for all READ queries and FMDatabaseQueue for all UPDATE queries. Both are handled by a singleton, which keeps both types op...

I'm using FMDatabaseQueue in my iOS application. I'm stuck in understanding how to return the value upon creating the queue. Appreciate your help!! FMDatabaseQueue *queue = [FMDatabaseQueue datab...

When should you close the connection to an SQLite database (using [db close] in FMDB)? Right now I am closing it after running every batch of related queries, but should I rather close when my ap...

I want to use FTS in my iOS project. Through some answers to questions here on SO (like this) and other sources (like this), i understood that i will have to roll out my own built of sqlite3 on iOS...

Hya. I have implemented FMDB in my app. I am trying to get the last row id from one of my databases with this FMDatabase *bdb=[FMDatabase databaseWithPath:databasePath]; NSString *str; if([bdb ...

I am using fmdb for managing my database. I could not find any example for deleting a row from a table in fmdb. I tried NSString *sqlStat=@"DELETE from tableName WHERE id=3"; FMResultSet *rs =...

I am currently developing an iPad application. At one stage, there is a series of sliders and buttons, when you press the button, it stores the value of the slider into a table. First of all, I nee...

I have a set of events which I will have to feed into the database before I ship the app so that the application is ready to read from this database. I have seen some posts like these which explai...

Is there an easy way to get the FMDB results of an executeQuery:SELECT * ... easily into a dictionary? FMResultSet *appointmentResults = [[DataClass getDB] executeQuery:@"SELECT * FROM Appointment...

I am using FMDB, which is a wrapper for SQLite. http://github.com/ccgus/fmdb Here is my query line: FMResultSet *athlete = [db executeQuery:@"SELECT * FROM athletes WHERE athlete_name LIKE ?", se...