SQLite 101 for iPhone Developers: Creating and ...

25-02-07 12

以上就是给各位分享SQLite101foriPhoneDevelopers:Creatingand...，同时本文还将给你拓展(转)11UIKitsforiPhoneandiPadDevelopmen

以上就是给各位分享SQLite 101 for iPhone Developers: Creating and ...，同时本文还将给你拓展(转) 11 UI Kits for iPhone and iPad Development、10 HTML5 text editors for web developers and designers、100 Free Courses & Tutorials for Aspiring iPhone App Developers、2013 Stanford公开课 Developing iOS 7 Apps for iPhone and iPad 讲义分享等相关知识，如果能碰巧解决你现在面临的问题，别忘了关注本站，现在开始吧！

本文目录一览：

SQLite 101 for iPhone Developers: Creating and ...
(转) 11 UI Kits for iPhone and iPad Development
10 HTML5 text editors for web developers and designers
100 Free Courses & Tutorials for Aspiring iPhone App Developers
2013 Stanford公开课 Developing iOS 7 Apps for iPhone and iPad 讲义分享

SQLite 101 for iPhone Developers: Creating and ...

There are many ways to retrieve and store data on the iPhone,from property lists to NSCoding,from sqlite to Core Data.

This two-part tutorial series is going to cover one of those options:SQLite. sqlite is a simple and easy to use library that implements a simple database engine,treating a database as a simple flat file.

In this series,we’re going to show how to make an app that displays a list of Failed US banks from a sqlite database.

In this first part of the series,we will cover what sqlite is and why we’d want to use it,how to use the sqlite3 command-line utility,and how to import data programmatically via Python.

In thesecond part of the series,we will cover how to make an iPhone app that reads data from the sqlite database we created,and display data in a table view and a drill down detail view.

This tutorial does not assume any prior kNowledge with Python or sqlite,however it assumes a basic kNowledge of sql.

sqlite Overview

Before we begin,let’s give a high level overview of sqlite.

One of the nicest aspects of sqlite is its simplicty. As mentioned above,databases are just flat files!

This means that you don’t need to have a database server running at all. You simply tell the sqlite3 library the name of the file the database is stored in,and it contains all of the smarts about how to handle sql statements to get the data in and out of the file.

One easy way to interact with sqlite3 databases is through the sqlite3 command line utility. To use it,simply fire up a Terminal and type sqlite3 followed by the name of the database you want to open,such as the following:

sqlite3 test.sqlite3

You will see a sqlite prompt appear,and you can begin to enter in sql statements to create tables and work with data like the following:

sqlite> create table awesome_video_games(name text,type text);
sqlite> insert into awesome_video_games values('fallout','rpg');
sqlite> insert into awesome_video_games values('final fantasy','rpg');
sqlite> insert into awesome_video_games values('deus ex','rpg');
sqlite> insert into awesome_video_games values('hitman','stealth');
sqlite> select * from awesome_video_games where type='rpg';
fallout|rpg
final fantasy|rpg
deus ex|rpg

If you come from another database background such as MysqL,you’ll notice some differences with the Syntax and some missing commands. I’d recommend checking out theSQLite SQL referenceand theSQLite datatype referencefor full details.

Note that the sqlite3 command line utility contains some useful “Meta” commands to list tables and get table schemas like the following:

sqlite> .tables
awesome_video_games
sqlite> .schema awesome_video_games
CREATE TABLE awesome_video_games(name text,type text);

You can get a full list of “Meta” commands by typing .help at the sqlite3 command line.

Why Use sqlite?

So why would we want to use sqlite,anyway?!

Well,sqlite has a lot of advantages over property list and NSCoding serialization when it comes to large sets of data.

First,it’s quite easy to pull out only a subset of the data available from the database at a time,which is good for memory usage and speed.

Secondly,the database engine can do a lot of neat work for you such as giving you counts of rows or sums of fields quite easily.

According to Apple,most of the cases where you find yourself wanting to use sqlite3,you would probably be better served usingCore Datainstead because it has a lot of useful built-in features that can both save you time programming,reduce memory usage,and improve speed.

