Iphone database support

Question

Guys which Database is Support apple iphone application and is Database similar to Oracle and Sql etc.., Let me know About Apple iphone database . please give me any example appliccation to know the process ..

how to connect Application to DataBase for instance i have a USername , Password and there is a Submit Button , when i hit the submit Button it will store the values in the Database.( we dont requiired any validations and any retutn page) whether it is going to store the values in the DB Good or not

Thanks& Regards Jagadeesh

Answer 1

SQlite can be used on iPhone. Check this article: http://dblog.com.au/iphone-development-tutorials/iphone-sdk-tutorial-reading-data-from-a-sqlite-database/

Answer 2

Hi Jagadeesh

There is support for SQLlite and then there is Apples own ORM layer called Core Data. SQLlite is traditional database access using text commands to "select", "create", "insert" etc.

Core Data will let you save and retrieve entire objects, they also handle memory management for you.

If you only need to save a username and a password maybe a plist file would suffice? I use Core Data for larger data sets and data with different relations.

The reason all these technologies are included is probably that the each have their advantages and problems:)

Answer 3

http://ODBCrouter.com/ipad (new) now provides the industry standard ODBC programming interface that lets you connect with a username, password, etc.. and send SQL queries and receive back binary results into your program variables. The client-side components drop into XCode and are free, the server-side component runs on a Windows box (or VM) and costs about the same as a TV. The database servers can run on Mac OS X, Windows, Linux, IBM iSeries or AS/400, Unix, NetWare, DOS and legacy mainframes with support for most revisions of MySQL, 4D, QuickBooks Pro, DB/2, MYOB, Empress, Oracle, SQL Server, MS Access, Excel, Navision, Firebird, Pervasive, Sybase, Pick, Universe, Informix, Ingres and SQLite among many others. There are screenshots at the link to see it in action.