mozIStorageConnection

close()

Closes a database connection. C++ callers should simply set the database variable to NULL. since Gecko 1.9 M8

You need to call finalize() on the statement if you have created one before attempting to close or you will get an NS_ERROR_FILE_IS_LOCKED exception.

void close();

createStatement()

Creates a mozIStorageStatement for the given SQL expression. The expression may use "?" to indicate sequentially numbered arguments (?1, ?2, etc) or ":name" and "$var" to indicate named arguments.

 mozIStorageStatement createStatement(
   in AUTF8String aSQLStatement
 );

executeSimpleSQL()

Executes an SQL expression. By default, it doesn't expect any arguments at all.

 void executeSimpleSQL(
   in AUTF8String aSQLStatement
 );

tableExists()

This method reports whether the given table exists or not.

 boolean tableExists(
   in AUTF8String aTableName
 );

indexExists()

This method determines whether or not the given index exists.

 boolean indexExists(
   in AUTF8String aIndexName
 );

beginTransaction()

Starts a new transaction. By default, SQLite defers transactions. If a transaction is already active, this method throws an exception.

^ 

 void beginTransaction();

beginTransactionAs()

This method starts a new transaction of the given transaction type.

 void beginTransactionAs(
   in PRInt32 transactionType
 );

commitTransaction()

This method commits the current transaction.

 void commitTransaction();

rollbackTransaction()

This method rolls back the current transaction. This is essentially an "undo," and returns the database to the state it was in before the transaction began.

 void rollbackTransaction();

createTable()

This method creates a table with the given table name and schema.

^ 

 void createTable(
   in string aTableName,
   in string aTableSchema
 );

createFunction()

Creates a new SQLite function. since Gecko 1.9 M8

 void createFunction(
   in AUTF8String aFunctionName,
   in long aNumArguments,
   in mozIStorageFunction aFunction
 );

createAggregateFunction()

This method creates a new SQLite aggregate function. since Gecko 1.9 M8

 void createAggregateFunction(
   in AUTF8String aFunctionName,
   in long aNumArguments,
   in mozIStorageAggregateFunction aFunction
 );

removeFunction()

Deletes a custom SQLite function; it works with both standard and aggregate functions. since Gecko 1.9 M8

 void removeFunction(
   in AUTF8String aFunctionName
 );

setProgressHandler()

This method sets a progress handler. Only one handler can be registered at a time; if you need more than one, you need to chain them yourself. since Gecko 1.9 M8

 mozIStorageProgressHandler setProgressHandler(
   in PRInt32 aGranularity,
   in mozIStorageProgressHandler aHandler
 );

removeProgressHandler()

Removes a progress handler. since Gecko 1.9 M8

 mozIStorageProgressHandler removeProgressHandler();

preload()

Preloads the database cache by loading pages from the start of the database file until the memory cache (the size of which is specified by PRAGMA cache_size=size) is full or the entire file is read.

The cache must be active on the database for this to work. This means that you must have a transaction open on the connection, or have a transaction open on another connection that shares the same pager cache. This cached data will go away when the transaction is closed.

This preload operation can dramatically speed up read operations because the data is loaded as one large block. Normally, pages are read in on demand, which can cause many disk seeks.

 void preload();

Example: Creating a statement without parameters

rv = mDBConn->ExecuteSimpleSQL(NS_LITERAL_CSTRING("CREATE TABLE foo (a INTEGER)"));

mDBConn.executeSimpleSQL("CREATE TABLE foo (a INTEGER)");

Example: Creating a statement that has parameters

nsCOMPtr<mozIStorageStatement> statement;
rv = mDBConn->CreateStatement(NS_LITERAL_CSTRING("SELECT * FROM foo WHERE a = ?1"),
                              getter_AddRefs(statement));
NS_ENSURE_SUCCESS(rv, rv);

var statement = mDBConn.createStatement("SELECT * FROM foo WHERE a = ?1");