However,I’ve found the learning curve for Core Data to be significantly higher than sqlite3. Since Core Data is an API on top of sqlite3,learning sqlite3 first can be a good stepping stone to Core Data.

I may have some more articles in the future covering Core Data,but for Now let’s start simple and work with sqlite!

Obtaining Some Data

Before we can get an app together,first we need to do is get a data set to work with!

If you aren’t already aware,the US government has a neat web site that makes a lot of data obtained by varIoUs government agencies publicly available atdata.gov.

I was browsing through the site and came acrossa list of banks that have failed since October 1,2000. I thought this would be a great set of data to work with,since a) it’s quite simple,and b) the data set is interesting to me! :]

So go ahead and visit the above link,and click to download the data in CSV format. Once you download it and take a look,you’ll see that the data contains lines of comma separated entries like so:

Desert Hills Bank,Phoenix,AZ,57060,26-Mar-10,26-Mar-10
Unity National Bank,Cartersville,GA,34678,26-Mar-10
Key West Bank,Key West,FL,34684,26-Mar-10

Creating Our Database : Via sqlite3?

Once we have the data,the next step we need to do is create a sqlite3 database with that data.

We Could load up the sqlite3 command line utility and start creating our table and starting to import the data from it,line by line. However this would be incredibly tedious.

If our CSV was very simple,we Could use the sqlite3 command line to create a table,specify the CSV separator value,and import the data from the CSV:

sqlite> create table Failed_banks(name text,city text,state text,zip integer,close_date,updated_date text)
sqlite> .separator ","
sqlite> .import banklist.csv Failed_banks

However,unfortunately our CSV value is not that simple. If you look through the data,you will see some lines such as the following:

"La Jolla Bank,FSB",La Jolla,CA,32423,19-Feb-10,24-Feb-10

In this instance,the quotes around “La Jolla Bank,FSB” are meant to indicate that that entire string is the name of the bank. However,the sqlite3 importerdoes not handle embedded quote marks,so we have to find another option.

We Could massage the CSV a bit to get rid of those quotes\commas of course. But there’s something else we can do that is pretty easy and a good learning experience too: import the data into our database with Python!

Creating Our Database : Via Python!

Python also comes with a built-in sqlite3 library that makes it super easy to interact with sqlite3 databases.

Python should be pre-installed on your Mac. Create a file named parseBanklist.py in the same directory that your CSV file is in,and start by adding the following code:

import sqlite3;
from datetime import datetime,date;

conn = sqlite3.connect('banklist.sqlite3')
c = conn.cursor()
c.execute('drop table if exists Failed_banks')
c.execute('create table Failed_banks(id integer primary key autoincrement,name text,acquiring text,close_date text,update_date text)')

The first line imports the sqlite3 module,and the second imports some datetime functionality we’ll need later.

Then we open up a connection to our sqlite DB by simply passing in the name of the file. We then create a cursor,which we can use to execute sql statements or move through rows of results.

Then we call execute on the cursor to run two different sql statements: one to drop any existing table by the name of Failed_banks,and the second to create our table.

It’s good practice to have a primary key for database tables – so you can quickly access data by the primary key,for example. The “name” field wouldn’t be a good choice for a primary key,because banks Could have the same name (such as if they were from different states).

So instead we create our own id field that is a unique number for each row. We mark it as auto-increment so the sqlite engine will handle assigning each row an incrementing number as we add data.

Also note that there is no date data type for sqlite. However,according to theSQLite datatype reference,as long as you put dates in a particular format (one of which is a text string in the format “YYYY-MM-DD HH:MM:SS.SSS”),sqlite’sdate and time functionswill be able to handle the values as dates – so that is what we’ll do!

At this point,you can run your Python script with “python parseBanklist.py” and then use the sqlite3 utility to verify that the database table has been created. Next,to add some data!

Inserting Data via Python!

Python has a neat function called string.split() where you can specify a delimiter,and Python will break the string up into an array of substrings. You can see this at work with the following:

>>> a = "Unity National Bank,26-Mar-10" >>> a.split(",") ['Unity National Bank','Cartersville','GA','34678','26-Mar-10','26-Mar-10']

