Difference between revisions of "SQLite for iPhone and iPod touch"
From Organic Design wiki
(add source) |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
How to get [http://www.sqlite.org/ sqlLite] running on an iPod touch. I'm assuming the same toolchain will work with iPhone as i'm pretty sure they're the same architecture. | How to get [http://www.sqlite.org/ sqlLite] running on an iPod touch. I'm assuming the same toolchain will work with iPhone as i'm pretty sure they're the same architecture. | ||
| − | ==Repository== | + | |
| + | == Repository == | ||
Here is an example iPhone / iPod touch package repository designed for use with Installer.app | Here is an example iPhone / iPod touch package repository designed for use with Installer.app | ||
*http://www.sit.auckland.ac.nz/packages/ | *http://www.sit.auckland.ac.nz/packages/ | ||
| Line 11: | Line 11: | ||
*[http://iphone.nullriver.com/beta/ How to make a package for iPhone] - example structure in a [http://iphone.nullriver.com/beta/demo.zip zip file.] | *[http://iphone.nullriver.com/beta/ How to make a package for iPhone] - example structure in a [http://iphone.nullriver.com/beta/demo.zip zip file.] | ||
| − | ==Demo== | + | === Demo === |
Watch this video to see how far we have got. | Watch this video to see how far we have got. | ||
*[http://www.sit.auckland.ac.nz/media/MediaWikiLite-install.mp4 Testing the new repository on an iPod Touch] | *[http://www.sit.auckland.ac.nz/media/MediaWikiLite-install.mp4 Testing the new repository on an iPod Touch] | ||
| − | ==Next steps== | + | == Next steps == |
*Set up an ARM toolchain on a Mac | *Set up an ARM toolchain on a Mac | ||
| + | **Looks like the compiler you need is called ''arm-apple-darwin-cc'' | ||
*Build the [http://www.sqlite.org/sqlite-3.5.4.tar.gz SQLite source] with the toolchain | *Build the [http://www.sqlite.org/sqlite-3.5.4.tar.gz SQLite source] with the toolchain | ||
*Package it up | *Package it up | ||
| Line 25: | Line 26: | ||
**Whatever web/socket server we decide to use | **Whatever web/socket server we decide to use | ||
**Startup scripts to run the daemon on localhost - Accessable via the browser (not so nice) | **Startup scripts to run the daemon on localhost - Accessable via the browser (not so nice) | ||
| − | + | *Design a simplifed native MediaWiki interface for iPhone using Apple's toolbox UI calls (much better) | |
This is the real [[w:The_Hitchhiker%27s_Guide_to_the_Galaxy_%28book%29|Hitchhiker's guide to the Galaxy!]] | This is the real [[w:The_Hitchhiker%27s_Guide_to_the_Galaxy_%28book%29|Hitchhiker's guide to the Galaxy!]] | ||
| − | ==See also== | + | http://www.petebarrwatson.com/images/babel1.jpg |
| + | |||
| + | == See also == | ||
| + | *[[iPhone and iPod touch]] | ||
| + | *[http://iphone.natetrue.com/ General iPhone hacking] | ||
| + | *[http://celso.arrifana.org/index.php?serendipity%5Baction%5D=search&serendipity%5BsearchTerm%5D=frameworks Setting up a toolchain with xcode] | ||
| + | *[http://iphone.fiveforty.net/wiki/index.php/UIKit_Hello_World UIKit hello world] - a simple UI application | ||
*[http://www.oreillynet.com/mac/blog/2007/09/easy_iphone_toolchain_installa.html toolchain installer for mac] | *[http://www.oreillynet.com/mac/blog/2007/09/easy_iphone_toolchain_installa.html toolchain installer for mac] | ||
*[http://iphone.fiveforty.net/wiki/index.php/Toolchain_Helper Toolchain helper] - MacTel and PPC. Copies filesystem onto Mac for development | *[http://iphone.fiveforty.net/wiki/index.php/Toolchain_Helper Toolchain helper] - MacTel and PPC. Copies filesystem onto Mac for development | ||
*[http://iphone.fiveforty.net/wiki/index.php/IPhone_Java#SQLite_JDBC_Driver SQLite] - caution java | *[http://iphone.fiveforty.net/wiki/index.php/IPhone_Java#SQLite_JDBC_Driver SQLite] - caution java | ||
| + | [[Category:Hardware]][[Category:MediaWikiLite]] | ||
Latest revision as of 20:59, 23 August 2008
How to get sqlLite running on an iPod touch. I'm assuming the same toolchain will work with iPhone as i'm pretty sure they're the same architecture.
Contents
Repository
Here is an example iPhone / iPod touch package repository designed for use with Installer.app
Here is an example of the access log entry when the iPod connects to the repository.
www7: 118.90.0.152 - - [14/Jan/2008:00:31:59 +1300] "GET /packages HTTP/1.1" 301 247 "-" "CFNetwork/152.4"
Looks like the installer won't follow redirects into a https url so I made it normal http. The iPod's installer looks up the repository and obtains a list of packages based on the xml plists. I learned how to do this from this article.
- How to make a package for iPhone - example structure in a zip file.
Demo
Watch this video to see how far we have got.
Next steps
- Set up an ARM toolchain on a Mac
- Looks like the compiler you need is called arm-apple-darwin-cc
- Build the SQLite source with the toolchain
- Package it up
- Install and test on the iPod
- Extend the package further to install all necessary MediaWikiLite components
- PHP5
- SQLite
- Whatever web/socket server we decide to use
- Startup scripts to run the daemon on localhost - Accessable via the browser (not so nice)
- Design a simplifed native MediaWiki interface for iPhone using Apple's toolbox UI calls (much better)
This is the real Hitchhiker's guide to the Galaxy!
http://www.petebarrwatson.com/images/babel1.jpg
See also
- iPhone and iPod touch
- General iPhone hacking
- Setting up a toolchain with xcode
- UIKit hello world - a simple UI application
- toolchain installer for mac
- Toolchain helper - MacTel and PPC. Copies filesystem onto Mac for development
- SQLite - caution java
