p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional iPhone and iPad Database Application Programming (http://p2p.wrox.com/book-professional-iphone-ipad-database-application-programming-603/)
-   -   Oracle ? SQL Server ? MySQL ? (http://p2p.wrox.com/book-professional-iphone-ipad-database-application-programming/88779-oracle-sql-server-mysql.html)

klauskloeser November 9th, 2012 03:10 PM

Oracle ? SQL Server ? MySQL ?

just received the book and flipped through it; although it says on the backcover "Explains extracting data from large-scale databases, such as Oracle, MySQL, or SQL Server" I can't find anything about it through the book, the Index or chapters; just ODBC / JDBC is mentioned, (MSoft,JAVA, duh! ).

How would I connect to Oracle, MySQL and others ???

Thanks for the help !


Rob Napier November 9th, 2012 04:06 PM

Hi Klaus

You ask an interesting question. I am reading 'Beginning iOS Application Development with HTML and Javascript' by Richard Wagner, which I mistakenly thought was the same as your at first reading.

Richard explains how to connect using Javascript and SQLite, though he doesn't explain any of the database side. If you don't know how to set up a database, you may need to do some reading on that topic too. For small apps, SQLite should do fine, though I am wedded to PostgreSQL.

Richard's book is excellent, though I am going to get a copy of Patrick's book to see what extra ideas it offers.

Hope this has been of some help.


klauskloeser November 9th, 2012 04:13 PM

Hi Rob,

I am familiar with SQL database programming (20+ years), I really want to connect to an Oracle database :-)

But how with IOS ?

kind regards and thanks for your post !


Rob Napier November 10th, 2012 12:54 AM


If I was building an app for a conventional website, I'd opt for Python (probably with Django), though if you are just getting started and have a simple application, PHP is probably the easier path.

I went to the bookstore today to get the book you are reading but it is not available. So I have to quote my WROX reference:

In 'Beginning iOS Application Development with HTML and Javascript', Richard Wagner has a section headed "Going SQL With Javascript Database". He gives an example in HTML5:

var db = window.openDatabase(dbName, versionNum, displayName, maxSize);

He goes on to talk about SELECT statements, etc. in Javascript.

What he glosses over is any detail about the database. I'm guessing that the answer lies with SQLite as there is no information about the way to connect. He describes it as being hosted 'locally'. Does that mean on the iPhone or iPad?

I Googled: 'sqlite on an iphone'. One really useful links is this one:


But there were several others that looked hopeful. I suggest that you start there.

But if you are looking for some serious database grunt, take another look at PostgreSQL with a little PHP to drive it!

Hope this helps!


Schrödinger's Cat has/had a split personality.

klauskloeser November 10th, 2012 12:59 AM

Just Oracle...
Hi Rob,

I just want to use Oracle, since this is the database system found at most of my clients and that's the database I am very familiar with and I am everything else than a beginner there ;-) ).

Secondly, I do not want to use Java, PHP, just Objective C / Cocoa.

The book I have goes into very much detail with SQLite on IOS (iPhone/iPad/MacOSX), so that's settled.

So what I need is the on the backcover announced database connect to Oracle under IOS (Objective C / Cocoa.



All times are GMT -4. The time now is 02:28 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.