However,there is no built-in way (that I kNow of) to have Python handle quotes as escapes for separation,in order to handle the “La Jolla Bank,FSB” example shown above. So let’s write our own little function to split up a line that handles quote escaping:

def mysplit (string):
	quote = False
	retval = []
	current = ""
	for char in string:
		if char == '"':
			quote = not quote
		elif char == ',' and not quote:
			retval.append(current)
			current = ""
		else:
			current += char
	retval.append(current)
	return retval

This is quite straightforward Python here – we simply go through the string character by character,building up the list of sub-items separated by commas along the way.

Now that we have this,we can go line-by-line through our CSV file,inserting data into our database:

#Read lines from file,skipping first line
data = open("banklist.csv","r").readlines()[1:]
for entry in data:
	# Parse values
	vals = mysplit(entry.strip())
	# Convert dates to sqlite3 standard format
	vals[5] = datetime.strptime(vals[5],"%d-%b-%y")
	vals[6] = datetime.strptime(vals[6],"%d-%b-%y")
	# Insert the row!
	print "Inserting %s..." % (vals[0])
	sql = "insert into Failed_banks values(NULL,?,?)"
	c.execute(sql,vals)

# Done!
conn.commit()

In the first line,we just open up the CSV in read mode,read all of the lines,and skip the first line (because it contains a header we don’t want to read).

We then iterate through each line,and use our helper function to split the line into pieces.

We use thePython datetime moduleto convert the CSV data (in a format such as “26-Mar-10″) into a Python datetime object that we Could then easily format however we want. But we’ll just take the default,which happens to output the dates in the format sqlite expects.

Finally,we create our sql statemen,inserting question marks wherever user-specifie parameters should be,and then execute the statement passing in the users-specified values. We pass NULL for the first parameter (the id field) so that sqlite can generate the auto-incremented ID for us.

And that’s it! You should be able to run sqlite3 to verify the data is correctly in the database:

sqlite> select * from Failed_banks limit 3;
1|Desert Hills Bank|Phoenix|AZ|57060|2010-03-26...
2|Unity National Bank|Cartersville|GA|34678|2010-03-26...
3|Key West Bank|Key West|FL|34684|2010-03-26...

注：原文中Python代码有些问题（sql语句与Failedbanks.csv），可能是因为Failedbanks.csv文件更新了的缘故，请不要直接使用原文中粘出来的Python代码。

下面是我改后的全部parseBanklist.py文件：

import sqlite3;
from datetime import datetime,update_date text)')

def mysplit (string):
	quote = False
	retval = []
	current = ""
	for char in string:
		if char == '"':
			quote = not quote
		elif char == ',' and not quote:
			retval.append(current)
			current = ""
		else:
			current += char
	retval.append(current)
	return retval

#Read lines from file,vals)

# Done!
conn.commit()

确实想实现的就试试上面的代码吧。

(转) 11 UI Kits for iPhone and iPad Development

http://webdesignledger.com/freebies/11-ui-kits-for-iphone-and-ipad-development

10 HTML5 text editors for web developers and designers

https://smashinghub.com/10-html5-text-editors-for-web-developers-and-designers.htm

Text editors are the essential tools for web developers. In fact, it is also not uncommon for designers to know a bit of code editing as well include HTML, CSS etc. The past text editors used to be downloadable versions where we need to install. This makes them limiting as revisions are slow to come by. With HTML5 technology, we are seeing a current new batch of HTML5 text editors that are completely written for the web. The good thing is that version changes can be fast and the capabilities of these text editors can be extended via plugins or other extensions.

Below is a roundup of some of the best and free HTML5 text editors for designers and web developers.

#1: Brackets: Adobe’s opensource text editor

Brackets was launched last year by Adobe as an open source text editor whose capability can be extended via their bracket extensions. The entire editor was built on HTML, CSS etc which means it is very easy to work with for those who are familiar with these languages. Extensions can also be easily built based on these common web language.

#2: Popline

Popline is a pure HTML5 editor toolbar. It floats on the things that you want to edit so it is rather cool to use. Function wise, it does not have all the bells and whistle of traditional text editor but for designers, it is definitely sufficient.

