FMDB for iPhone

Link: 06/03/2008 07:03 PM 23 comments

I just tried compiling my FMDB SQLite wrappers against the iPhone SDK, and hey- it seems to work!

These are the classes I use in VoodooPad, so they are pretty solid in my experience (although I do use a custom build of sqlite against it). And since CoreData isn't availble on the iPhone, I figure developers might find these classes useful.

For how it's used, check out the fmdb.m file, and you can also download the entire archive. And if you have any bug fixes or ideas, send em along.

On Mar 07, 2008 at 01:03 am, a!e wrote:

VoodooPad Touch! :D

(Sorry, had to say it : )

On Mar 07, 2008 at 02:50 am, TommyW wrote:

TouchPad surely...

or iVoodoo

On Mar 07, 2008 at 06:58 am, Jamie Kirkpatrick wrote:

I'm disappointed with two things so far with the iPhone SDK:

1: How do we develop applications that need their own frameworks? It seems that I'll now have to compile a static library for each case and compile everything into every application. I was planning on porting a Content Management system to the iPhone that has multiple components so this is an issue.

2: No CoreData!?!?!?! WTF? I mean, SQLite is there, and those of us who have followed Apple's advice and used CD where possible now find we have to rewrite that code to get something that works on the iPhone. Man. Nightmare. So CD doesn't look so great now.

Other than that though it looks great. I can't wait to dig in.

Jamie

On Mar 07, 2008 at 08:26 am, Antonio wrote:

I downloaded the iPhone SDK last night and I have no idea what I'll do with it!

Good to see you've got it working :)

On Mar 10, 2008 at 08:11 am, Greg wrote:

I am hoping Core Data will be released with bindings when IB is released in the 2.0 SDK release in June.

If anyone knows different let me know.

Greg

On Mar 13, 2008 at 06:28 am, Greg wrote:

Do you have a sample for the 1.2 SDK?

Is there a way to bind a column to a control? If so do you have an example?

Thanks

Greg

On Mar 13, 2008 at 09:29 pm, Sam wrote:

Thanks; this makes SQLite on iPhone a whole lot more attractive! Is this under the BSD license?

On Mar 14, 2008 at 12:02 am, Gus Mueller wrote:

Yea, this is under the BSD license.

On Mar 14, 2008 at 08:02 am, Greg wrote:

Are there any tools out there that I could use to move an mdb database or csv tables from a Windows/Mac environment to SQLite on the iPhone. Not sure what the best process would be to go about this.

I was hoping there might be something similar to NaviCat which I use for moving mdbs and CSVs to MySQL dbs in a server environment.

Thanks

Greg

On Mar 16, 2008 at 04:39 pm, David Phillip Oster wrote:

What is the license on FMDB? I think I'd like to use it, but some of the files say:

// Created by August Mueller on 10/30/05.

// Copyright 2005 Flying Meat Inc.. All rights reserved.

I'd be ecstatic if it were Apache license.

On Mar 16, 2008 at 06:31 pm, Bridger Maxwell wrote:

Looks great. Compiled on my first try, which is always good. I was pretty worried when I didn't find any documentation on using SQLite on the iPhone, but it looks like you have taken care of that for me. I would be interested in hearing what license this is being given away under also.

On Mar 17, 2008 at 11:55 am, Jeff wrote:

<blockquote>I am hoping Core Data will be released with bindings when IB is released in the 2.0 SDK release in June. </blockquote>

The documentation makes it pretty clear that Core Data and Bindings were excluded intentionally for performance reasons, so I wouldn't expect to see them. Interface Builder, they're promising, but are not saying when we'll get it, but do not expect to see Core Data or Bindings until at least the next generation of hardware comes out, and probably not till much later, and maybe even never.

On Mar 18, 2008 at 02:41 pm, Brian Topping wrote:

Coming from a Java environment, FMDB is kind of like JDBC, where Core Data is more like a real object-relational mapper. JDBC is useful and fast, and the reality is it's far better than nothing at all. But once one starts to use a decent OR mapper, it's pretty clear that the number of bugs that are avoided in production code far outstrips the performance penalty of using it.

Moore's Law will eventually provide for the availability of CD, but alas, we pioneers will have to write our apps without it, making us look silly in the face of future apps that have it as a part of their available tools. :-/

Regardless, thanks for the tool, I'm going to start using it!!

On Mar 19, 2008 at 05:48 am, Greg wrote:

Maybe I was blind, but it looks like they posted an SQLite example during yesterdays update of the developer.apple.com/iphone.

Greg

On Mar 19, 2008 at 07:31 am, JSZ wrote:

I'd like t use your FMDatabase in my code. May I assume LGNL (The lesser gnu license, to include in my program while retaining credit for your work).

On Mar 19, 2008 at 08:09 am, Milo Bird wrote:

Thanks, this is great, but I'm just looking at the bindings that you've got in place for NSNumber instances, and they seem rather incomplete.

For instance, suppose I want to insert an entry with a specific rowid. The rowid is of type sqlite_int64, which equates to a "long long". But you don't seem to handle this type encoding.

Is there a reason why you're not handling this?

On Mar 19, 2008 at 01:39 pm, Gus Mueller wrote:

As mentioned above in the comments, it's the BSD license :)

On Mar 25, 2008 at 09:11 pm, Fred Stephens wrote:

Gus, looking at your example for using fmdb I can see how to open and/or create the database, but how can I know if I have created a database? It seems this wold be used to decide if I need to run the initialization code to create the tables -- or am I missing something.

Thanks!

On Apr 25, 2008 at 12:57 pm, Andrey Subbotin wrote:

It looks great. I'm going to try it out. Thanks a lot! :)

On Jun 02, 2008 at 10:17 pm, Raed Shomali wrote:

Hello,

I am still a beginner in iPhone Development, and was wondering if you could direct me on how to import the FMDB into XCode?

I am trying to create a simple SQLite based application, and found the FMDB to be simple to understand.

I tried adding the files under src, but XCode seems to keep complaining. Could you give me the steps i should be following?

Thanks ..

On Jun 02, 2008 at 11:25 pm, Marco Papa wrote:

This seems to be a good example:

http://developer.yahoo.com/auth/license.txt

OK?

On Jun 10, 2008 at 04:06 am, Amit wrote:

I used it to develope sample sqllite application and its working gr8. Thanks 4 such a nice contribution.

May i use it in my application? or i need licence
Amit

On Jun 22, 2008 at 03:37 am, steve wrote:

Hello.

I just started with with objective-c/cocoa/iPhone SDK and trying to get the FMDB wrapper working but when I try and compile a fresh project it says:

error: Cocoa/Cocoa.h not found

Any help would be greatly appreciated.
Thanks.