The page I am working on has a javascript function executed to print parts of the page. For some reason, printing in Safari, causes the window to somehow update. I say somehow, because it does not really refresh as in reload the page, but rather it starts the "rendering" of the page from start, i.e. scroll to top, flash animations start from 0, and so forth. The effect is reproduced by this fiddle: http://jsfiddle.net/fYmnB/ Clicking the print button and finishing or cancelling a print in Safari causes the screen to "go white" for a sec, which in my real website manifests itself as something "like" a reload. While running print button with, let's say, Firefox, just opens and closes the print dialogue without affecting the fiddle page in any way. Is there something with my way of calling the browsers print method that causes this, or how can it be explained - and preferably, avoided? P.S.: On my real site the same occurs with Chrome. In the ex
Using SQLite 3 on the iPhone is really not that different from using it on any other platform. You should read the general SQLite documentation.
ReplyDeleteIn your iPhone app, you usually open your SQLite database in the applicationDidFinishLaunching: method of your application delegate. After that, you can just use your database.
I've used Gus Mueller's FMDatabase classes on the iPhone. They provide a thin wrapper around SQLite.
A final note: It seems CoreData will become available on the iPhone with OS version 3. You can use SQLite through the CoreData framework.
Take a look at this book:
ReplyDeleteBeginning iPhone Development: Exploring the iPhone SDK by Dave Mark (Nov, 2008)
There is a section dedicated to SQLite.
I really like the tutorials from:
ReplyDeletehttp://www.iphonesdkarticles.com/search/label/SQLite
it should get you started in no-time.
Stanfords cs193p iPhone application development previous semester showed how to setup and use sqlite3 with iphone.
ReplyDeleteI haven't checked the latest lecture's but there is a reference to sqlite in latest semester. There are lecture notes and video in iTunesU - check out cs193p web site for links/references/example code/lecture notes.
iCodeBlog's has got a very well written tutorial on SQLite 3 as well.. Check out the first part at iPhone Programming Tutorial – Creating a ToDo List Using SQLite Part 1.
ReplyDeleteApart from Peter Quade's excellent answer, may I also suggest you to check out http://www.iphonekicks.com/tags/SQLite - here you would find many bookmarks to SQLite topics.
ReplyDeleteAnd just FYI, iPhone Kicks is a social book marking site, a Digg clone but purely for the iPhone SDK links :-)
I have some iPhone SQLite links in my Delicious bookmarks. There should be enough links there to teach you all the SQLite you will ever need. Lots of the tutorials are pretty simple and easy to understand. There are a few wrappers out there too. I haven't used any of the wrappers, but they look interesting. Also, check out other bookmarked items tagged SQLite on Delicious.
ReplyDelete