Package android.database.sqlite

Contains the SQLite database management classes that an application would use to manage its own private database.

See: Description

Interface Summary

Interface	Description
SQLiteCursorDriver	A driver for SQLiteCursors that is used to create them and gets notified by the cursors it creates on significant events in their lifetimes.
SQLiteDatabase.CursorFactory	Used to allow returning sub-classes of Cursor when calling query.
SQLiteDatabase.CustomFunction	A callback interface for a custom sqlite3 function.
SQLiteTransactionListener	A listener for transaction events.

Class Summary

Class	Description
SQLiteClosable	An object created from a SQLiteDatabase that can be closed.
SQLiteConnection	Represents a SQLite database connection.
SQLiteConnectionPool	Maintains a pool of active SQLite database connections.
SQLiteCursor	A Cursor implementation that exposes results from a query on a SQLiteDatabase.
SQLiteCustomFunction	Describes a custom SQL function.
SQLiteDatabase	Exposes methods to manage a SQLite database.
SQLiteDatabaseConfiguration	Describes how to configure a database.
SQLiteDebug	Provides debugging info about all SQLite databases running in the current process.
SQLiteDebug.DbStats	contains statistics about a database
SQLiteDebug.PagerStats	Contains statistics about the active pagers in the current process.
SQLiteDirectCursorDriver	A cursor driver that uses the given query directly.
SQLiteGlobal	Provides access to SQLite functions that affect all database connection, such as memory management.
SQLiteProgram	A base class for compiled SQLite programs.
SQLiteQuery	Represents a query that reads the resulting rows into a SQLiteQuery.
SQLiteQueryBuilder	This is a convience class that helps build SQL queries to be sent to SQLiteDatabase objects.
SQLiteSession	Provides a single client the ability to use a database.
SQLiteStatement	Represents a statement that can be executed against a database.
SQLiteStatementInfo	Describes a SQLite statement.

Exception Summary

Exception	Description
DatabaseObjectNotClosedException	An exception that indicates that garbage-collector is finalizing a database object that is not explicitly closed
SQLiteAbortException	An exception that indicates that the SQLite program was aborted.
SQLiteAccessPermException	This exception class is used when sqlite can't access the database file due to lack of permissions on the file.
SQLiteBindOrColumnIndexOutOfRangeException	Thrown if the the bind or column parameter index is out of range
SQLiteBlobTooBigException
SQLiteCantOpenDatabaseException
SQLiteConstraintException	An exception that indicates that an integrity constraint was violated.
SQLiteDatabaseCorruptException	An exception that indicates that the SQLite database file is corrupt.
SQLiteDatabaseLockedException	Thrown if the database engine was unable to acquire the database locks it needs to do its job.
SQLiteDatatypeMismatchException
SQLiteDiskIOException	An exception that indicates that an IO error occured while accessing the SQLite database file.
SQLiteDoneException	An exception that indicates that the SQLite program is done.
SQLiteException	A SQLite exception that indicates there was an error with SQL parsing or execution.
SQLiteFullException	An exception that indicates that the SQLite database is full.
SQLiteMisuseException	This error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time.
SQLiteOutOfMemoryException
SQLiteReadOnlyDatabaseException
SQLiteTableLockedException

Package android.database.sqlite Description

Contains the SQLite database management classes that an application would use to manage its own private database.

Applications use these classes to manage private databases. If creating a content provider, you will probably have to use these classes to create and manage your own database to store content. See Content Providers to learn the conventions for implementing a content provider. See the NotePadProvider class in the NotePad sample application in the SDK for an example of a content provider. Android ships with SQLite version 3.4.0

If you are working with data sent to you by a provider, you will not use these SQLite classes, but instead use the generic android.database classes.

Android ships with the sqlite3 database tool in the tools/ folder. You can use this tool to browse or run SQL commands on the device. Run by typing sqlite3 in a shell window.