initial FMDB (sqlite3 wrapper) review

[Adam Jack]

Folks,

I started a simple utility application yesterday, and decided to exercise FMBD (which Kendall Gelner mentioned at iPhoneDevCamp #3, thanks for the pointers Kendall) as an sqlite3 wrapper. I'd been hoping for something to make this easier, and was eager to see how FMDB (Flying Meat DB) faired:

Here is what I thought about the experience:

http://neukadye.com/blog/2009/02/26/fmdb-flying-meat-db-wrapper-for-sqlite3-for-iphone/

Summary: it is fine (especially if you are happy rolling your own SQL) and likely good for many simple iPhone apps. It is much easier to use than sqlite3 directly (i.e. Objective-C API verses C API) so a good first starting point for working with sqlite3. It seemed not thread safe by it's simplistic interface design (which felt seriously flawed) and still left me with the job of binding object properties to/from database table columns. I'll keep it for now, but look for something different next time I start a project.

YMMV, so please let me know your thoughts and what wrappers might you come up with for making local iPhone SQL easy.

regards

Adam

--

Share nature: http://wildobs.com

iPhone Application: http://blog.wildobs.com/tag/wildobsobserver

Twitter: http://twitter.com/wildobs

Newsletter: http://wildobs.com/about/newsletter

[Julio Barros]

I've started looking at sqlitepersistentobjects and for my current needs it could not be easier.  Its by Jeff Lamarche of "Beginning iPhone Development" book (grapefruit on the cover).

http://code.google.com/p/sqlitepersistentobjects/

LIke I said, so far it rocks.  If you look at it and find issues let us know so we can all learn. 

Julio

[Hassan]

This book is a great start, but one gigantic missing piece the book
failes to mention is that the sqlite3 is not thread safe. You have to
create your own wrapper that does synchronization if you want to use
mulitple threads for this DB.

-hassan

On Feb 26, 12:19 pm, Julio Barros <Ju...@E-String.com> wrote:
> I've started looking at sqlitepersistentobjects and for my current  
> needs it could not be easier.  Its by Jeff Lamarche of "Beginning  
> iPhone Development" book (grapefruit on the cover).
>
> http://code.google.com/p/sqlitepersistentobjects/
>
> LIke I said, so far it rocks.  If you look at it and find issues let  
> us know so we can all learn.
>
> Julio
>
> On Feb 26, 2009, at 10:46 AM, Adam Jack wrote:
>
> > Folks,
>
> > I started a simple utility application yesterday, and decided to  
> > exercise FMBD (which Kendall Gelner mentioned at iPhoneDevCamp #3,  
> > thanks for the pointers Kendall) as an sqlite3 wrapper. I'd been  
> > hoping for something to make this easier, and was eager to see how  
> > FMDB (Flying Meat DB) faired:
>
> > Here is what I thought about the experience:
>

> >    http://neukadye.com/blog/2009/02/26/fmdb-flying-meat-db-wrapper-for-s...