#3: Bootstrap-wysiwyg

This is a simple but functional editor for bootstrap. The plugin turns any DIV into WYSIWYG rich-content editor. You can see how it looks from the screenshot above.

#4: Mercury editor

One of the most powerful HTML5 editor is the mercury editor. It has a full fledged editor with support for almost all web naive language including HTML, elements sybnax and even Javascript APIs. There is even a drag and drop function for all file uploading. Very cool.

#5: Aloha editor

The distinct feature of aloha editor is that it can be embedded within a CMS like wordpress. This makes page editing much faster, especially if you liked to play with your page formatting and layout.

#6: jResponse – A text editor for responsive web design

jResponse is an interesting text editor as it focuses on supporting responsive design within its framework. It is a bit rough right now as the program is still in beta but it is worth signing up and taking it for a test drive to see if it can improve our productivity when it comes to developing websites for mobile.

#7: WebMatrix3

I think most will be familiar WebMatrix3 from Microsoft. It is nice HTML5 web development tool and comes with a lot of cool features such as code completion for jQuery Mobile and supporting a range of language include ASP.NET, PHP and HTML5 templates.

#8: Webstorm

Webstorm is a cool editor that comes with loads of functions. People who have tried it will know what I am talking about. It supports a wide range of web language including HTML5. It also has a nice debugging interface that will make it faster for you to spot and repair all the bugs in your code.

#9: Raptor Editor

Raptor editor is one of the most beautiful html5 text editor that I have seen. Not only is it nice to look at, the editor itself is entirely modular in nature so that everything is extensible. It is literally a modern editor that is suited for both developers and designers.

#10: TopStyle 5

TopStyle 5 is a very modern html5 editor that has a nice preview function for you to see real time changes. This improves the productivity of your code writing quite significantly and is one of the feature I liked best.

100 Free Courses & Tutorials for Aspiring iPhone App Developers

Unless you’ve been living under a rock,you kNow that the iPhone is a big deal and it’s one of the most popular subjects of development these days. Lots of developers are creating their own iPhone apps,and with the right kNow-how,you can too. Check out our list of courses and tutorials to learn everything that’s important about developing for the iPhone.

University

Here you’ll find iPhone development courses offered by top universities.

iPhone Application Programming: Learn about programming for the iPhone from Stanford on iTunes. [Stanford]
Introduction to iPhone Application Development: Use this course’s posted slides to get a crash course in iPhone application development. [MIT]

Apple Resources

You can learn about iPhone development straight from the source with these Apple documents.

Getting Started with iPhone: Here you’ll find a general introduction to iPhone development. [Apple]
Object-Oriented Programming with Objective-C: This document offers an excellent guide for object oriented programming. [Apple]
Networking & Internet Coding How-Tos: In this resource,you will find lots of great advice for networking and Internet development on the iPhone. [Apple]
Getting Started with Audio & Video: Use this document to get started with audio and video features in iPhone applications. [Apple]
Your First iPhone Application: This introductory tutorial offers a step by step description of getting started with an iPhone application. [Apple]
Getting Started with Performance: This guide offers an introduction to improving the performance on iPhone apps. [Apple]
iPhone Application Programming Guide: Get an introduction to the iPhone OS and development process. [Apple]
iPhone OS Technology Overview: Learn about the iPhone OS and its technologies from this guide. [Apple]
Getting Started with Data Management: Here you’ll find a reference that will help you with data management. [Apple]
Security Overview: Get an understanding of the security concepts on the iPhone from this resource. [Apple]
Performance Overview: Get a look at the factors that determine performance through this guide. [Apple]
Resource Programming Guide: Check out this resource to learn how to work with nib and bundle resources.
Getting Started with User Experience: This document offers an introduction to constructing iPhone application user interfaces. [Apple]
iPhone Human Interface Guidelines: Follow these guidelines to make sure your iPhone app has a good human interface. [Apple]
iPhone Development Guide: Use this development guide to get an introduction to creating web apps on the iPhone. [Apple]
Data Formatting Programming Guide for Cocoa: This guide will teach you how to use Cocoa formatters for data. [Apple]
Getting Started with Tools: You will find a guided introduction to the Xcode toolset from this document. [Apple]
Data Management Coding How-tos: Get answers to common data management coding questions. [Apple]
Introduction to Cocoa Application Tutorial: You’ll need at least a base level understanding of Cocoa for iPhone development,which you can check out in this tutorial. [Apple]
Core Animation Programming Guide: Follow this guide to get the main components and services of Core Animation. [Apple]
Coding Guidelines for Cocoa: In this guide,you’ll learn about naming guidelines for the Cocoa API as well as design advice. [Apple]
Getting Started with Graphics and Animation: Follow this guide for an introduction to 2D and 3D graphics and animation. [Apple]
Learning Objective-C: A Primer: Check out this document once you’ve worked through object oriented programming and Cocoa. [Apple]
Cocoa Fundamentals Guide: You’ll learn about the basic concepts,terminology,and more in Cocoa from this guide. [Apple]
Graphics and Animation Coding How-Tos: In this resource,you’ll find lots of great tips and advice for graphics and animation on the iPhone. [Apple]

