Database API Reference Guide now available

Gold triangle pattern background, 3d rendering

Today we’ve published the Database API Reference Guide. It’s available at:

http://developer.appcelerator.com/doc/reference_guides

This covers the basics of using the SQLite database from within Titanium Mobile, and offers some advanced techniques as well. Over time, we’ll be continuing to enhance these guides with additional code samples, so please let us know what you think of these new guides.

1 COMMENT

  1. Is there an API to pass in an array of parameters for parameterized statements, something like:

    var valArray = [100, ‘mkv’, true];
    db.execute(‘insert into mytable (f1, f2, f3) values ?, ?, ?’, valArray);

    The reason for this is to allow us to create generic DB handlers that can deal with exceptions in a unified manner. If I pass in a SQL string with an array of values, the generic handler can run the exec and deal with errors, but this is hard if you have to use varargs for the execute() call.