Lines Matching refs:SQLite

1 :mod:`sqlite3` --- DB-API 2.0 interface for SQLite databases
5    :synopsis: A DB-API 2.0 implementation using SQLite 3.x.
11 SQLite is a C library that provides a lightweight disk-based database that
14 SQLite for internal data storage.  It's also possible to prototype an
15 application using SQLite and then port the code to a larger database such as
105       The SQLite web page; the documentation describes the syntax and the
124    the SQLite library.
129    version of the SQLite library.
133    The version number of the run-time SQLite library, as a string.
137    The version number of the run-time SQLite library, as a tuple of integers.
157    Setting this makes the SQLite interface parse the column name for each column it
169    Opens a connection to the SQLite database file *database*. You can use
174    modifies the database, the SQLite database is locked until that transaction is
182    SQLite natively supports only the types TEXT, INTEGER, REAL, BLOB and NULL. If
216    SQLite's supported types. The callable *callable* accepts as single parameter
228    This can be used to build a shell for SQLite, as in the following example:
250    A SQLite database connection has the following attributes and methods:
310       The function can return any of the types supported by SQLite: unicode, str, int,
326       The ``finalize`` method can return any of the types supported by SQLite:
377       Please consult the SQLite documentation about the possible values for the first
385       instructions of the SQLite virtual machine. This is useful if you want to
386       get called from SQLite during long-running operations, for example to update
397       This routine allows/disallows the SQLite engine to load SQLite extensions
398       from shared libraries.  SQLite extensions can define new functions,
400       extension is the fulltext-search extension distributed with SQLite.
410       This routine loads a SQLite extension from a shared library.  You have to
580       With SQLite versions before 3.6.5, :attr:`rowcount` is set to 0 if
600       This read-only attribute provides the SQLite database :class:`Connection`
680 SQLite and Python types
687 SQLite natively supports the following types: ``NULL``, ``INTEGER``,
690 The following Python types can thus be sent to SQLite without any problem:
693 | Python type                 | SQLite type |
710 This is how SQLite types are converted to Python types by default:
713 | SQLite type | Python type                                  |
729 store additional Python types in a SQLite database via object adaptation, and
730 you can let the :mod:`sqlite3` module convert SQLite types to different Python
734 Using adapters to store additional Python types in SQLite databases
737 As described before, SQLite supports only a limited set of types natively. To
738 use other Python types with SQLite, you must **adapt** them to one of the
739 sqlite3 module's supported types for SQLite: one of NoneType, int, long, float,
756 Now you want to store the point in a single SQLite column.  First you'll have to
786 Converting SQLite values to custom Python types
789 Writing an adapter lets you send custom Python types to SQLite. But to make it
790 really useful we need to make the Python to SQLite to Python roundtrip work.
795 separated via semicolons as strings in SQLite.
803    data type you sent the value to SQLite.
830 module. They will be sent as ISO dates/ISO timestamps to SQLite.
838 experimental SQLite date/time functions.
844 If a timestamp stored in SQLite has a fractional part longer than 6
874 statement, or set it to one of SQLite's supported isolation levels: "DEFERRED",
928 Older SQLite versions had issues with sharing connections between threads.
938    default, because some platforms (notably Mac OS X) have SQLite libraries