Difference between revisions of "SQLite for iPhone and iPod touch"
From Organic Design wiki
m |
|||
| 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'' | **Looks like the compiler you need is called ''arm-apple-darwin-cc'' | ||
| Line 32: | Line 32: | ||
http://www.petebarrwatson.com/images/babel1.jpg | http://www.petebarrwatson.com/images/babel1.jpg | ||
| − | ==See also== | + | == See also == |
| + | *[[iPhone and iPod touch]] | ||
*[http://iphone.natetrue.com/ General iPhone hacking] | *[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://celso.arrifana.org/index.php?serendipity%5Baction%5D=search&serendipity%5BsearchTerm%5D=frameworks Setting up a toolchain with xcode] | ||
| Line 39: | Line 40: | ||
*[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]] | ||
Revision as of 06:40, 16 January 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
[hide]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