Getting Started

Get an introduction to iPhone development through these tutorials.

iPhone App Development-Where to Start: This tutorial will teach you how to get started in iPhone app development. [The Daleisphere]
Bootstrap: Learn a few pointers for iPhone development from this resource. [furbo]
Learn How to Develop for the iPhone: This tutorial will show you how to build an alternate page and style sheet for the iPhone. [NETTUTS]
iPhone Application Development,Step By Step: In this tutorial,you will find a step by step guide to creating a simple iPhone game. [Open Laszlo]
First iPhone Application: Get a brief introduction to creating your first iPhone application. [iPhone SDK Articles]
iPhone Dev: Check out this PDF to get a tutorial for iPhone development. [Lucas Newman]
iPhone App Development for Web Hackers: Use this tutorial to learn about geo-location features and beginner development tips. [How to Iphone Application]
How to Write an iPhone App: This tutorial gives you a basic look at what it takes to write an iPhone application. [Webmonkey]
iPhone App Development for Web Hackers: In this article,you’ll learn about web hacking development for the iPhone. [Dominiek]
Writing Your First iPhone Application: Bill Dudney will walk you through all of the tools and pieces of kNowledge you’ll need to write your first iPhone application. [The Pragmatic Bookshelf]
Cocoa Touch Tutorial: iPhone Application Example: This tutorial will show you how to make a very basic Cocoa Touch application with Interface Builder. [Cocoa Is My Girlfriend]
Building an iPhone app in a day: Check out this tutorial to see how you can build a useful app quickly. [The Bakery]
Seven Things All iPhone Apps Need: Check out this list to see what’s essential when creating an iPhone app. [APCmag]
Put Your Content in My Pocket: Learn how to use the iPhone web browser to your advantage from this article. [A List Apart]
iPhone Training Course: Become a master at writing iPhone applications through this course. [Rose India]
So you’re going to write an iPhone app…: Learn about code reuse,memory,and more from this tutorial. [furbo]
Learn How to Develop for the iPhone: Check out this tutorial to see how to build an alternative page and style sheet for the iPhone. [Net Tuts]
Developing for the iPhone: This resource will show you how to develop ASP.NET applications for the iPhone. [Dot Net Slackers]
Getting Started with iPhone Development: Ed Burnette offers a basic introduction to iPhone development. [ZDnet]

Tools

These tutorials will teach you how to use specific tools in order to create iPhone apps.

Make an iPhone App Using the Envato API: Make your own iPhone app with the Envato API with the help of this tutorial. [Net Tuts]
Developing iPhone Applications using Ruby on Rails and Eclipse: Learn how to detect mobile Safari from a Ruby on Rails application through this tutorial. [IBM]
14 Essential Xcode Tips,Tricks and Resources for iPhone Devs: Learn how to make sense of xcode with this helpful resource. [Mobile Orchard]
Develop iPhone Web Applications with Eclipse: This tutorial will help you learn how to create iPhone applications with Aptana’s iPhone development plug-in. [IMB]
Build an iPhone Webapp in Minutes with Ruby,Sinatra,and iUI: You can learn how to quickly put together an iPhone app with these tools. [Mobile Orchard]
iPhone Development with PHP and XML: In this tutorial,you’ll get a look at developing custom applications for the iPhone. [IBM]

