Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional iPhone and iPad Database Application Programming
This is the forum to discuss the Wrox book Professional iPhone and iPad Database Application Programming by Patrick Alessi; ISBN: 978-0-470-63617-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional iPhone and iPad Database Application Programming section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 9th, 2012, 03:10 PM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Oracle ? SQL Server ? MySQL ?

Hi,

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 !

Klaus
  #2 (permalink)  
Old November 9th, 2012, 04:06 PM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Rob
  #3 (permalink)  
Old November 9th, 2012, 04:13 PM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 !

Klaus
  #4 (permalink)  
Old November 10th, 2012, 12:54 AM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Klaus

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:

http://iphonedevsdk.com/forum/tutori...-tutorial.html

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!

Rob

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

Last edited by Rob Napier; November 10th, 2012 at 12:59 AM.
  #5 (permalink)  
Old November 10th, 2012, 12:59 AM
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Thanks

Klaus,
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add a Linux hosted MySQL server as a MS-SQL Linked Server 4thhorseman MySQL 1 December 9th, 2009 09:31 AM
managing picture using oracle or sql server vedant Oracle 3 January 28th, 2008 07:59 PM
Oracle to SQL Server DataType Mapping maulik33 SQL Language 0 November 1st, 2007 02:48 PM
Data Migration from Oracle to SQL Server AB SQL Server DTS 1 July 27th, 2005 12:38 AM
Anyone fluent in Oracle and SQL Server? evaldesc Oracle 0 July 13th, 2004 11:09 AM



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


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