webOS skill level: Beginner
Technologies covered: SQL
Prerequisite knowledge: None
Palm has recently revealed that the webOS Mojo toolkit will support the creation of local databases on the Pre (and future webOS devices) for storage of local data. To make use of this feature, you will need to understand SQL, or Structured Query Language, the language used ubiquitously for interacting with all types of databases. Using SQL, you can save, retrieve, update, and delete information on the Palm Pre—things that you probably want to do with your webOS application.
If you've never worked with SQL before, this is a good place to start:
When you're ready to practice your SQL statement writing, go here:
That site covers all of the basics, as well as more advanced SQL concepts. It approaches SQL development from the traditional client-server paradigm, in which your SQL statements are written in a server-side language that the client (in this case, the browser) never sees; the commands are processed by the server and only the results are sent to the client.
If you want to dig a little (or a LOT) deeper, Palm has verified that webOS uses SQLite for its database support. While each database engine (e.g. mySQL, PostgreSQL, SQLite) supports standard SQL queries, each has its own quirks and unique ways of implementing various features. Here is an FAQ that explains some of the quirks of SQLite:
If you can think of any other resources we might want to include on this page, please drop us a comment!