Details

These tutorials cover all of the important details in iPhone app development.

Avoiding iPhone App Rejection from Apple: This tutorial holds the secrets to making sure your iPhone app makes the cut. [Mobile Orchard]
Landscape Tab Bar Application for the iPhone: Follow this tutorial to learn about making the tab bar application support landscape orientation. [Cocoa Is My Girlfriend]
iPhone Programming Tutorial-Using openURL to Send Email from Your App: This tutorial explains how you can send email through applications,and even pre-fill fields. [iCode]
Multi Touch Tutorial: This tutorial will show you how you can respond to a tap event. [iPhone SDK Articles]
Create a Navigation-Based Application: This tutorial will teach you how to create and run a navigation-based application from XCode.
Advanced iPhone Development: Go beyond the basics with this iPhone development tutorial. [Dot Net Slackers]
Here’s a Quick Way to Deal with Dates in Objective C: Get information on dealing with date fetching through this tutorial. [Howtomakeiphoneapps]
Navigation Controller + UIToolbar: Through this tutorial,you can learn how to add a UIToolbar to an app. [iPhone SDK Articles]
iPhone Asynchonous Table Image: Follow this thorough article to learn about loading multiple images in your iPhone app in an asynchonous manner. [Markj]
Localizing iPhone Apps-Internationalization: You can use resource files to display text in a user’s language-learn how in this tutorial. [iPhone SDK Articles]
Tutorial: JSON Over HTTP on the iPhone: With this tutorial,you’ll get a step by step how-to for JSON web services through an iPhone app. [Mobile Orchard]
Parsing xml on the iPhone: This tutorial will show you how to parse XML using the iPhone SDK. [Craig Giles]
Reading data from a SQLite Database: Here you’ll find a quick tutorial for reading data from a sqlite database. [dBlog]
How to Make an Orientation-Aware Clock: Through this tutorial,you’ll learn about building a simple,orientation-aware clock. [The Apple Blog]
Finding iPhone Memory Leaks: Carefully find iPhone memory leaks by using this tutorial. [Mobile Orchard]
Localizing iPhone Apps: MAke sure that your iPhone app is properly formatted according to a user’s native country or region with the help of this tutorial. [iPhone SDK Articles]
OpenAL Audio Programming on iPhone: Here you’ll get code snippets,learning,and more. [Gehaktes]
9 iPhone Memory Management Links and Resources: Here you’ll find a variety of iPhone memory management resources that can help you get things under control. [Mobile Orchard]
Parsing XML Files: Get an understanding of how you can parse XML files with this tutorial. [iPhone SDK Articles]

User Interface

These tutorials are all about the user interface and interaction.

UITableView-Drill down table view tutorial: Check out this tutorial to learn how to make a drill down table view. [iPhone SDK Articles]
iPhone Coding-Learning About UIWebViews by Creating a Web Browser: In this tutorial,you’ll learn about UIWebViews through the creation of a browser. [iCode]
Design Patterns on the iPhone: Check out David Choi’s guest lecture on user interface design for the iPhone. [New Jersey Institute of Technology]
UITableView-Adding subviews to a cell’s content view: This tutorial will show you how to customize the UITableViewCell. [iPhone SDK Articles]
Drill down table view with a detail view: Learn how to load a different detail view on the UITabBarController. [iPhone SDK Articles]
Extending the iPhone’s SDK’s UIColor Class: Learn how to extend the iPhone SDK UIColor class,and get code samples from this article. [Ars Technica]
UITableView: Learn how to make a simple index for the table view with this tutorial. [iPhone SDK Articles]

Building Tutorials

Check out these tutorials where you’ll build a specific app,and learn more about iPhone development along the way.

