I want to use a custom class that could handle querying easily. Are there more convenient ways in handling database in Objective C? Can you suggest open-source library or class that do this? Thank you for your answers in advance!
Add a comment
|
4 Answers
Not an inbuilt class but take a look at FMDB that makes it nice and simple!!
6 Comments
ruelluna
I searched this but it I think it doesn't support ARC yet?
Lee Armstrong
Correct but don't let this stop you, you can manually set files to non ARC. maniacdev.com/2012/01/…
ruelluna
How do you include FMDB to your project? Can I just drag the "fmdb.xcodeproj" to my project? or just the classes themselves and include the needed libraries? Any link for installation? Thank you!
Lee Armstrong
You only need to drop in the .h and .m files that fmdb uses.
Lee Armstrong
I always use Navicat myself. Works very well
|
4 Comments
ruelluna
I'm looking at it right now. Do they already support ARC? I'm using iOS 5.X .
MackeiaN
No I'm afraid not. But you can always ignore ARC within those .m-files, or convert the project to ARC. Both ways should work fine.
ruelluna
How do you include FMDB to your project? Can I just drag the "fmdb.xcodeproj" to my project? or just the classes themselves and include the needed libraries? Any link for installation? Thank you!
MackeiaN
Hi sorry for the delay. Ah you just can't drag it, but include the lib. Here's a guide icodeblog.com/2011/11/04/…
Have you had a look at Core Data? It can persist Obj-C objects to a SQLlite database.
Basically Core Data is an Obj-C <-> SQLite object mapper, which allows you to design your database schema in Xcode and work with the data as with normal Obj-C objects.
Xcode will provide you with visual database schema editing as well as code generation. This way you get typed classes for all tables in the database, which I find a great help (auto completion, compile-time checking, etc).
In addition to this, Core Data can take care of data migration for you. Say that in version 2.0 of your application, you want to store your data a little bit differently. You can then define a mapping between your own model and the new model, and the migration will take place as soon as your data context is loaded.
If you want to go the Core Data path or learn more about it, I recommend starting with a tutorial and checking out the sample code.
3 Comments
ruelluna
will you please tell me the whole picture of Core Data?
Krumelur
I cannot give you the whole picture, but I tried to summarize what I find good about it :) For the whole picture you have to go with the documentation..
ruelluna
Thank you. I just installed RestKit and they have awesome Object Mapping.
Easy to use object oriented sqlite wrapper that I created:
https://github.com/Nortey/TankDB
At the moment, its not meant for heavy duty queries or bulk updates. For that I would take everyone else's advice on FMDB. TankDB is more suited for beginners.
