Stack Overflow
Stack Overflow

Questions tagged [fmdb]

FMDB is a free, third-party Objective-C wrapper for SQLite, providing a simple, object-oriented interface for Mac OS X and iOS.

FMDB is a free, third-party Objective-C wrapper for SQLite, providing a simple, object-oriented interface for Mac OS X and iOS. FMDB isolates the Objective-C developer from the SQLite C interface and greatly simplifies the process of writing code that interacts with SQLite databases.

FMDB was developed by August "Gus" Mueller and is provided the public free of charge for use without restriction. See the LICENSE.

References

677 questions
0
votes
1 answer

FMDB using online database?

I use FMDB to speak with the database from my app, and now I would like to put this database online so it will be possible to access it anywhere. I found lot of ways, but nothing really interesting, and always very confusing. Is there any easy way…
user1183716
  • 13
  • 3
0
votes
1 answer

EXC_BAD_ACCESS on inserting

I'm using FMDatabase to operate on an sqlite3 database. Here's my code: NSString *dbFilePath = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0] stringByAppendingPathComponent:[NSString…
beyondbo
  • 91
  • 5
0
votes
1 answer

xcode database with fmdbdatabase error

i am trying to develop a simple application that shows names from a database made in sqlite3. It returns an error: 2012-08-21 21:10:43.182 NameDatabase[1325:c07] Assertion failure in -[UITableView _createPreparedCellForGlobalRow:withIndexPath:];…
uba2012
  • 373
  • 1
  • 3
  • 14
0
votes
1 answer

Insert all tables from one database to another database

I've seen code to insert data from one table to another once you attach the database like in this post: SQLite on iOS - SQL to copy from one file to another However, I don't want to be table specific. I just want to grab all the data from one…
Crystal
  • 28,460
  • 62
  • 219
  • 393
0
votes
1 answer

iOS FMDB Sqlite wrapper. Out of memory

The following code : -(NSArray *)getContentsWithContextTypes:(NSArray *)contextTypes contextData:(NSArray *)contextData { __block NSString *query = @"SELECT * FROM Texts_original1 WHERE "; [contextData…
foFox
  • 1,124
  • 1
  • 14
  • 24
0
votes
3 answers

Inserting a data into SQLite (using FMDB) doesn't work on device?

I am a newbie here. I am not able to insert any data into my SQLite database when running on my device. I am using the below piece of code to connect SQLite. It works perfect in my simulator but doesn't work on my iPad device. Can anyone help…
GenieWanted
  • 4,473
  • 4
  • 24
  • 35
0
votes
0 answers

FMDB, GCD vs NSOperationQueue

I have a lot of data I need to insert in a two tables for my sqlite database. I want to put this work in the background. My flow basically goes like this: (pseudocode) while (files in database are not parsed) { if (fileType == type1) { …
Crystal
  • 28,460
  • 62
  • 219
  • 393
0
votes
1 answer

Crashes possibly involving FMDB likely due to memory corruption

I'm testing on the iOS simulator involving the FMDB distributed along with the MapBox iOS SDK. Here is a bug I can't catch and I wonder if I am breaking some FMDB rules I do not know or I'm having serious memory corruption somewhere (but I've…
huggie
  • 17,587
  • 27
  • 82
  • 139
0
votes
2 answers

Inserting data into FMDB crashes on device, most memory efficient way to insert data into sqlite

I have A LOT of rows that need to be inserted into a database. I download about 50 .txt files that are tab delimited with the information I need. I parse the data and insert it into the database in the same method. When I had it as separate…
Crystal
  • 28,460
  • 62
  • 219
  • 393
0
votes
1 answer

Objective-c inserting data with iphone 4s

I've made an app in which im using an sqlite database with fmdb wrapper for inserting and consulting data, the data is displayed into a table view, the problem is that when i run the app on an iphone 4 everything works well, but when i do it on an…
Cazz Brunestud
  • 96
  • 1
  • 8
0
votes
2 answers

Anybody have any luck getting FMDB to work with Rubymotion?

I'm trying to get FMDB to work with Rubymotion but every time I try to build the app I get this error: FMDBTest(master):rake Build ./build/iPhoneSimulator-5.1-Development Build vendor/Pods Link…
bodacious
  • 6,608
  • 9
  • 45
  • 74
0
votes
1 answer

How can I use the SQL IN operator with FMDB for iOS

I've been trying to get the IN operator to work with FMDB but have had zero luck. I've tried many different google searches and the only relevant post I found was on Stack Overflow but it is returning 0 records. Passing an array to sqlite WHERE…
user684360
  • 47
  • 1
  • 6
0
votes
2 answers

Don't know how to encrypt database using SQLCipher

I have included SQLCipher into my project exactly like explained in this link: http://sqlcipher.net/ios-tutorial/ But I am not sure how to encrypt the database I have read description from above link but not getting. Actually what I am doing is if…
Iducool
  • 3,543
  • 2
  • 24
  • 45
0
votes
1 answer

FMDB: Where does the iPhone simulator store Desktop SQL files?

I am trying to connect to an SQL Database with FMDB that is on my development machine desktop. I can open it from sqlite3 from a terminal and it has the data in it. When I try and use this code from Cocoa I get an "error opening!: 14" NSArray *paths…
Edward Hasted
  • 3,201
  • 8
  • 30
  • 48
0
votes
2 answers

How to use SQLite in iPhone?

Am new to SQLite using in iPhone. I have used google and got some information regarding SQLite for iPhone. I have downloaded the sample source code from here. I have added the code to create table like below, database = [FMDatabase…
Gopinath
  • 5,392
  • 21
  • 64
  • 97
1 2 3
…
45 46