Build a Simple RSS Reader for the iPhone: Get walked through the creation of an RSS reader for a simple Feed on the iPhone. [The Apple Blog]
iPhone Gaming Framework: This article offers a look at writing code for iPhone game developers. [Craig Giles]
Build a Simple RSS Reader for the iPhone: Follow this tutorial,and you’ll learn about building a simple iPhone RSS reader.
iPhone Game Programming Tutorial: This multipart tutorial offers a way to learn OpenGL and Quartz for iPhone development. [iCode]
Build your very own Web browser!: Follow this tutorial to learn about the process of building your own iPhone web browser. [dBlog]
iPhone application development,step by step: Find out how to build the iPhone application NEWSMATCH using OpenLaszlo. [OpenLaszlo]
Building an Advanced RSS Reader using TouchXML: Get step by step information for creating an advanced iPhone RSS reader from this tutorial. [DBlog]
iPhone SDK Tutorial: Building an Advanced RSS Reader Using TouchXML: This tutorial will help you learn more about iPhone development by building an advanced RSS reader with TouchXML. [dBlog]

Videos

Watch these videos for a visual guide to iPhone app development.

Basic iPhone Programming: Check out this video to get started with iPhone programming. [iPhone Dev Central]
First Step Towards the App Store: Work towards getting your app in the app store with the help of this tutorial. [You Tube]
Hello World: This tutorial will help you learn the basics of iPhone programming. [iPhone Dev Central]
UITableView iPhone Programming Tutorial: Watch this video to learn how to populate a UITableView. [YouTube]
iPhone App Tutorial 1: Check out this video to quickly learn about Interface Builder. [YouTube]
iPhone IB-Your First App: Watch this tutorial to learn how to use the Interface Builder. [iPhone Dev Central]
Understanding Source Code: Learn how to get started with development on the iPhone through this video tutorial. [YouTube]
How to Make an iPhone App: Create an iPhone app using Jiggy and this tutorial. [YouTube]
iPhone Development with Dashcode: Find out how to develop iPhone applications with Dashcode through this tutorial. [YouTube]

Development Resources

These resources are not courses or tutorials,but they are incredibly valuable resources for beginner iPhone app developers.

iPhone Open Application Development: This book will teach you how to create software for the iPhone environment. [Safari Books Online]
iPhone GUI PSD File: Use this set to get a comprehensive,editable library of iPhone UI assets. [Teehanlax]
31 iPhone Applications with Source Code: Teach yourself how to create iPhone apps by taking a look at the code in these. [Mobile Orchard]
iPhoney: Using iPhoney,you’ll be able to see how your creation will look on the iPhone. [Market Circle]
35 Free iPhone Icon Sets: Check out this resource to find a great variety of iPhone icons.

From: http://www.bestuniversities.com/blog/2009/100-free-courses-tutorials-for-aspiring-iphone-app-developers/

2013 Stanford公开课 Developing iOS 7 Apps for iPhone and iPad 讲义分享

itunes上已经更新了2013年最新的基于iOS7的公开课，依旧是斯坦福的公开课，讲师也依旧是哪位性感小白胡须的小老头。

视频太大啦。家里宽带拙计。建议各位客观去itunes观看吧，itunes的下载速度基本都能达到峰值，因为现在苹果再国内貌似是建立的有数据中心。但是如果很慢的话，建议你配置一下DNS就可以了。到这里：http://dns.v2ex.com/ 用它的DNS。实测还是速度很好的。

建议再itunes里看还有一个原因就是，带有英文的字幕。基本8090%应该是能看懂的。

我用的上海长城宽带，没有特地配置DNS，速度都是峰值。还不错。

讲义下载地址：

http://pan.baidu.com/s/1zit3q

今天关于SQLite 101 for iPhone Developers: Creating and ...的分享就到这里，希望大家有所收获，若想了解更多关于(转) 11 UI Kits for iPhone and iPad Development、10 HTML5 text editors for web developers and designers、100 Free Courses & Tutorials for Aspiring iPhone App Developers、2013 Stanford公开课 Developing iOS 7 Apps for iPhone and iPad 讲义分享等相关知识，可以在本站进行查询。

本文标签：