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.
13 SQLite is a C library that provides a lightweight disk-based database that
16 SQLite for internal data storage. It's also possible to prototype an
17 application using SQLite and then port the code to a larger database such as
107 The SQLite web page; the documentation describes the syntax and the
126 the SQLite library.
132 version of the SQLite library.
137 The version number of the run-time SQLite library, as a string.
142 The version number of the run-time SQLite library, as a tuple of integers.
163 Setting this makes the SQLite interface parse the column name for each column it
176 Opens a connection to the SQLite database file *database*. By default returns a
185 modifies the database, the SQLite database is locked until that transaction is
193 SQLite natively supports only the types TEXT, INTEGER, REAL, BLOB and NULL. If
226 be found in the `SQLite URI documentation <https://www.sqlite.org/uri.html>`_.
249 SQLite's supported types. The callable *callable* accepts as single parameter
261 This can be used to build a shell for SQLite, as in the following example:
283 A SQLite database connection has the following attributes and methods:
351 allows SQLite to perform additional optimizations. This flag is supported by
352 SQLite 3.8.3 or higher, :exc:`NotSupportedError` will be raised if used
355 The function can return any of the types supported by SQLite: bytes, str, int,
375 The ``finalize`` method can return any of the types supported by SQLite:
426 Please consult the SQLite documentation about the possible values for the first
434 instructions of the SQLite virtual machine. This is useful if you want to
435 get called from SQLite during long-running operations, for example to update
449 actually executed by the SQLite backend.
464 This routine allows/disallows the SQLite engine to load SQLite extensions
465 from shared libraries. SQLite extensions can define new functions,
467 extension is the fulltext-search extension distributed with SQLite.
477 This routine loads a SQLite extension from a shared library. You have to
548 This method makes a backup of a SQLite database even while it's being accessed
594 Availability: SQLite 3.6.11 or higher
704 With SQLite versions before 3.6.5, :attr:`rowcount` is set to 0 if
736 This read-only attribute provides the SQLite database :class:`Connection`
858 SQLite and Python types
865 SQLite natively supports the following types: ``NULL``, ``INTEGER``,
868 The following Python types can thus be sent to SQLite without any problem:
871 | Python type | SQLite type |
885 This is how SQLite types are converted to Python types by default:
888 | SQLite type | Python type |
903 store additional Python types in a SQLite database via object adaptation, and
904 you can let the :mod:`sqlite3` module convert SQLite types to different Python
908 Using adapters to store additional Python types in SQLite databases
911 As described before, SQLite supports only a limited set of types natively. To
912 use other Python types with SQLite, you must **adapt** them to one of the
913 sqlite3 module's supported types for SQLite: one of NoneType, int, float,
930 Now you want to store the point in a single SQLite column. First you'll have to
955 Converting SQLite values to custom Python types
958 Writing an adapter lets you send custom Python types to SQLite. But to make it
959 really useful we need to make the Python to SQLite to Python roundtrip work.
964 separated via semicolons as strings in SQLite.
972 matter under which data type you sent the value to SQLite.
999 module. They will be sent as ISO dates/ISO timestamps to SQLite.
1007 experimental SQLite date/time functions.
1013 If a timestamp stored in SQLite has a fractional part longer than 6
1100 Older SQLite versions had issues with sharing connections between threads.
1110 default, because some platforms (notably Mac OS X) have SQLite