Search.setIndex({"docnames": ["apsw", "backup", "benchmarking", "blob", "build", "changes", "connection", "copyright", "cursor", "dbapi", "download", "example", "exceptions", "execution", "ext", "extensions", "index", "pysqlite", "shell", "tips", "types", "vfs", "vtable"], "filenames": ["apsw.rst", "backup.rst", "benchmarking.rst", "blob.rst", "build.rst", "changes.rst", "connection.rst", "copyright.rst", "cursor.rst", "dbapi.rst", "download.rst", "example.rst", "exceptions.rst", "execution.rst", "ext.rst", "extensions.rst", "index.rst", "pysqlite.rst", "shell.rst", "tips.rst", "types.rst", "vfs.rst", "vtable.rst"], "titles": ["APSW Module", "Backup", "Benchmarking", "Blob Input/Output", "Building", "Change History", "Connections to a database", "Copyright and License", "Cursors (executing SQL)", "DBAPI notes", "Download", "Example/Tour", "Exceptions", "Execution and tracing", "Various interesting and useful bits of functionality", "Extensions", "APSW documentation", "sqlite3 module differences", "Shell", "Tips", "Types", "Virtual File System (VFS)", "Virtual Tables"], "terms": {"The": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "i": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 20, 21, 22], "main": [0, 1, 4, 5, 6, 11, 13, 14, 18, 21, 22], "interfac": [0, 5, 6, 15, 16, 18, 20, 21, 22], "method": [0, 1, 3, 4, 5, 6, 8, 9, 12, 13, 14, 17, 18, 19, 21, 22], "data": [0, 2, 3, 5, 6, 8, 11, 12, 14, 15, 17, 18, 19, 21, 22], "have": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22], "process": [0, 1, 4, 5, 6, 10, 11, 13, 18, 19, 21, 22], "wide": [0, 5, 17, 19], "effect": [0, 1, 5, 6, 11, 14, 19], "comprehens": 0, "ar": [0, 1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "includ": [0, 1, 2, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "your": [0, 1, 2, 3, 4, 5, 6, 8, 9, 12, 13, 14, 16, 17, 18, 20, 21, 22], "code": [0, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "us": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22], "can": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "check": [0, 4, 5, 10, 13, 16, 17, 21, 22], "tool": [0, 2, 4, 5, 10, 14], "like": [0, 3, 4, 5, 6, 8, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "mypi": [0, 14], "you": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "below": [0, 4, 11, 21, 22], "eg": [0, 2, 3, 4, 5, 6, 8, 11, 12, 13, 14, 18, 19, 20, 21, 22], "sqlitevalu": [0, 8, 11, 14, 22], "class": [0, 5, 9, 11, 12, 14, 16, 20], "union": [0, 3, 21], "none": [0, 1, 3, 5, 6, 8, 9, 11, 12, 13, 14, 18, 19, 20, 21, 22], "int": [0, 1, 3, 5, 6, 8, 11, 14, 18, 20, 21, 22], "float": [0, 9, 11, 14, 18, 20, 21], "byte": [0, 1, 3, 5, 6, 9, 11, 14, 18, 19, 20, 21], "str": [0, 5, 6, 8, 11, 12, 13, 14, 18, 20, 21, 22], "support": [0, 4, 5, 6, 8, 9, 11, 12, 14, 16, 17, 18, 19, 20, 21, 22], "5": [0, 2, 3, 4, 6, 8, 11, 12, 14, 16, 17, 22], "null": [0, 5, 8, 11, 12, 14, 18, 19, 20, 21], "64": [0, 2, 4, 5, 6, 12, 16, 20, 21, 22], "bit": [0, 2, 4, 5, 6, 16, 17, 20, 21, 22], "sign": [0, 4, 5, 6, 10, 20], "unicod": [0, 2, 4, 5, 6, 11, 15, 16, 21, 22], "text": [0, 2, 4, 5, 6, 8, 11, 13, 14, 15, 18, 19, 20, 21], "tupl": [0, 6, 8, 11, 12, 13, 14, 18, 19, 21, 22], "A": [0, 1, 2, 3, 4, 5, 6, 8, 11, 12, 13, 14, 18, 19, 20, 21, 22], "sequenc": [0, 3, 6, 8, 14, 16, 18, 20, 22], "zero": [0, 1, 2, 3, 5, 6, 9, 11, 12, 13, 14, 18, 19, 21, 22], "more": [0, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 16, 17, 18, 19, 21, 22], "bind": [0, 2, 5, 6, 8, 12, 13, 14, 16, 18, 20, 21], "zeroblob": [0, 11, 16], "map": [0, 5, 8, 13, 14, 16, 18, 21, 22], "queri": [0, 2, 5, 6, 8, 12, 13, 16, 17, 18, 19, 21, 22], "either": [0, 3, 5, 8, 12, 14, 18, 19, 20, 22], "dict": [0, 5, 6, 8, 12, 14, 16, 18], "name": [0, 2, 5, 6, 8, 9, 12, 13, 16, 17, 18, 19, 20, 21, 22], "also": [0, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 21, 22], "provid": [0, 1, 3, 4, 5, 6, 7, 10, 13, 14, 15, 16, 17, 18, 19, 21, 22], "subclass": [0, 5, 18, 20], "ani": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 14, 17, 18, 19, 21, 22], "regist": [0, 5, 6, 11, 12, 13, 14, 17, 21, 22], "collect": [0, 5, 6, 8, 11, 14], "abc": [0, 5, 13, 14], "aggregatet": 0, "an": [0, 1, 3, 4, 5, 6, 7, 8, 9, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "object": [0, 1, 3, 5, 6, 8, 11, 12, 13, 14, 16, 18, 19, 21, 22], "first": [0, 3, 4, 5, 6, 8, 11, 13, 14, 18, 21, 22], "paramet": [0, 1, 2, 3, 5, 6, 8, 9, 11, 12, 14, 18, 19, 21, 22], "step": [0, 1, 4, 5, 6, 10, 11, 13, 14, 15, 19, 22], "final": [0, 1, 4, 5, 6, 11], "aggreg": [0, 5, 6, 13, 16], "function": [0, 3, 4, 5, 6, 8, 9, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22], "aggregatestep": 0, "callabl": [0, 6, 8, 14, 19], "call": [0, 1, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 21, 22], "each": [0, 2, 5, 6, 8, 11, 12, 13, 14, 17, 18, 19, 21, 22], "match": [0, 5, 6, 11, 16, 18, 21], "row": [0, 2, 3, 5, 6, 8, 9, 16, 17, 18, 19, 22], "relev": [0, 4, 5, 6, 18], "number": [0, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 15, 18, 21, 22], "aggregatefin": 0, "after": [0, 1, 3, 4, 5, 6, 8, 11, 13, 14, 18, 19, 21, 22], "all": [0, 1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "been": [0, 1, 5, 6, 8, 10, 11, 13, 18, 19, 21], "return": [0, 1, 2, 3, 4, 5, 6, 8, 9, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "aggregatefactori": [0, 6], "time": [0, 1, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 15, 16, 17, 18, 19, 21, 22], "start": [0, 3, 5, 6, 8, 9, 10, 11, 12, 13, 14, 18, 19, 21, 22], "new": [0, 3, 4, 5, 6, 8, 12, 13, 14, 18, 19, 21, 22], "calcul": [0, 9, 11, 13, 19], "scalarprotocol": [0, 6], "scalar": [0, 6, 11, 12, 17, 22], "callback": [0, 5, 6, 11, 12, 13, 17, 19], "take": [0, 1, 2, 4, 5, 6, 11, 13, 15, 20, 21, 22], "rowtrac": [0, 5, 6, 8, 11, 13, 14, 19], "cursor": [0, 1, 2, 4, 5, 6, 11, 12, 13, 14, 16, 17, 21, 22], "tracer": [0, 5, 6, 8, 12, 14, 19], "would": [0, 2, 3, 5, 6, 7, 8, 9, 11, 12, 13, 14, 17, 18, 19, 21], "If": [0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 18, 19, 20, 21, 22], "otherwis": [0, 1, 2, 4, 5, 6, 18], "whatev": [0, 6, 8, 13, 17, 21], "result": [0, 3, 4, 5, 6, 8, 9, 12, 13, 16, 17, 18, 19, 20, 21, 22], "exectrac": [0, 5, 6, 8, 11, 13], "option": [0, 1, 2, 3, 5, 6, 8, 10, 11, 13, 14, 16, 18, 19, 21, 22], "bool": [0, 1, 3, 6, 8, 11, 14, 21, 22], "execut": [0, 2, 3, 4, 5, 6, 9, 12, 14, 16, 17, 18, 19, 21, 22], "sql": [0, 1, 2, 4, 5, 6, 12, 13, 15, 16, 17, 18, 20, 21, 22], "fals": [0, 1, 2, 3, 5, 6, 8, 11, 12, 13, 14, 18, 21, 22], "abort": [0, 4, 5, 6, 11, 13, 18, 19], "true": [0, 1, 4, 5, 6, 8, 11, 13, 14, 18, 21, 22], "continu": [0, 4, 6, 11, 12, 14, 18], "author": [0, 5, 6, 7, 12, 13, 14, 16], "oper": [0, 4, 5, 6, 9, 11, 12, 14, 19, 21, 22], "4": [0, 2, 4, 6, 8, 9, 11, 12, 13, 16, 17, 22], "string": [0, 2, 5, 6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "which": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "could": [0, 4, 5, 6, 8, 11, 13, 14, 19, 21, 22], "depend": [0, 4, 5, 6, 10, 11, 13, 14, 17, 20], "operat": 0, "sqlite_ok": [0, 6, 11], "sqlite_deni": [0, 6, 11], "sqlite_ignor": [0, 6, 11], "commithook": [0, 6], "commit": [0, 1, 5, 6, 8, 9, 16, 19, 21, 22], "hook": [0, 5, 6, 13, 16, 21], "argument": [0, 5, 6, 11, 12, 13, 18, 21, 22], "should": [0, 2, 3, 4, 5, 6, 8, 9, 12, 13, 16, 18, 20, 21, 22], "let": [0, 5, 8, 11, 13, 17, 21, 22], "sqlite_version_numb": [0, 11], "integ": [0, 5, 6, 8, 11, 12, 18, 20, 21, 22], "version": [0, 2, 4, 5, 7, 8, 10, 12, 15, 16, 18, 21], "wa": [0, 4, 5, 6, 8, 11, 12, 13, 18, 19, 21, 22], "compil": [0, 4, 5, 8, 10, 11, 13, 15, 16, 18, 20], "against": [0, 4, 5, 6, 11, 13, 14], "For": [0, 2, 3, 4, 5, 6, 8, 11, 12, 13, 14, 17, 18, 19, 21, 22], "exampl": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 12, 13, 14, 16, 17, 19, 20, 21, 22], "3": [0, 2, 3, 6, 8, 9, 10, 11, 12, 13, 14, 16, 17, 19, 20, 21, 22], "6": [0, 4, 6, 11, 16, 17, 21], "valu": [0, 1, 2, 3, 4, 5, 6, 8, 9, 12, 13, 14, 16, 17, 18, 20, 21, 22], "3006004": 0, "thi": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "mai": [0, 1, 2, 3, 4, 5, 6, 7, 10, 12, 13, 14, 18, 19, 20, 21, 22], "differ": [0, 2, 3, 4, 5, 6, 8, 9, 12, 13, 16, 18, 20, 21, 22], "than": [0, 2, 3, 4, 5, 6, 12, 13, 17, 18, 19, 21, 22], "actual": [0, 4, 6, 9, 13, 20, 21, 22], "librari": [0, 4, 5, 6, 11, 12, 16, 17, 18, 19, 20, 21], "share": [0, 5, 6, 11, 16, 21], "ha": [0, 1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 17, 18, 19, 20, 21, 22], "updat": [0, 4, 5, 6, 8, 9, 13, 15, 16, 21, 22], "sqlitelibvers": [0, 6, 11], "get": [0, 1, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "apswvers": [0, 5, 11], "compile_opt": [0, 5], "someth": [0, 6, 10, 11, 18, 20, 22], "enable_locking_styl": 0, "0": [0, 2, 3, 4, 6, 8, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19, 21, 22], "temp_stor": 0, "1": [0, 1, 2, 3, 4, 6, 8, 10, 11, 12, 13, 16, 17, 18, 19, 22], "threadsaf": [0, 5], "sqlite3_compileoption_get": 0, "complet": [0, 1, 5, 6, 8, 11, 12, 13, 18, 19, 21, 22], "statement": [0, 1, 2, 3, 5, 6, 8, 9, 11, 12, 14, 16, 17, 18, 19, 20, 22], "input": [0, 5, 6, 12, 16, 18, 20], "compris": 0, "one": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 18, 19, 20, 21, 22], "look": [0, 4, 6, 8, 11, 14, 16, 18], "unquot": 0, "trail": [0, 5, 8, 10, 18], "semi": [0, 8, 13, 17, 18], "colon": [0, 8, 13, 17, 18], "were": [0, 1, 2, 4, 5, 6, 8, 12, 14, 18, 21, 22], "prompt": [0, 5, 18], "user": [0, 4, 5, 6, 11, 12, 13, 17, 18, 20, 21, 22], "need": [0, 1, 3, 4, 5, 6, 8, 9, 11, 12, 14, 15, 17, 18, 19, 20, 21, 22], "know": [0, 4, 5, 6, 11, 19, 20, 21, 22], "had": [0, 5, 6, 8, 12, 13, 18, 22], "whole": [0, 13, 19], "ask": [0, 4, 5, 9, 11, 19, 20, 22], "anoth": [0, 1, 4, 6, 8, 11, 12, 13, 21], "line": [0, 2, 4, 5, 6, 10, 12, 13, 16, 17, 19], "while": [0, 1, 2, 4, 6, 8, 11, 12, 13, 18, 19, 22], "n": [0, 2, 6, 11, 13], "sqlite3_complet": 0, "config": [0, 4, 5, 6, 19], "op": [0, 5, 6, 11, 21], "arg": [0, 6, 11, 12, 18, 21, 22], "configur": [0, 4, 5, 6, 10, 16, 18, 19], "appropri": [0, 1, 4, 5, 6, 9, 18, 21, 22], "mani": [0, 1, 2, 4, 5, 6, 8, 11, 12, 13, 14, 18, 19, 21, 22], "don": [0, 4, 5, 6, 8, 9, 12, 13, 17, 18, 19, 20, 21, 22], "t": [0, 1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "make": [0, 2, 4, 5, 6, 8, 9, 11, 12, 13, 14, 15, 17, 18, 19, 21, 22], "sens": [0, 9, 19, 22], "from": [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "python": [0, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 16, 17, 18, 20, 21, 22], "program": [0, 5, 6, 13, 14, 18, 19, 22], "follow": [0, 4, 5, 6, 7, 11, 12, 13, 14, 17, 18], "sqlite_config_log": [0, 5, 19], "sqlite_config_singlethread": 0, "sqlite_config_multithread": 0, "sqlite_config_seri": 0, "sqlite_config_uri": [0, 5], "sqlite_config_memstatu": 0, "sqlite_config_covering_index_scan": [0, 5], "sqlite_config_pcache_hdrsz": [0, 5], "sqlite_config_pmasz": [0, 5], "sqlite_config_stmtjrnl_spil": [0, 5], "see": [0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21], "tip": [0, 5, 16], "how": [0, 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22], "receiv": [0, 5, 21, 22], "log": [0, 5, 6, 11, 13, 16, 21], "messag": [0, 2, 5, 9, 13, 18, 19, 21], "sqlite3_config": [0, 5], "connection_hook": [0, 5, 6, 13, 19], "list": [0, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 18, 19, 21, 22], "connect": [0, 1, 3, 5, 8, 11, 12, 13, 14, 16, 17, 18, 21, 22], "purpos": [0, 5, 7, 18, 22], "allow": [0, 1, 3, 4, 5, 6, 8, 9, 11, 14, 17, 18, 19], "easi": [0, 5, 11, 13, 15, 17, 18, 19, 21], "registr": [0, 11], "virtual": [0, 5, 6, 8, 12, 16, 17], "tabl": [0, 2, 4, 5, 6, 8, 12, 13, 14, 15, 16, 17, 18, 19, 21], "similar": [0, 4, 5, 11, 12, 16, 18, 22], "item": [0, 2, 4, 5, 6, 8, 11, 12, 13, 14, 18, 21, 22], "creat": [0, 1, 3, 4, 5, 6, 8, 10, 11, 12, 13, 14, 17, 18, 19, 21, 22], "default": [0, 1, 2, 3, 4, 5, 6, 11, 12, 13, 15, 17, 18, 19, 20, 21, 22], "empti": [0, 3, 5, 6, 12, 18, 21, 22], "whenev": [0, 6, 15], "invok": [0, 5, 6, 18], "singl": [0, 2, 4, 5, 8, 11, 13, 18, 19], "being": [0, 3, 4, 5, 6, 7, 8, 11, 12, 13, 17, 19, 20, 21, 22], "rais": [0, 3, 6, 8, 9, 13, 14, 17, 18, 21, 22], "except": [0, 1, 3, 5, 6, 8, 9, 11, 13, 16, 17, 18, 19, 20, 22], "creation": [0, 1], "fail": [0, 5, 12, 19, 21], "want": [0, 3, 4, 5, 6, 8, 10, 11, 13, 14, 16, 17, 18, 19, 20, 21, 22], "store": [0, 3, 9, 14, 15, 18, 21, 22], "own": [0, 2, 5, 6, 12, 13, 16, 17, 18, 19, 21, 22], "defin": [0, 1, 3, 4, 5, 6, 8, 9, 12, 13, 14, 16, 17, 20, 21], "databas": [0, 1, 2, 3, 4, 5, 8, 12, 13, 14, 15, 16, 17, 18, 20, 21, 22], "got": [0, 5, 6, 11, 12], "turn": [0, 4, 5, 6, 11, 12, 13, 17, 18, 19, 21], "enablesharedcach": 0, "enabl": [0, 4, 5, 6, 10, 15, 18, 20], "same": [0, 1, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 17, 18, 19, 20, 21, 22], "across": [0, 2, 5, 6, 8, 13, 14, 17, 21], "thread": [0, 4, 5, 6, 8, 9, 12, 16, 17, 18, 21], "multipl": [0, 1, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 20, 21, 22], "access": [0, 1, 2, 3, 5, 6, 12, 13, 16, 17, 19, 21, 22], "file": [0, 2, 3, 4, 5, 6, 10, 12, 13, 16, 17, 18, 19, 22], "cach": [0, 2, 5, 6, 8, 11, 14, 16, 22], "between": [0, 2, 4, 5, 12, 18, 20, 21, 22], "them": [0, 4, 5, 6, 8, 11, 13, 14, 15, 17, 18, 19, 20, 21], "It": [0, 1, 3, 4, 5, 6, 8, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22], "recommend": [0, 5, 8, 10, 16, 19], "sqlite3_enable_shared_cach": [0, 5], "exceptionfor": [0, 21, 22], "correspond": [0, 4, 5, 6, 9, 10, 12, 14, 17, 19, 20, 21, 22], "particular": [0, 6, 9, 15, 18, 19, 22], "error": [0, 1, 3, 4, 5, 6, 8, 9, 13, 16, 17, 18, 19, 22], "understand": [0, 2, 4, 8, 11, 18], "extend": [0, 5, 12, 17, 18, 19], "sqlite_ioerr_access": [0, 5], "fork_check": [0, 5, 12], "note": [0, 2, 3, 4, 5, 6, 8, 11, 12, 13, 15, 16, 19, 20, 21, 22], "avail": [0, 3, 5, 6, 8, 9, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22], "window": [0, 4, 5, 10, 18, 21], "doe": [0, 1, 2, 4, 5, 6, 8, 9, 11, 12, 13, 14, 16, 18, 19, 20, 21], "fork": [0, 5], "system": [0, 2, 4, 5, 6, 12, 16, 17, 19], "faq": 0, "q6": 0, "child": 0, "duplic": [0, 5, 14, 22], "parent": [0, 6], "state": [0, 6, 8, 18], "structur": [0, 5, 22], "do": [0, 2, 3, 4, 5, 6, 8, 9, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22], "both": [0, 4, 5, 8, 11, 18, 19, 20], "consid": [0, 6, 12, 14, 19, 21], "themselv": 0, "owner": 0, "open": [0, 3, 5, 6, 7, 8, 12, 13, 16, 18, 19, 21, 22], "silent": [0, 2, 8, 17], "corrupt": [0, 6], "other": [0, 1, 2, 4, 5, 6, 8, 9, 10, 11, 12, 13, 17, 18, 19, 21, 22], "": [0, 2, 4, 5, 6, 8, 9, 11, 13, 14, 16, 17, 18, 19, 20, 21, 22], "work": [0, 2, 3, 4, 5, 6, 8, 11, 12, 13, 15, 16, 17, 18, 19, 22], "interfer": 0, "lock": [0, 1, 5, 6, 9, 12, 13, 17, 18, 19, 21], "One": [0, 5, 6, 8, 19, 21], "end": [0, 3, 5, 6, 8, 9, 11, 13, 17, 18, 19, 22], "up": [0, 1, 4, 5, 6, 10, 11, 12, 13, 14, 17, 19, 21, 22], "multiprocess": [0, 5], "platform": [0, 4, 5, 6, 10], "must": [0, 1, 2, 4, 5, 6, 7, 8, 11, 12, 15, 19, 20, 21, 22], "ensur": [0, 1, 2, 4, 5, 6, 11, 19, 21], "backup": [0, 5, 6, 16, 17, 18], "blob": [0, 1, 5, 6, 9, 12, 13, 16, 17, 20], "etc": [0, 4, 5, 6, 8, 11, 13, 14, 17, 18, 19, 20, 21, 22], "close": [0, 1, 3, 5, 6, 8, 11, 12, 13, 18, 21, 22], "befor": [0, 1, 2, 3, 5, 6, 8, 11, 12, 13, 15, 18, 19, 21, 22], "underli": [0, 2, 3, 5, 6, 14, 21, 22], "good": [0, 5, 6, 10, 11, 17, 19, 20], "idea": [0, 5, 6, 19], "gc": 0, "2": [0, 2, 3, 4, 6, 8, 11, 12, 13, 16, 17, 19, 22], "anyth": [0, 8, 19, 20, 21, 22], "miss": [0, 4, 6, 8, 12, 21], "dealloc": 0, "onc": [0, 3, 4, 6, 8, 13, 19, 21, 22], "run": [0, 2, 4, 5, 6, 8, 11, 12, 13, 14, 17, 18, 19, 22], "extra": [0, 1, 4, 5, 18, 19], "insert": [0, 2, 3, 6, 8, 9, 11, 12, 13, 17, 18, 19, 22], "mutex": [0, 4, 5, 13, 17], "veri": [0, 3, 5, 6, 8, 11, 13, 17, 18, 19], "small": [0, 2, 3, 4, 5, 18], "perform": [0, 2, 5, 6, 12, 18, 19, 22], "penalti": 0, "verifi": [0, 4, 5, 6, 12, 13, 16, 18], "forkingviolationerror": [0, 12], "so": [0, 1, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 17, 18, 19, 21, 22], "due": [0, 5, 6, 12, 14], "wai": [0, 2, 3, 4, 5, 6, 8, 9, 10, 11, 13, 14, 15, 16, 17, 18, 19, 21, 22], "intern": [0, 4, 5, 6, 13, 14, 15, 18, 21], "deliv": 0, "sy": [0, 4, 5, 11, 12, 18, 21], "excepthook": [0, 5, 21], "addit": [0, 5, 6, 8, 11, 12, 14, 15, 16, 17, 18, 19, 22], "normal": [0, 2, 3, 5, 6, 8, 11, 13, 17, 19, 21, 22], "mechan": [0, 5, 11, 22], "report": [0, 3, 4, 5, 13, 17], "where": [0, 4, 5, 8, 9, 11, 12, 13, 18, 19, 20, 21, 22], "issu": [0, 4, 5, 6, 8, 12, 13, 15, 17, 19, 21], "aros": [0, 5], "destructor": [0, 5, 22], "didn": [0, 5, 13], "onli": [0, 1, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 14, 18, 19, 20, 21, 22], "import": [0, 5, 10, 11, 12, 14, 16, 17, 18], "shutdown": [0, 21], "re": [0, 3, 4, 5, 6, 16, 19], "initi": [0, 5, 6, 18, 22], "alreadi": [0, 3, 5, 8, 18, 21, 22], "alloc": [0, 3, 4, 5, 11, 12, 13], "when": [0, 2, 3, 4, 5, 6, 8, 9, 11, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22], "later": [0, 4, 5, 6, 11, 16], "crash": [0, 5, 6, 11, 17, 19], "part": [0, 4, 5, 6, 11, 12, 17, 18, 21, 22], "test": [0, 2, 5, 11, 12, 13, 16, 17, 19, 21], "suit": [0, 4, 5, 13, 17], "format_sql_valu": [0, 5], "repres": [0, 3, 6, 9, 11, 14, 20, 21], "suppli": [0, 2, 3, 5, 6, 8, 11, 12, 13, 14, 18, 20, 21], "syntax": [0, 5, 8, 13], "unlik": [0, 8], "automat": [0, 4, 5, 6, 8, 11, 13, 18, 19, 21], "sqlite3_initi": [0, 5], "keyword": [0, 5], "set": [0, 3, 4, 5, 6, 8, 10, 11, 13, 14, 18, 19, 21, 22], "contain": [0, 5, 6, 8, 11, 18, 22], "everi": [0, 5, 6, 8, 11, 12, 17, 19, 21, 22], "sqlite3_keyword_count": 0, "sqlite3_keyword_nam": 0, "errorcod": 0, "format": [0, 5, 11, 12, 18, 19, 22], "pass": [0, 4, 5, 6, 8, 11, 12, 18, 19, 21, 22], "sqlite_nomem": [0, 12], "f": [0, 11, 12], "memori": [0, 2, 4, 5, 6, 11, 13, 14, 17, 19, 21, 22], "sqlite3_log": 0, "memoryhighwat": 0, "reset": [0, 6, 11, 21], "maximum": [0, 2, 3, 5, 6, 9, 11, 21], "amount": [0, 3, 5, 6, 9, 11, 13, 19, 21], "high": [0, 5], "water": 0, "mark": [0, 7, 19, 21], "current": [0, 3, 4, 5, 6, 8, 18, 20, 21, 22], "statu": [0, 5, 6, 11], "sqlite3_memory_highwat": [0, 5], "memoryus": 0, "sqlite3_memory_us": [0, 5], "random": [0, 5, 6, 11, 20, 21], "gener": [0, 4, 5, 11, 13, 16, 18, 19, 20, 21, 22], "sqlite3_random": [0, 5], "releasememori": 0, "request": [0, 3, 5, 8, 9, 10, 12, 18, 19, 21, 22], "try": [0, 1, 2, 4, 5, 8, 11, 12, 13, 17, 18, 19, 22], "free": [0, 1, 5, 6], "freed": [0, 6], "sqlite3_release_memori": [0, 5], "realli": [0, 8, 11], "bad": [0, 4, 5, 8, 11, 12, 19], "unless": [0, 2, 4, 5, 6, 12, 17, 18], "absolut": [0, 3, 5, 21], "sure": [0, 18], "vf": [0, 5, 6, 12, 13, 16, 17, 19], "delet": [0, 5, 6, 10, 11, 21, 22], "garbag": [0, 5, 6, 8, 11], "sqlite3_shutdown": [0, 5], "softheaplimit": [0, 5], "limit": [0, 5, 6, 12, 13, 16, 19, 20], "keep": [0, 2, 5, 6, 19, 22], "usag": [0, 1, 2, 4, 5, 6, 11, 12, 13, 16, 21], "previou": [0, 5, 12, 13], "sqlite3_soft_heap_limit64": [0, 5], "sqlite3_sourceid": [0, 5], "exact": [0, 14, 20], "checkin": 0, "inform": [0, 4, 5, 6, 8, 9, 11, 12, 16, 18, 19, 22], "sourc": [0, 1, 5, 6, 7, 11, 14, 16, 17, 18, 19], "sqlite3_libvers": 0, "highwat": [0, 6], "measur": [0, 6, 17], "sqlite3_status64": 0, "using_amalgam": [0, 5, 11], "amalgam": [0, 4, 5, 11], "static": [0, 4, 5, 8, 11, 17], "mean": [0, 1, 4, 5, 6, 11, 13, 18, 19, 21, 22], "affect": [0, 5, 6, 14, 18], "vfsname": [0, 11, 21], "instal": [0, 4, 5, 6, 8, 10, 13, 18], "variou": [0, 4, 5, 10, 11, 12, 13, 16, 17, 18, 19, 20], "To": [0, 3, 4, 5, 9, 10, 11, 14, 18, 19, 21, 22], "just": [0, 3, 4, 5, 6, 10, 11, 13, 14, 17, 18, 19, 21, 22], "context": [0, 1, 3, 5, 6, 17], "sqlite_create_index": 0, "group": 0, "numer": [0, 6, 9, 12, 21], "These": [0, 4, 5, 6, 10, 19, 22], "help": [0, 2, 4, 5, 10, 11, 13, 18, 21, 22], "improv": [0, 5, 17, 19], "diagnost": [0, 5, 13, 16, 17, 18], "mapping_authorizer_funct": [0, 11, 14], "sqlite_read": [0, 11], "20": [0, 6, 11, 16], "mapping_access": 0, "flag": [0, 5, 6, 8, 11, 12, 13, 15, 16, 21], "xaccess": [0, 21], "sqlite_access_exist": 0, "sqlite_access_read": 0, "sqlite_access_readwrit": 0, "action": [0, 6, 11, 14], "sqlite_alter_t": [0, 5], "sqlite_analyz": 0, "sqlite_attach": 0, "sqlite_copi": [0, 5], "sqlite_create_t": [0, 11], "sqlite_create_temp_index": 0, "sqlite_create_temp_t": 0, "sqlite_create_temp_trigg": 0, "sqlite_create_temp_view": 0, "sqlite_create_trigg": 0, "sqlite_create_view": 0, "sqlite_create_vt": [0, 5], "sqlite_delet": [0, 6, 11], "sqlite_detach": 0, "sqlite_drop_index": 0, "sqlite_drop_t": 0, "sqlite_drop_temp_index": 0, "sqlite_drop_temp_t": 0, "sqlite_drop_temp_trigg": 0, "sqlite_drop_temp_view": 0, "sqlite_drop_trigg": 0, "sqlite_drop_view": 0, "sqlite_drop_vt": [0, 5], "sqlite_funct": [0, 5], "sqlite_insert": [0, 6, 11], "sqlite_pragma": 0, "sqlite_recurs": [0, 5], "sqlite_reindex": [0, 5], "sqlite_savepoint": [0, 5], "sqlite_select": [0, 11, 14], "sqlite_transact": 0, "sqlite_upd": [0, 6, 11], "mapping_authorizer_return": 0, "mapping_bestindex_constraint": 0, "constraint": [0, 5, 12, 22], "sqlite_index_constraint_eq": [0, 22], "sqlite_index_constraint_funct": [0, 5], "sqlite_index_constraint_g": 0, "sqlite_index_constraint_glob": [0, 5], "sqlite_index_constraint_gt": [0, 22], "sqlite_index_constraint_i": [0, 5], "sqlite_index_constraint_isnot": [0, 5], "sqlite_index_constraint_isnotnul": [0, 5], "sqlite_index_constraint_isnul": [0, 5], "sqlite_index_constraint_l": [0, 22], "sqlite_index_constraint_lik": [0, 5], "sqlite_index_constraint_limit": [0, 5], "sqlite_index_constraint_lt": 0, "sqlite_index_constraint_match": 0, "sqlite_index_constraint_n": [0, 5], "sqlite_index_constraint_offset": [0, 5], "sqlite_index_constraint_regexp": [0, 5], "mapping_config": 0, "sqlite_config_getmalloc": 0, "sqlite_config_getmutex": 0, "sqlite_config_getpcach": 0, "sqlite_config_getpcache2": [0, 5], "sqlite_config_heap": 0, "sqlite_config_lookasid": 0, "sqlite_config_malloc": 0, "sqlite_config_memdb_maxs": [0, 5], "sqlite_config_mmap_s": 0, "sqlite_config_mutex": 0, "sqlite_config_pagecach": 0, "sqlite_config_pcach": 0, "sqlite_config_pcache2": 0, "sqlite_config_scratch": 0, "sqlite_config_small_malloc": [0, 5], "sqlite_config_sorterref_s": 0, "sqlite_config_sqllog": [0, 5], "sqlite_config_win32_heaps": [0, 5], "mapping_conflict_resolution_mod": 0, "conflict": [0, 5], "resolut": [0, 5], "mode": [0, 5, 6, 11, 16, 18], "sqlite_abort": [0, 12], "sqlite_fail": 0, "sqlite_replac": 0, "sqlite_rollback": 0, "mapping_db_config": 0, "sqlite_dbconfig_defens": [0, 5], "sqlite_dbconfig_dqs_ddl": [0, 5], "sqlite_dbconfig_dqs_dml": [0, 5], "sqlite_dbconfig_enable_fkei": 0, "sqlite_dbconfig_enable_fts3_token": [0, 5], "sqlite_dbconfig_enable_load_extens": [0, 5], "sqlite_dbconfig_enable_qpsg": [0, 5], "sqlite_dbconfig_enable_trigg": 0, "sqlite_dbconfig_enable_view": [0, 5], "sqlite_dbconfig_legacy_alter_t": [0, 5], "sqlite_dbconfig_legacy_file_format": [0, 5], "sqlite_dbconfig_lookasid": 0, "sqlite_dbconfig_maindbnam": [0, 5], "sqlite_dbconfig_max": [0, 5], "sqlite_dbconfig_no_ckpt_on_clos": [0, 5], "sqlite_dbconfig_reset_databas": [0, 5], "sqlite_dbconfig_trigger_eqp": [0, 5], "sqlite_dbconfig_trusted_schema": [0, 5], "sqlite_dbconfig_writable_schema": [0, 5], "mapping_db_statu": 0, "sqlite_dbstatus_cache_hit": [0, 5], "sqlite_dbstatus_cache_miss": [0, 5], "sqlite_dbstatus_cache_spil": [0, 5], "sqlite_dbstatus_cache_us": 0, "sqlite_dbstatus_cache_used_shar": [0, 5], "sqlite_dbstatus_cache_writ": [0, 5], "sqlite_dbstatus_deferred_fk": [0, 5], "sqlite_dbstatus_lookaside_hit": 0, "sqlite_dbstatus_lookaside_miss_ful": 0, "sqlite_dbstatus_lookaside_miss_s": 0, "sqlite_dbstatus_lookaside_us": 0, "sqlite_dbstatus_max": 0, "sqlite_dbstatus_schema_us": 0, "sqlite_dbstatus_stmt_us": 0, "mapping_device_characterist": 0, "devic": [0, 15], "characterist": 0, "sqlite_iocap_atom": 0, "sqlite_iocap_atomic16k": 0, "sqlite_iocap_atomic1k": 0, "sqlite_iocap_atomic2k": 0, "sqlite_iocap_atomic32k": 0, "sqlite_iocap_atomic4k": 0, "sqlite_iocap_atomic512": 0, "sqlite_iocap_atomic64k": 0, "sqlite_iocap_atomic8k": 0, "sqlite_iocap_batch_atom": [0, 5], "sqlite_iocap_immut": [0, 5], "sqlite_iocap_powersafe_overwrit": [0, 5], "sqlite_iocap_safe_append": 0, "sqlite_iocap_sequenti": 0, "sqlite_iocap_undeletable_when_open": 0, "mapping_extended_result_cod": [0, 19], "sqlite_abort_rollback": [0, 5], "sqlite_auth_us": [0, 5], "sqlite_busy_recoveri": 0, "sqlite_busy_snapshot": [0, 5], "sqlite_busy_timeout": [0, 5], "sqlite_cantopen_convpath": [0, 5], "sqlite_cantopen_dirtyw": [0, 5], "sqlite_cantopen_fullpath": [0, 5], "sqlite_cantopen_isdir": [0, 5], "sqlite_cantopen_notempdir": 0, "sqlite_cantopen_symlink": [0, 5], "sqlite_constraint_check": 0, "sqlite_constraint_commithook": 0, "sqlite_constraint_datatyp": [0, 5], "sqlite_constraint_foreignkei": 0, "sqlite_constraint_funct": 0, "sqlite_constraint_notnul": 0, "sqlite_constraint_pin": [0, 5], "sqlite_constraint_primarykei": 0, "sqlite_constraint_rowid": [0, 5], "sqlite_constraint_trigg": 0, "sqlite_constraint_uniqu": 0, "sqlite_constraint_vtab": 0, "sqlite_corrupt_index": [0, 5], "sqlite_corrupt_sequ": [0, 5], "sqlite_corrupt_vtab": [0, 5], "sqlite_error_missing_collseq": [0, 5], "sqlite_error_retri": [0, 5], "sqlite_error_snapshot": [0, 5], "sqlite_ioerr_auth": [0, 5], "sqlite_ioerr_begin_atom": [0, 5], "sqlite_ioerr_block": [0, 5], "sqlite_ioerr_checkreservedlock": [0, 5], "sqlite_ioerr_clos": [0, 5], "sqlite_ioerr_commit_atom": [0, 5], "sqlite_ioerr_convpath": [0, 5], "sqlite_ioerr_corruptf": [0, 5], "sqlite_ioerr_data": [0, 5], "sqlite_ioerr_delet": [0, 5], "sqlite_ioerr_delete_no": [0, 5, 21], "sqlite_ioerr_dir_clos": [0, 5], "sqlite_ioerr_dir_fsync": 0, "sqlite_ioerr_fstat": 0, "sqlite_ioerr_fsync": 0, "sqlite_ioerr_gettemppath": [0, 5], "sqlite_ioerr_lock": [0, 5], "sqlite_ioerr_mmap": 0, "sqlite_ioerr_nomem": [0, 5], "sqlite_ioerr_rdlock": 0, "sqlite_ioerr_read": 0, "sqlite_ioerr_rollback_atom": [0, 5], "sqlite_ioerr_seek": [0, 5], "sqlite_ioerr_shmlock": 0, "sqlite_ioerr_shmmap": [0, 5], "sqlite_ioerr_shmopen": 0, "sqlite_ioerr_shms": 0, "sqlite_ioerr_short_read": [0, 12], "sqlite_ioerr_trunc": 0, "sqlite_ioerr_unlock": 0, "sqlite_ioerr_vnod": [0, 5], "sqlite_ioerr_writ": 0, "sqlite_locked_sharedcach": [0, 5, 19], "sqlite_locked_vtab": [0, 5], "sqlite_notice_recover_rollback": 0, "sqlite_notice_recover_w": 0, "sqlite_ok_load_perman": [0, 5], "sqlite_ok_symlink": [0, 5], "sqlite_readonly_cantinit": [0, 5], "sqlite_readonly_cantlock": [0, 5], "sqlite_readonly_dbmov": [0, 5], "sqlite_readonly_directori": [0, 5], "sqlite_readonly_recoveri": [0, 5], "sqlite_readonly_rollback": [0, 5], "sqlite_warning_autoindex": [0, 5], "mapping_file_control": 0, "standard": [0, 4, 5, 9, 10, 11, 17, 18], "control": [0, 2, 4, 5, 6, 8, 12, 16, 17, 18, 19, 21], "opcod": [0, 5, 11, 14], "sqlite_fcntl_begin_atomic_writ": [0, 5], "sqlite_fcntl_busyhandl": [0, 5], "sqlite_fcntl_chunk_s": [0, 5, 6], "sqlite_fcntl_ckpt_don": [0, 5], "sqlite_fcntl_ckpt_start": [0, 5], "sqlite_fcntl_cksm_fil": [0, 5], "sqlite_fcntl_commit_atomic_writ": [0, 5], "sqlite_fcntl_commit_phasetwo": [0, 5], "sqlite_fcntl_data_vers": [0, 5], "sqlite_fcntl_external_read": [0, 5], "sqlite_fcntl_file_point": 0, "sqlite_fcntl_get_lockproxyfil": [0, 5], "sqlite_fcntl_has_mov": [0, 5], "sqlite_fcntl_journal_point": [0, 5], "sqlite_fcntl_last_errno": [0, 5], "sqlite_fcntl_lockst": [0, 5], "sqlite_fcntl_lock_timeout": [0, 5], "sqlite_fcntl_mmap_s": 0, "sqlite_fcntl_overwrit": [0, 5], "sqlite_fcntl_pdb": [0, 5], "sqlite_fcntl_persist_w": 0, "sqlite_fcntl_powersafe_overwrit": [0, 5], "sqlite_fcntl_pragma": [0, 5], "sqlite_fcntl_rbu": [0, 5], "sqlite_fcntl_reserve_byt": [0, 5], "sqlite_fcntl_rollback_atomic_writ": [0, 5], "sqlite_fcntl_set_lockproxyfil": [0, 5], "sqlite_fcntl_size_hint": 0, "sqlite_fcntl_size_limit": [0, 5], "sqlite_fcntl_sync": [0, 5], "sqlite_fcntl_sync_omit": 0, "sqlite_fcntl_tempfilenam": [0, 5], "sqlite_fcntl_trac": [0, 5], "sqlite_fcntl_vfsnam": [0, 5], "sqlite_fcntl_vfs_point": [0, 5], "sqlite_fcntl_wal_block": [0, 5], "sqlite_fcntl_win32_av_retri": 0, "sqlite_fcntl_win32_get_handl": [0, 5], "sqlite_fcntl_win32_set_handl": [0, 5], "sqlite_fcntl_zipvf": [0, 5], "mapping_limit": 0, "categori": 0, "sqlite_limit_attach": [0, 11], "sqlite_limit_column": [0, 11], "sqlite_limit_compound_select": 0, "sqlite_limit_expr_depth": 0, "sqlite_limit_function_arg": 0, "sqlite_limit_length": [0, 11], "sqlite_limit_like_pattern_length": 0, "sqlite_limit_sql_length": 0, "sqlite_limit_trigger_depth": [0, 5], "sqlite_limit_variable_numb": 0, "sqlite_limit_vdbe_op": 0, "sqlite_limit_worker_thread": [0, 5], "mapping_locking_level": 0, "level": [0, 3, 5, 6, 11, 14, 17, 18, 20, 21, 22], "sqlite_lock_exclus": 0, "sqlite_lock_non": [0, 21], "sqlite_lock_pend": 0, "sqlite_lock_reserv": 0, "sqlite_lock_shar": [0, 21], "mapping_open_flag": 0, "sqlite_open_autoproxi": [0, 5], "sqlite_open_cr": [0, 6, 11], "sqlite_open_deleteonclos": [0, 21], "sqlite_open_exclus": 0, "sqlite_open_exrescod": [0, 5], "sqlite_open_fullmutex": [0, 5], "sqlite_open_main_db": 0, "sqlite_open_main_journ": 0, "sqlite_open_memori": [0, 5], "sqlite_open_nofollow": [0, 5], "sqlite_open_nomutex": [0, 5], "sqlite_open_privatecach": [0, 5], "sqlite_open_readonli": [0, 11, 21], "sqlite_open_readwrit": [0, 6, 11], "sqlite_open_sharedcach": [0, 5], "sqlite_open_subjourn": 0, "sqlite_open_super_journ": [0, 5], "sqlite_open_temp_db": 0, "sqlite_open_temp_journ": 0, "sqlite_open_transient_db": 0, "sqlite_open_uri": [0, 5, 11], "sqlite_open_w": 0, "mapping_prepare_flag": 0, "prepar": [0, 5, 6, 8, 11, 12, 13, 22], "sqlite_prepare_norm": 0, "sqlite_prepare_no_vtab": 0, "sqlite_prepare_persist": 0, "mapping_result_cod": [0, 19], "sqlite_auth": [0, 12], "sqlite_busi": [0, 5, 6, 12, 13], "sqlite_cantopen": [0, 12, 19], "sqlite_constraint": [0, 12], "sqlite_corrupt": [0, 12], "sqlite_don": 0, "sqlite_empti": [0, 12], "sqlite_error": [0, 5, 12, 21], "sqlite_format": [0, 12], "sqlite_ful": [0, 12, 21], "sqlite_intern": [0, 5, 12], "sqlite_interrupt": [0, 12], "sqlite_ioerr": [0, 12], "sqlite_lock": [0, 12, 21], "sqlite_mismatch": [0, 12], "sqlite_misus": [0, 12], "sqlite_nolf": [0, 12], "sqlite_notadb": [0, 12], "sqlite_notfound": [0, 5, 12], "sqlite_notic": 0, "sqlite_perm": [0, 12], "sqlite_protocol": [0, 5, 12], "sqlite_rang": [0, 12], "sqlite_readonli": [0, 12, 22], "sqlite_row": 0, "sqlite_schema": [0, 5, 12], "sqlite_toobig": [0, 12], "sqlite_warn": 0, "mapping_statu": 0, "sqlite_status_malloc_count": 0, "sqlite_status_malloc_s": 0, "sqlite_status_memory_us": [0, 11], "sqlite_status_pagecache_overflow": 0, "sqlite_status_pagecache_s": 0, "sqlite_status_pagecache_us": 0, "sqlite_status_parser_stack": 0, "sqlite_status_scratch_overflow": 0, "sqlite_status_scratch_s": 0, "sqlite_status_scratch_us": 0, "mapping_sync": 0, "synchron": 0, "sqlite_sync_dataonli": 0, "sqlite_sync_ful": 0, "sqlite_sync_norm": 0, "mapping_txn_st": [0, 6], "sqlite3_txn_st": [0, 6], "sqlite_txn_non": 0, "sqlite_txn_read": 0, "sqlite_txn_writ": 0, "mapping_virtual_table_configuration_opt": 0, "sqlite_vtab_constraint_support": 0, "sqlite_vtab_directonli": [0, 5], "sqlite_vtab_innocu": 0, "mapping_virtual_table_scan_flag": 0, "scan": [0, 5, 11, 14, 22], "sqlite_index_scan_uniqu": 0, "mapping_wal_checkpoint": 0, "checkpoint": [0, 5, 6, 19], "sqlite_checkpoint_ful": 0, "sqlite_checkpoint_pass": [0, 6], "sqlite_checkpoint_restart": 0, "sqlite_checkpoint_trunc": [0, 5], "mapping_xshmlock_flag": 0, "xshmlock": [0, 5], "sqlite_shm_exclus": 0, "sqlite_shm_lock": 0, "sqlite_shm_shar": 0, "sqlite_shm_unlock": 0, "encapsul": [1, 5, 6, 8, 21], "copi": [1, 3, 5, 6, 10, 11], "destin": [1, 5], "some": [1, 2, 3, 4, 5, 6, 10, 11, 12, 15, 17, 18, 19, 21, 22], "page": [1, 4, 5, 6, 11, 16, 18, 19, 21, 22], "repeatedli": [1, 21], "deal": [1, 5, 17, 18, 20, 21], "finish": [1, 5, 6, 8, 11], "clean": [1, 6], "roll": [1, 5, 6, 19], "back": [1, 2, 4, 5, 6, 8, 9, 11, 14, 16, 17, 18, 19, 21, 22], "releas": [1, 4, 5, 9, 10, 12, 13, 16, 19, 22], "here": [1, 5, 6, 11, 12, 13, 14, 18, 22], "db": [1, 5, 6, 8, 11, 13, 14, 16, 18, 19, 21], "b": [1, 6, 11, 12, 13, 19, 22], "done": [1, 3, 4, 5, 8, 11, 13, 16, 18, 19, 21], "100": [1, 2, 5, 6, 11, 13, 21, 22], "print": [1, 2, 4, 5, 6, 8, 11, 12, 13, 14, 17, 18, 19, 21], "remain": [1, 3, 5, 6, 8, 9, 13, 18, 21], "pagecount": 1, "r": [1, 13], "flush": [1, 11], "ll": [1, 19], "round": [1, 21], "trip": 1, "via": [1, 2, 5, 6, 8, 11, 14, 15, 18, 19], "ones": [1, 5, 12, 18, 21], "dure": [1, 3, 4, 5, 6, 9, 11, 13, 19], "threadingviolationerror": [1, 8, 12], "attempt": [1, 3, 5, 8, 9, 11, 12, 19], "instanc": [1, 5, 6, 12, 14, 21, 22], "__enter__": [1, 3, 5, 6], "manag": [1, 2, 3, 5, 6, 10, 15, 16, 17], "pep": [1, 3, 4, 5, 6, 9, 16], "0343": [1, 3, 5, 6], "__exit__": [1, 3, 6], "etyp": [1, 3, 6, 21], "type": [1, 3, 5, 6, 8, 12, 16, 17, 18, 21, 22], "baseexcept": [1, 3, 6, 21], "evalu": [1, 3, 6, 21, 22], "etraceback": [1, 3, 6, 21], "tracebacktyp": [1, 3, 6, 21], "implement": [1, 3, 5, 6, 8, 9, 11, 12, 17, 18, 21, 22], "conjunct": [1, 3, 5, 6], "forc": [1, 3, 4, 5, 6, 8, 18], "thing": [1, 5, 8, 11, 12, 13, 17, 20], "api": [1, 3, 4, 5, 8, 15, 16, 18, 19, 22], "give": [1, 4, 5, 6, 11, 12, 13, 17, 18, 19, 21, 22], "apsw": [1, 2, 3, 5, 6, 8, 9, 10, 14, 18, 20, 21, 22], "safe": [1, 5, 8, 13, 18, 21], "ignor": [1, 2, 3, 4, 5, 6, 11, 17, 19, 21, 22], "boolean": [1, 6, 12, 21, 22], "last": [1, 5, 8, 9, 10, 12, 13, 17, 18, 21], "transact": [1, 2, 5, 6, 8, 9, 16, 17, 22], "alwai": [1, 2, 3, 5, 6, 11, 18, 19, 20, 22], "even": [1, 3, 4, 5, 6, 11, 12, 13, 18, 19, 21, 22], "sqlite3_backup_finish": 1, "read": [1, 3, 5, 6, 8, 11, 12, 13, 14, 16, 18, 19, 20, 21, 22], "haven": [1, 17], "sqlite3_backup_pagecount": 1, "sqlite3_backup_remain": 1, "npage": 1, "smaller": 1, "until": [1, 3, 8, 9, 18], "omit": [1, 4, 5, 13, 22], "neg": [1, 3, 5, 6], "size": [1, 2, 3, 5, 6, 11, 12, 13, 21], "1024": [1, 3, 11, 21], "1kb": 1, "chang": [1, 3, 4, 6, 8, 11, 12, 14, 16, 17, 18, 19, 21, 22], "pragma": [1, 5, 6, 8, 11, 13, 19], "throw": [1, 13], "busyerror": [1, 6, 12, 13, 19, 21], "lockederror": [1, 12], "unabl": [1, 12, 19, 21], "catch": [1, 5, 11, 17, 18, 21], "those": [1, 3, 4, 5, 6, 7, 13], "again": [1, 4, 5, 6, 11, 12, 18, 21, 22], "outstand": [1, 6], "els": [1, 5, 6, 11, 14, 20, 21, 22], "sqlite3_backup_step": 1, "sqlite": [2, 3, 5, 6, 8, 9, 10, 13, 15, 16, 17, 18, 20, 21, 22], "alter": [2, 4, 7, 11, 19], "behaviour": [2, 3, 5, 6, 16, 17, 18, 21], "layer": [2, 11, 16, 17], "interpret": [2, 9], "behind": [2, 5, 6, 8, 12, 17], "well": [2, 5, 13, 19, 20, 22], "its": [2, 3, 5, 6, 11, 14, 16, 17, 22], "yourself": [2, 5, 18, 22], "000": [2, 22], "wrap": [2, 3, 5, 6, 14, 19, 21], "per": [2, 11], "spin": 2, "hard": [2, 4, 19, 22], "drive": 2, "60": 2, "second": [2, 3, 4, 6, 13, 14, 18, 19, 21, 22], "speed": [2, 5, 11, 22], "tester": [2, 5], "compar": [2, 11, 19], "host": [2, 5, 16], "matter": [2, 6, 13, 18, 19], "sqlite3": [2, 4, 5, 6, 16], "base": [2, 5, 8, 11, 12, 14, 19, 20, 21], "python3": [2, 4, 5, 10, 11, 13, 18], "m": [2, 4, 5, 10, 13, 18], "h": [2, 4, 13], "show": [2, 4, 5, 11, 12, 13, 15, 17, 18, 19, 21, 22], "exit": [2, 3, 5, 6, 13, 18, 19], "modul": [2, 4, 5, 11, 12, 14, 16, 18, 22], "correct": [2, 3, 4, 5, 6, 11, 20, 22], "scale": [2, 5], "unit": 2, "about": [2, 4, 5, 6, 8, 11, 13, 14, 16, 18, 20, 21, 22], "10": [2, 4, 8, 11, 12, 13, 16, 17, 19, 21, 22], "what": [2, 3, 4, 5, 6, 8, 12, 13, 14, 16, 18, 19, 20, 21, 22], "bigstmt": 2, "statements_nobind": 2, "iter": [2, 8, 9, 11, 13, 21, 22], "detail": [2, 4, 5, 6, 9, 12, 13, 16, 17, 18, 19, 21, 22], "dump": [2, 5, 11, 18, 19], "filenam": [2, 3, 5, 6, 10, 11, 13, 18, 21], "feed": 2, "command": [2, 4, 5, 10, 11, 13, 16, 17], "shell": [2, 5, 16, 19], "sc": 2, "disabl": [2, 5, 6, 13, 15, 17, 18, 19, 22], "minimum": [2, 4, 11], "percentag": 2, "non": [2, 4, 5, 12, 14, 18, 20, 21, 22], "ascii": [2, 18], "charact": [2, 5, 6, 8, 18, 20], "lot": [2, 4, 5, 11, 12, 14, 22], "easili": [2, 5, 13, 18], "consum": [2, 5, 17, 19, 22], "gigabyt": 2, "origin": [2, 5, 7, 8, 12, 14, 19], "tcl": [2, 18], "consist": [2, 5, 18], "handl": [2, 5, 6, 16, 17, 18, 21], "requir": [2, 3, 5, 6, 7, 8, 10, 11, 12, 17, 18, 19, 20], "executescript": [2, 17, 19], "sever": [2, 5, 9, 12, 17, 18, 19], "kilobyt": [2, 19], "factor": 2, "50": [2, 5, 11], "megabyt": 2, "rang": [2, 5, 11, 12, 19], "kind": [2, 12], "restor": [2, 5, 18], "faster": [2, 3, 5, 11, 17], "foo": [2, 3, 6, 11, 12, 13, 17, 18, 19, 21, 22], "hit": [2, 6, 18], "doesn": [2, 4, 5, 6, 9, 11, 17, 18, 19, 22], "overhead": [2, 13], "In": [2, 3, 4, 5, 6, 7, 8, 9, 12, 16, 18, 19, 20, 21, 22], "theori": [2, 4, 5], "abov": [2, 4, 5, 7, 10, 17, 22], "almost": [2, 4, 5, 12, 19, 21], "ident": [2, 4, 8, 22], "happen": [2, 3, 4, 5, 6, 8, 12, 13, 14, 17, 18, 19, 21], "practis": [2, 19], "datatyp": 3, "2gb": [3, 5, 13, 21], "1gb": [3, 13], "altern": [3, 4, 5, 7, 18], "approach": [3, 8, 17, 19, 20], "lose": 3, "acid": 3, "properti": [3, 8, 18], "previous": [3, 5, 6], "entir": [3, 5, 11, 12, 14], "go": [3, 5, 6, 10, 11, 12, 13, 14, 18, 19, 21, 22], "retriev": [3, 4, 5, 18], "entireti": 3, "100mb": 3, "largedata": 3, "largefil": 3, "rb": [3, 11], "cur": [3, 12, 17], "increment": [3, 4, 5, 6], "o": [3, 5, 6, 12, 13, 16, 17, 18, 19, 21], "write": [3, 5, 6, 8, 11, 12, 16, 18, 21, 22], "cannot": [3, 4, 6, 9, 11, 12, 13, 18, 19], "reserv": [3, 6, 21], "space": [3, 4, 5, 6, 11, 13, 19], "through": [3, 4, 5, 11, 21], "specifi": [3, 4, 5, 6, 10, 13, 18, 21, 22], "full": [3, 4, 5, 6, 12, 13, 15, 18, 21], "two": [3, 5, 6, 8, 12, 13, 17, 18, 19, 21, 22], "100000000": 3, "exist": [3, 4, 5, 6, 8, 11, 12, 18, 19, 21, 22], "content": [3, 5, 6, 11, 13, 19, 21], "length": [3, 5, 6, 11, 13, 21, 22], "blobopen": [3, 6, 11], "behav": [3, 20, 21], "At": [3, 18, 20, 22], "c": [3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 16, 17, 18, 19, 20, 21, 22], "sqlite3_blob": 3, "advanc": [3, 5, 11, 16], "block": [3, 5, 6, 21], "occur": [3, 4, 5, 12, 19], "still": [3, 4, 5, 6, 8, 13, 19, 21, 22], "case": [3, 4, 5, 6, 8, 10, 11, 12, 14, 20, 21], "technic": [3, 13, 18, 19], "routin": [3, 5, 11, 12, 21, 22], "similarli": 3, "okai": [3, 11], "sqlite3_blob_clos": 3, "sqlite3_blob_byt": 3, "till": 3, "whichev": 3, "earlier": [3, 5, 12, 15, 17, 21], "beyond": 3, "manner": [3, 5], "sqlite3_blob_read": 3, "readinto": [3, 5], "buffer": [3, 5, 13, 20], "bytearrai": 3, "arrai": [3, 5, 21], "memoryview": 3, "offset": [3, 5, 11, 18, 21], "assembl": 3, "avoid": [3, 13, 17, 21], "writabl": 3, "There": [3, 4, 5, 8, 9, 12, 15, 17, 18, 19, 21, 22], "posit": [3, 14, 22], "begin": [3, 8, 9, 11, 13, 18, 19, 22], "much": [3, 4, 19, 20], "left": [3, 5, 8], "valueerror": [3, 5, 6, 12, 21], "reopen": [3, 5], "rowid": [3, 6, 11, 12, 22], "point": [3, 4, 5, 6, 9, 11, 18, 19, 21], "sqlite3_blob_reopen": 3, "seek": [3, 11], "whenc": 3, "bias": 3, "rel": [3, 5], "less": [3, 5, 6, 12, 21], "tell": [3, 4, 5, 6, 12, 21, 22], "typeerror": [3, 5, 8, 12, 14], "wrong": 3, "increas": [3, 5, 18, 21], "desir": [3, 19], "sqlite3_blob_writ": 3, "info": 4, "relationship": 4, "short": [4, 18, 19, 21], "stori": 4, "ideal": 4, "compon": [4, 5, 15], "site": [4, 5, 19], "directori": [4, 5, 11, 19, 21, 22], "subdirectori": 4, "home": [4, 10], "370": 4, "inplac": 4, "extens": [4, 5, 6, 10, 11, 12, 16, 17, 18], "debug": [4, 17, 18], "assert": 4, "doubl": [4, 18, 19, 22], "assumpt": 4, "too": [4, 5, 6, 8, 12, 19], "consider": [4, 5], "slow": 4, "down": [4, 21], "specif": [4, 5, 6, 9, 13, 14, 16, 18, 20, 21], "environ": [4, 5, 21], "variabl": [4, 5, 8, 12, 22], "http_proxi": 4, "proxi": 4, "download": [4, 5, 16], "appli": [4, 5, 6, 8, 19], "without": [4, 5, 7, 11, 13, 17, 19, 22], "By": [4, 5, 11, 13, 17, 19, 22], "latest": [4, 5], "out": [4, 5, 6, 12, 13, 16, 17, 18, 19, 20, 21, 22], "most": [4, 5, 6, 10, 12, 13, 17, 18, 22], "recent": [4, 6, 12, 13, 17, 18], "checksum": [4, 5], "ok": [4, 6, 8], "prefer": 4, "total": [4, 5, 6, 10, 13, 14, 20], "over": [4, 5, 6, 8, 16, 17, 18, 19, 21, 22], "exclud": 4, "develop": [4, 5, 22], "deploy": 4, "machin": [4, 5, 10], "fts3": [4, 5, 16], "rtree": [4, 5, 16], "json1": [4, 5, 16], "icu": [4, 5, 16, 20], "nny": 4, "eras": 4, "place": [4, 5, 6, 8, 17, 18], "newli": 4, "digit": [4, 5, 10], "thei": [4, 5, 6, 8, 10, 11, 12, 13, 18, 19, 20, 21, 22], "produc": [4, 5, 10], "team": [4, 5], "modifi": [4, 5, 6, 11, 13, 17], "server": [4, 10], "comput": [4, 19], "consequ": [4, 5, 6, 9, 13, 17, 19, 21], "ship": 4, "reject": 4, "gui": [4, 11, 19], "malici": 4, "instead": [4, 5, 8, 9, 11, 13, 16, 18, 19, 20, 21, 22], "determin": [4, 21, 22], "url": [4, 5], "detect": [4, 5, 8, 12, 13, 18, 21], "howev": [4, 5, 13, 19, 20, 21], "oldest": [4, 11], "known": [4, 8, 11, 21], "sleep": [4, 5, 21], "told": [4, 12], "As": [4, 5, 11, 12, 17, 20, 21], "usleep": 4, "microsecond": [4, 21], "busi": [4, 5, 6, 13, 16, 21], "handler": [4, 5, 6, 12, 13, 16, 19, 21], "50th": 4, "off": [4, 5, 11, 13, 17, 18, 19, 22], "tradit": [4, 5, 22], "entrant": 4, "concurr": [4, 5, 9, 12, 13, 18, 19], "won": [4, 5, 6, 13, 18, 22], "bother": 4, "script": [4, 5, 13, 17], "come": [4, 11, 14, 18, 22], "output": [4, 5, 8, 11, 13, 16, 17, 18, 20, 22], "sqlite3config": 4, "stage": 4, "certain": [4, 5, 22], "accumul": 4, "comma": [4, 8], "separ": [4, 5, 8, 11, 13, 18, 19], "fts3_parenthesi": 4, "sqlite_custom_includ": 4, "definevalu": [4, 5], "sqlite_default_file_format": 4, "stat4": [4, 5], "rbu": [4, 5, 16], "path": [4, 11, 21], "fts4": [4, 5, 15], "fts5": [4, 5, 15], "search": [4, 5, 11, 15, 16, 18, 21], "parenthesi": 4, "legaci": [4, 5], "spatial": [4, 15], "reumabl": 4, "bulk": [4, 5, 15], "caus": [4, 5, 6, 8, 11, 12, 13, 19], "load_extens": [4, 5], "load": [4, 5, 6, 12, 18, 21], "ie": [4, 5, 6, 11, 12, 13, 18, 21, 22], "regener": 4, "becaus": [4, 5, 6, 8, 11, 13, 16, 18, 19, 20, 21, 22], "parser": 4, "document": [4, 5, 6, 7, 9, 12, 13, 15, 19, 21, 22], "correctli": [4, 5, 11, 13], "loadabl": 4, "present": [4, 5, 6, 8, 14, 18, 21, 22], "description_ful": [4, 5, 8, 11, 14], "sqlite_enable_column_metadata": [4, 5, 8], "reason": 4, "sync": [4, 21, 22], "obtain": [4, 5, 6, 8, 9, 19], "ctype": [4, 6, 21], "find_librari": 4, "simultan": [4, 18, 22], "newer": [4, 5, 6, 19], "pars": [4, 5, 6, 16, 17, 18, 22], "manual": [4, 11, 19], "39": [4, 16], "tri": [4, 6, 12, 17, 19], "order": [4, 5, 6, 11, 12, 13, 14, 18, 20, 22], "invis": 4, "rest": [4, 6, 13], "runtim": [4, 6], "local": [4, 5, 6, 8, 12, 15, 20, 22], "header": [4, 5, 11, 12, 18], "libsqlite3": 4, "dll": 4, "usr": [4, 11], "lib": [4, 11], "sqlite_omit_load_extens": 4, "add": [4, 9, 11, 12, 18, 19], "instruct": [4, 5, 10, 11, 14, 17], "plu": [4, 18], "mac": [4, 21], "extract": [4, 5, 10, 18], "linux": [4, 5, 10, 11, 21], "warn": [4, 5, 19], "harmless": [4, 19, 21], "drop": [4, 5, 11, 17], "conveni": [4, 13, 18, 19, 21, 22], "reach": [4, 6, 18], "leav": [4, 5], "put": [4, 8], "binari": [4, 5, 10, 11, 20, 21], "intermedi": 4, "bdist_rpm": 4, "everyth": [4, 5, 11, 16, 18, 20], "rpm": [4, 10], "itself": [4, 5, 6, 8, 12, 13, 14, 18, 22], "dedic": 4, "alongsid": 4, "bin": [4, 11], "version_info": 4, "major": [4, 21], "minor": [4, 5], "micro": 4, "releaselevel": 4, "serial": [4, 5, 6, 13], "__init__": [4, 11], "cpython": [4, 5, 11, 16], "310": [4, 11], "x86_64": [4, 11], "gnu": [4, 10, 11], "3039002": 4, "ran": 4, "95": 4, "25": [4, 16], "990": 4, "possibl": [4, 5, 8, 10, 16, 18, 19, 20, 21], "checkout": 4, "coverag": [4, 5, 17], "sh": 4, "deliber": 4, "induc": 4, "condit": [4, 13, 17], "failur": [4, 5, 6, 11, 17, 21], "undocu": [4, 5], "That": [4, 5, 8, 9, 17, 19], "bring": 4, "99": [4, 17, 22], "checker": [4, 5], "valgrind": 4, "leak": [4, 21, 22], "stand": 4, "sanit": 4, "compat": [4, 5, 6, 14, 15, 18, 19], "32": [4, 6, 12, 13, 16, 18, 21], "megatest": 4, "fix": [5, 19], "regress": 5, "whitespac": 5, "incorrectli": [5, 12], "treat": [5, 6, 18, 20, 21], "incomplet": [5, 18, 19], "376": 5, "ad": [5, 11, 17, 19, 21], "interest": [5, 16, 17], "369": 5, "attribut": [5, 9, 11, 12, 19], "getter": 5, "setter": 5, "in_transact": [5, 6], "371": 5, "extent": 5, "permit": 5, "docstr": [5, 18], "stub": 5, "cover": 5, "constant": [5, 16, 19, 21], "visual": 5, "studio": 5, "displai": [5, 18], "hover": 5, "tour": [5, 16], "appear": [5, 12, 19], "367": 5, "cache_stat": [5, 6], "now": [5, 6, 11, 13, 14], "sqlite_prepare_v3": [5, 8], "can_cach": [5, 6, 8, 13, 14], "whether": [5, 14], "executemani": [5, 6, 8, 9, 12, 13, 14, 16, 17], "is_readonli": [5, 8, 11, 14], "is_explain": [5, 8, 11, 14], "expanded_sql": [5, 8, 11, 14], "userdict": 5, "dictionari": [5, 6, 8, 11, 12, 13, 14, 18, 19], "373": 5, "longer": [5, 8, 12, 13, 21, 22], "363": 5, "setup": [5, 10, 15, 16], "py": [5, 11, 12, 13, 15, 16, 17, 18], "build_ext": 5, "364": 5, "pypi": [5, 16], "build": [5, 10, 15, 16, 17, 20, 21], "directli": [5, 14, 17, 18, 19, 22], "trace": [5, 6, 8, 16, 17, 19, 21, 22], "speedtest": [5, 16, 17], "move": [5, 22], "356": 5, "refer": [5, 6, 8, 16, 21, 22], "old": [5, 18], "break": [5, 15, 18], "On": [5, 6, 13, 18, 21], "nativ": [5, 9, 21], "consol": [5, 18], "colour": [5, 18], "third": [5, 14, 15], "parti": 5, "357": 5, "column": [5, 6, 8, 12, 13, 16, 17, 18, 19, 20, 22], "metadata": 5, "354": 5, "cursor_factori": [5, 6, 11, 14, 19], "custom": [5, 11, 16, 22], "361": 5, "scheme": [5, 18], "style": [5, 9, 12], "suffix": [5, 11], "340": 5, "aarch64": 5, "univers": 5, "maco": 5, "sinc": [5, 6, 8, 9, 13], "sqlite_max_attach": [5, 11], "125": [5, 11], "ongo": 5, "core": [5, 21], "338": 5, "381": 5, "342": 5, "db_name": [5, 6, 11], "343": 5, "pip": [5, 16, 18], "thank": 5, "peopl": 5, "scene": [5, 6, 8, 12], "who": 5, "piec": 5, "remov": [5, 6, 7, 10, 11, 18], "aka": 5, "fossil": 5, "cleanli": 5, "210": 5, "326": 5, "pypy3": 5, "mostli": [5, 19], "323": 5, "summari": [5, 13, 17, 18, 20], "regular": [5, 15, 18], "pyi": 5, "shown": [5, 11, 18, 22], "id": [5, 6, 9, 10, 11, 13, 22], "life": 5, "everywher": [5, 20], "quarter": 5, "simpler": 5, "fetch": [5, 8, 10], "cycl": [5, 6, 19], "314": 5, "pin": 5, "ex": 5, "untermin": 5, "totalchang": [5, 6], "greater": [5, 6, 22], "billion": [5, 19], "autovacuum_pag": [5, 6], "deseri": [5, 6], "respect": 5, "wal": [5, 6, 11, 19, 21], "direct": [5, 6, 14, 17], "311": 5, "year": [5, 10, 11, 19], "built": 5, "math": 5, "msi": 5, "294": 5, "wheel": 5, "txn_state": [5, 6], "expos": [5, 10, 21], "273": 5, "pkg": 5, "sdk": 5, "fall": 5, "268": 5, "deprec": 5, "newlin": [5, 18], "283": 5, "function_list": 5, "tab": [5, 18], "hash": 5, "274": 5, "sqlite_dbconfig": 5, "249": [5, 9, 16], "geopoli": 5, "253": 5, "optimis": [5, 6, 22], "isn": [5, 9, 18, 22], "256": 5, "214": 5, "under": [5, 6, 7, 21, 22], "spell": 5, "edward": 5, "bett": 5, "review": [5, 19], "240": 5, "No": [5, 6, 12, 19], "resum": [5, 13, 15], "set_last_insert_rowid": [5, 6], "pyunicode_readi": 5, "onward": 5, "208": 5, "132": 5, "168": 5, "semant": [5, 21], "xgetlasterror": [5, 21], "incompat": [5, 21], "rewrit": [5, 21], "futur": [5, 21], "swap": 5, "address": [5, 11, 14, 15, 18, 21], "setuptool": 5, "distutil": 5, "bdist_wheel": 5, "apsw_force_distutil": 5, "207": 5, "comment": [5, 6, 11, 14], "logic": [5, 12], "2016": 5, "folder": 5, "199": 5, "wait": [5, 6, 11, 12, 13], "few": [5, 8, 12], "matur": 5, "sqlite_enable_api_armor": 5, "arbitrari": 5, "e596a6b6": 5, "invalid": [5, 8, 12, 14, 18], "adjust": [5, 21], "relat": [5, 21], "determinist": [5, 6], "createscalarfunct": [5, 6, 11, 12, 17], "187": 5, "switch": 5, "191": 5, "descript": [5, 8, 9, 11, 14, 18], "preserv": 5, "186": 5, "reliabl": 5, "scrape": 5, "sqlite_get_lockproxyfil": 5, "sqlite_set_lockproxyfil": 5, "sqlite_last_errno": 5, "fcntl": 5, "quick": 5, "2015": 5, "unittest": 5, "164": 5, "169": 5, "fetchon": [5, 8, 9], "rebuild": 5, "mike": 5, "fletcher": 5, "github": [5, 10, 16], "http": [5, 7, 10, 16], "com": [5, 10, 16], "rogerbinn": [5, 10, 16], "pysqlit": 5, "obliter": 5, "abil": [5, 17, 22], "patienc": 5, "fight": 5, "microsoft": 5, "archiv": 5, "autoconf": 5, "softwar": [5, 7, 18], "cooper": 5, "timestamp": [5, 11, 13], "usernam": [5, 10], "hostnam": 5, "couldn": [5, 6], "promot": 5, "142": 5, "circumst": 5, "typic": [5, 6, 12, 18, 21], "upgrad": [5, 19], "sqlite_constraint_": 5, "couchdb": 5, "pickup": 5, "ssl": 5, "web": [5, 21], "link": [5, 11, 19], "websit": [5, 19], "fallback": 5, "around": [5, 8, 21], "xdelet": [5, 21], "asyncvf": 5, "maintain": [5, 8, 13, 20], "nor": [5, 8, 18], "explicitli": 5, "reli": 5, "bug": [5, 18, 19], "csv": [5, 11, 18, 22], "novemb": [5, 16], "2012": 5, "gil": [5, 9, 13], "encount": [5, 18, 19], "upcom": 5, "arfrev": 5, "freht": 5, "taifersar": 5, "arahesi": 5, "find": [5, 6, 8, 11, 13, 14, 15, 16, 18, 19, 21, 22], "134": 5, "sqlite3_db_statu": [5, 6], "cope": 5, "modern": 5, "anywai": [5, 12], "bugfix": 5, "interoper": 5, "littl": 5, "easier": [5, 21], "131": [5, 8], "readonli": [5, 6, 12, 14], "pathnam": [5, 21], "db_filenam": [5, 6], "sector": [5, 21], "096": 5, "ticket": [5, 19, 21], "122": 5, "async": 5, "lead": [5, 13, 18, 21, 22], "strip": [5, 11], "view": [5, 6, 8, 11, 14], "declar": [5, 8, 11, 22], "discuss": 5, "urifilenam": [5, 11, 16], "uri": [5, 11, 21], "124": 5, "xopen": [5, 11, 21], "vfsfile": [5, 11, 16], "xfullpathnam": [5, 21], "construct": 5, "bypass": 5, "guarante": [5, 19], "exactli": [5, 6, 8, 13, 19, 21, 22], "sqlite3_fcntl_persist_w": 5, "sqlite3_fcntl_win32_av_retri": 5, "120": [5, 13], "lp64": 5, "long": [5, 6, 12, 13, 18, 20], "becom": [5, 12, 14, 18], "interact": [5, 18], "115": [5, 13], "autoimport": [5, 18], "deduc": 5, "117": 5, "target": [5, 14, 19], "edzard": 5, "pasma": 5, "diagnos": [5, 19], "redirect": 5, "sandbox": [5, 21], "notfounderror": [5, 12, 21], "wal_checkpoint": [5, 6], "sqlite3_wal_checkpoint_v2": [5, 6], "fine": [5, 17, 19, 22], "grain": 5, "backward": [5, 15, 19], "xfilecontrol": [5, 6, 21], "indic": [5, 6, 11, 12, 14, 18, 21, 22], "understood": [5, 6, 21], "filecontrol": [5, 6, 21], "larger": [5, 6, 13, 17, 21], "abl": [5, 18, 21], "timer": [5, 18], "augment": [5, 15, 16, 17, 21, 22], "rather": [5, 17, 21], "describ": [5, 6, 8, 9, 13, 14, 15, 20, 21, 22], "pre": 5, "effici": [5, 22], "109": 5, "sqlite_create_function_v2": 5, "housekeep": 5, "did": [5, 21], "push": [5, 18], "onto": [5, 18], "108": 5, "With": [5, 18, 22], "encod": [5, 11, 13, 18, 20], "replac": [5, 6, 11, 14, 18, 21], "xmlcharrefreplac": [5, 18], "cp437": [5, 18], "ahead": [5, 6, 11, 16, 21], "significantli": [5, 17, 21], "tweak": [5, 19], "dumper": 5, "three": [5, 8, 9, 13, 18, 21], "four": 5, "nikolau": 5, "rath": 5, "problem": [5, 8, 12, 14, 17, 19], "highlight": 5, "distinguish": 5, "termin": [5, 12, 18], "countri": [5, 20], "adopt": 5, "metric": 5, "u": [5, 12, 18], "colorama": 5, "eager": 5, "geoff": 5, "ness": 5, "98": 5, "jose": 5, "gome": 5, "103": 5, "ppa": 5, "ubuntu": [5, 10], "kept": 5, "date": [5, 9, 10, 11, 13, 17], "launchpad": 5, "net": 5, "embed": [5, 19], "insid": [5, 12, 13, 14], "initialis": [5, 19], "stringio": [5, 11], "simplifi": 5, "retri": [5, 6, 13, 19], "made": [5, 6, 10, 12, 19, 21, 22], "sdist": 5, "necessari": [5, 6, 13, 18, 21], "packag": [5, 10], "recurs": 5, "html": [5, 10, 18], "repar": 5, "locat": 5, "89": 5, "auto_vacuum": [5, 11], "90": 5, "tamper": [5, 10], "emit": 5, "outsid": [5, 10, 11], "unintent": 5, "bound": [5, 8], "introduc": [5, 6, 19, 22], "85": 5, "gori": 5, "bidirection": 5, "transfer": 5, "alphabet": [5, 7, 20], "82": 5, "user_vers": [5, 19], "firefox": 5, "track": [5, 17, 21, 22], "schema": [5, 6, 11, 12, 14, 16, 18], "json": [5, 15, 16, 18], "83": [5, 13], "right": [5, 17, 20], "justifi": 5, "width": [5, 18], "84": 5, "traceback": [5, 7, 12, 13, 17, 18, 21], "86": 5, "ON": [5, 11, 18], "72": 5, "wasn": 5, "bestindex": [5, 11, 12, 22], "lefteri": 5, "along": 5, "emb": [5, 18], "inherit": [5, 11, 12, 14, 18, 19, 21], "applic": [5, 7, 9, 19], "stat2": 5, "statist": [5, 16], "gather": [5, 14], "plan": [5, 8, 11, 14], "async_initi": 5, "unix": [5, 10, 11, 13, 18, 21], "especi": [5, 11], "67": 5, "experiment": 5, "licens": [5, 16], "osi": [5, 7], "approv": [5, 7], "record": [5, 6, 13, 21], "situat": [5, 12], "migrat": 5, "subvers": 5, "mercuri": 5, "googl": 5, "xunlock": [5, 21], "sometim": [5, 19, 21], "cvstrac": [5, 6, 13], "3946": 5, "mention": 5, "integr": [5, 18], "sampl": [5, 13], "distribut": [5, 7, 10, 16], "55": 5, "unintention": [5, 19], "trivial": [5, 13, 19], "msvc": 5, "happi": 5, "apswtrac": [5, 13, 17, 19], "cursorfrom": [5, 13], "3875": 5, "symbol": [5, 21], "clash": 5, "we": [5, 6, 11, 18, 19, 21, 22], "hasn": [5, 6], "chm": 5, "viewabl": 5, "viewer": 5, "hot": [5, 21], "reflect": 5, "fullerror": [5, 12, 21], "sqlerror": [5, 12, 21], "prior": [5, 6, 21], "reincarn": 5, "cursorclosederror": [5, 12], "savepoint": [5, 6, 9, 13], "nest": [5, 6, 8, 9, 11, 17, 19], "xtruncat": [5, 21], "caller": [5, 13], "xdlsym": [5, 21], "signatur": [5, 10], "pedant": 5, "poorli": 5, "subset": [5, 14, 18], "builtin": [5, 16, 18], "extern": [5, 20, 21], "reduc": [5, 9, 11, 13, 14, 22], "storag": [5, 11, 13, 19], "vista": 5, "xp": 5, "rudolf": 5, "gaertner": 5, "assist": 5, "weak": 5, "popular": [5, 6, 10, 13, 17], "demand": [5, 6, 11], "fetchal": [5, 8, 9, 11, 19], "open_flag": [5, 6, 11, 13], "open_vf": [5, 6], "revert": [5, 6], "older": [5, 8, 18], "2158": 5, "save": [5, 13, 18, 19, 21], "visibl": [5, 8, 19], "multi": [5, 15, 16, 19], "unknown": 5, "collat": [5, 6, 12, 13, 16], "deriv": [5, 11, 21], "rewritten": 5, "better": [5, 8, 16, 18, 19], "deadlock": [5, 13, 17], "inspect": 5, "amicita": 5, "sphinx": 5, "richer": 5, "pdf": 5, "ft": [5, 15, 16], "reorgan": 5, "clearer": 5, "overrid": [5, 6, 11, 18, 21], "obfusc": [5, 11, 21], "xore": [5, 21], "ver": 5, "have_usleep": 5, "have_localtime_r": 5, "featur": [5, 8, 12, 17, 18, 19, 22], "further": [5, 12], "sqlite_config": 5, "sqlite_statu": 5, "sqlite3_statu": 5, "sqlite3_soft_heap_limit": 5, "noth": [5, 17, 19], "yet": [5, 8], "sqlite3_db_config": [5, 6], "regard": 5, "fit": [5, 20], "exclus": [5, 13], "joe": 5, "pham": 5, "sqlite3point": [5, 6], "0b1": 5, "sqlite_max_": [5, 11], "unreli": 5, "workaround": 5, "p": [5, 11], "far": [5, 12, 17], "interrupt": [5, 6, 12, 18], "roughli": [5, 18], "constrain": [5, 22], "within": [5, 12, 14, 19, 20], "weren": 5, "destroi": [5, 11, 22], "elsewher": [5, 22], "renam": [5, 14, 22], "enforc": [5, 19], "restrict": [5, 7, 17, 19], "sqlite3_prepar": [5, 12], "convert": [5, 11, 13, 16, 17, 18, 20, 22], "utf8": [5, 6, 18, 20], "sqlite3_open_v2": [5, 6, 13], "effort": [5, 9, 17, 19, 21], "percent": 5, "entri": [5, 6, 8, 13, 18], "collationneed": [5, 6], "co": 5, "project": 5, "subsequ": [5, 18, 21, 22], "although": [5, 10, 16, 17, 19, 20], "ed": 5, "misus": 5, "pointer": [5, 6, 21], "sqlite3_step": [5, 8, 13], "special": 5, "restart": [5, 11], "hung": 5, "sqlite3_prepare_v2": [5, 13], "henc": [5, 20], "usual": 5, "pyerr_writeunrais": 5, "unfortun": [5, 13], "useless": [5, 12], "mere": [5, 21], "stderr": [5, 13, 18], "often": [5, 6], "never": [5, 8, 18, 19, 20], "came": 5, "chunk": [5, 6], "dummi": 5, "frame": [5, 6, 12, 21], "why": [5, 16, 18], "stack": [5, 16, 17, 18, 19, 21, 22], "truncat": 5, "cleanup": [5, 16, 22], "believ": [5, 13], "corner": 5, "aren": 5, "pleas": 5, "shout": 5, "getdescript": [5, 8, 9, 14, 19], "v": [5, 11], "py_ssize_t": 5, "sqlite3_update_hook": [5, 6], "sqlite3_rollback_hook": [5, 6], "sqlite3_get_autocommit": [5, 6], "sqlite3_profil": [5, 6], "took": [5, 6], "written": 5, "section": [5, 9, 13, 20], "accord": 5, "overli": 5, "sqlite3_global_recov": 5, "primari": [5, 11, 12], "kei": [5, 6, 10, 11, 12, 18, 19, 22], "stabl": 5, "sai": [5, 21, 22], "apswexcept": 5, "pure": 5, "cosmet": 5, "clear": [5, 11, 21], "ism": 5, "check_thread": 5, "macro": 5, "contact": 5, "me": 5, "sqlite3_sleep": 5, "millisecond": [5, 6, 18], "sqlite3_expir": 5, "margin": 5, "global": [5, 9], "sqlite3_temp_directori": 5, "temporari": [5, 6, 19, 21], "cut": 5, "past": 5, "zip": [5, 10], "sub": [5, 11, 14], "sort": [5, 6, 12, 15, 16, 20, 22], "statementcaches": 6, "privat": [6, 11], "orred": [6, 21], "togeth": [6, 21], "distinct": [6, 13, 18], "frequent": 6, "call_funct": 6, "call_function2": 6, "8": [6, 8, 11, 12, 13, 16, 17, 18, 20, 21], "prevent": [6, 17, 22], "harm": 6, "3rd": 6, "4th": 6, "innermost": 6, "trigger": [6, 11, 12, 14], "sqlite3_set_author": 6, "autovacuum": 6, "count": [6, 9, 21], "THE": 6, "IN": 6, "wors": 6, "sqlite3_autovacuum_pag": 6, "databasenam": [6, 22], "sourceconnect": 6, "sourcedatabasenam": 6, "attach": [6, 9, 11, 14, 18, 22], "sqlite3_backup_init": 6, "writeabl": 6, "uniqu": [6, 8, 13, 19, 22], "identifi": [6, 13, 19, 22], "sqlite3_blob_open": 6, "include_entri": 6, "select": [6, 8, 9, 11, 12, 13, 14, 17, 18, 19, 22], "explan": 6, "evict": 6, "expir": 6, "no_cach": 6, "found": [6, 10, 12], "no_vdb": 6, "too_big": 6, "max_cacheable_byt": 6, "prepare_flag": [6, 8, 14], "sqlite3_prepare_v3": [6, 8], "has_mor": 6, "sqlite3_changes64": 6, "indirect": [6, 19], "circular": 6, "referenc": [6, 14], "broken": 6, "design": [6, 19], "surviv": [6, 11, 19, 21], "power": [6, 11, 15, 19, 21], "awkward": 6, "moment": 6, "grace": 6, "abrupt": 6, "worst": 6, "progress": [6, 16, 19], "next": [6, 8, 9, 11, 13, 19, 22], "sqlite3_clos": 6, "createcol": [6, 11], "thousand": 6, "prereigst": 6, "sqlite3_collation_need": 6, "optiona": 6, "createaggregatefunct": [6, 11], "factori": [6, 11, 14], "numarg": 6, "255": [6, 19], "resourc": [6, 18, 22], "sqlite3_create_function_v2": 6, "term": 6, "account": [6, 20], "equal": [6, 11, 22], "def": [6, 11, 12, 13, 17, 19, 21, 22], "mycol": 6, "unregist": [6, 8, 21], "sqlite3_create_collation_v2": 6, "createmodul": [6, 11, 22], "datasourc": 6, "sqlite3_create_module_v2": 6, "planner": 6, "toip": 6, "ipv4convert": 6, "ipv6convert": 6, "16": [6, 11, 16, 18, 20], "strconvert": 6, "sqlite3_db_filenam": 6, "temp": [6, 14], "sqlite3_db_nam": 6, "resiz": 6, "sqlite3_deseri": 6, "enableloadextens": 6, "loadextens": 6, "sqlite3_enable_load_extens": 6, "sequenceofbind": [6, 8, 14], "dbname": [6, 11, 13], "void": [6, 21], "mutabl": 6, "obj": [6, 21], "objwrap": 6, "py_object": [6, 21], "live": 6, "123": [6, 11], "our": [6, 11], "addressof": 6, "self": [6, 8, 11, 12, 18, 19, 21, 22], "from_address": [6, 21], "plai": 6, "superclass": [6, 21], "super": [6, 11, 21], "myfil": [6, 21], "grow": 6, "combin": [6, 17], "c_int": 6, "chunksiz": 6, "32768": 6, "sqlite3_file_control": 6, "getautocommit": 6, "auto": [6, 19], "getexectrac": [6, 8], "getrowtrac": [6, 8], "pend": 6, "earliest": 6, "opportun": 6, "press": [6, 18], "stop": [6, 8, 13, 18], "button": 6, "interrupterror": [6, 12], "sqlite3_interrupt": [6, 12], "last_insert_rowid": [6, 8, 9], "sqlite3_last_insert_rowid": 6, "newval": 6, "sqlite3_limit": 6, "entrypoint": 6, "sqlite3_extension_init": 6, "extensionloadingerror": [6, 12], "sqlite3_load_extens": 6, "overloadfunct": [6, 22], "narg": [6, 22], "placehold": 6, "vttabl": [6, 16], "findfunct": [6, 22], "3507": 6, "sqlite3_overload_funct": 6, "permiss": [6, 7, 21], "sqlite3_db_readonli": 6, "associ": [6, 9, 12], "skip": [6, 8, 11, 13], "altogeth": [6, 8], "disk": [6, 11, 21, 22], "sqlite3_seri": 6, "sqlite3_set_last_insert_rowid": 6, "setauthor": 6, "setbusyhandl": [6, 12, 13], "repeat": [6, 10], "setbusytimeout": [6, 12, 13], "sqlite3_busy_handl": 6, "thousandth": 6, "sqlite3_busy_timeout": 6, "setcommithook": [6, 11], "rollback": [6, 9, 11, 13, 19, 21, 22], "sqlite3_commit_hook": 6, "setexectrac": [6, 8], "setprofil": 6, "nanosecond": 6, "setprogresshandl": [6, 11], "nstep": 6, "inststruct": 6, "sqlite3_progress_handl": 6, "setrollbackhook": 6, "setrowtrac": [6, 8], "setupdatehook": [6, 11], "setwalhook": 6, "sqlite3_wal_hook": 6, "pylong_fromvoidptr": 6, "hood": 6, "sqlite3_total_changes64": 6, "valid": [6, 12, 14, 18, 22], "wal_autocheckpoint": [6, 19], "interv": [6, 19], "sqlite3_wal_autocheckpoint": 6, "2004": [7, 19], "2022": [7, 11, 16], "roger": [7, 10], "binn": [7, 10], "src": 7, "greg": 7, "ew": 7, "express": [7, 14, 15, 19], "impli": 7, "warranti": 7, "event": [7, 11], "held": 7, "liabl": 7, "damag": 7, "aris": 7, "grant": 7, "anyon": 7, "commerci": 7, "redistribut": 7, "freeli": 7, "subject": 7, "misrepres": 7, "claim": 7, "wrote": 7, "product": 7, "acknowledg": 7, "appreci": 7, "plainli": 7, "notic": 7, "strike": 7, "opensourc": 7, "org": 7, "explicit": 8, "databasefilenam": [8, 18], "titl": [8, 11, 14], "isbn": 8, "compos": [8, 11], "d": [8, 11, 19], "8390823904": 8, "quot": [8, 11, 19], "addition": 8, "inject": [8, 11, 19], "attack": [8, 19], "cheap": [8, 19], "fast": [8, 11], "reus": [8, 22], "million": [8, 19], "expect": [8, 12, 17, 18, 19, 21], "abandon": 8, "cursor1": 8, "cursor2": 8, "immedi": [8, 13, 19, 21], "fill": [8, 11, 14], "worri": 8, "boundari": [8, 19], "isol": [8, 19], "atom": 8, "benchmark": [8, 16, 17], "__iter__": 8, "__next__": 8, "activ": [8, 13], "confin": 8, "discard": [8, 11, 13], "append": [8, 11, 19], "sqlite3_column_nam": 8, "sqlite3_column_decltyp": 8, "sqlite3_column_database_nam": 8, "sqlite3_column_table_nam": 8, "sqlite3_column_origin_nam": 8, "book": [8, 11], "common": [8, 19], "gotcha": [8, 19], "rate": [8, 19], "908908908": 8, "neither": [8, 9], "bindingserror": [8, 12], "incompleteexecutionerror": [8, 12, 13], "unexecut": [8, 13], "model": [8, 12, 16, 18], "sqlite3_bind_int64": 8, "sqlite3_bind_nul": 8, "sqlite3_bind_text": 8, "sqlite3_bind_doubl": 8, "sqlite3_bind_blob": 8, "sqlite3_bind_zeroblob": 8, "conceptu": [8, 22], "7": [8, 11, 14, 16, 17, 19, 22], "23": [8, 16], "92": 8, "12": [8, 11, 13, 16, 21], "num": [8, 11, 18], "act": [8, 18], "expand": [8, 11], "sqlite3_expanded_sql": 8, "dbapi": [8, 16, 17], "getconnect": 8, "table_info": 8, "column_nam": [8, 11, 14], "declared_column_typ": 8, "manifest": 8, "languag": [8, 11, 20], "wibbli": 8, "wobbli": 8, "zebra": 8, "97": 8, "fjfjfj": 8, "explain": [8, 11, 14, 18], "sqlite3_stmt_isexplain": 8, "though": 8, "sqlite3_stmt_readonli": 8, "compli": 9, "constructor": [9, 21], "paramstyl": 9, "qmark": 9, "awar": [9, 13, 15, 17], "rowcount": [9, 19], "callproc": 9, "procedur": 9, "fetchmani": 9, "nextset": 9, "arrays": 9, "setinputs": 9, "setoutputs": 9, "manipul": [9, 20], "julian": [9, 21], "dai": [9, 21], "rownumb": 9, "scroll": 9, "protocol": [9, 12, 20, 22], "lastrowid": 9, "errorhandl": 9, "workflow": 10, "preconfigur": 10, "cfg": 10, "form": [10, 13, 17, 19], "choos": [10, 11, 21, 22], "40": [10, 11, 16], "sig": 10, "gpg": 10, "deb": 10, "involv": [10, 11, 12, 13, 22], "debian": 10, "fedora": 10, "gentoo": 10, "dev": [10, 19], "arch": 10, "privaci": 10, "guard": 10, "asc": [10, 22], "dsa": 10, "0dfbd904": 10, "rogerb": [10, 11], "public": 10, "keyserv": 10, "hkp": 10, "recv": 10, "gnupg": 10, "trustdb": 10, "git": 10, "demonstr": [11, 17, 21], "overview": [11, 18, 21], "env": 11, "__future__": 11, "annot": [11, 16], "filesystem": 11, "__file__": 11, "incorpor": 11, "3040000": 11, "dbfile": 11, "x": [11, 12, 13, 17, 18, 19, 22], "y": [11, 12, 13, 17, 19], "z": [11, 12, 13, 17, 19], "secret": 11, "tempt": 11, "mangl": 11, "punctuat": 11, "simpl": [11, 17, 18, 20, 21, 22], "NOT": [11, 19], "alpha": 11, "beta": 11, "gamma": 11, "sensit": 11, "9": [11, 16, 17], "types1": 11, "e": 11, "types2": 11, "real": [11, 20], "x03": 11, "x72": 11, "xf4": 11, "x00": 11, "x9e": 11, "repr": 11, "x03r": 11, "confirm": 11, "perman": [11, 19], "Or": 11, "my_trac": 11, "bar": [11, 12, 13, 17, 19], "row_trac": 11, "hand": 11, "ilove7": 11, "love": 11, "seven": 11, "averag": 11, "longest": [11, 13], "len": 11, "classmethod": 11, "cl": 11, "aggregatecallback": 11, "portion": [11, 21], "file1": 11, "file7": 11, "file17": 11, "file20": 11, "file3": 11, "str_num_col": 11, "s1": 11, "s2": 11, "isdigit": 11, "ps1": 11, "ps2": 11, "strnum": 11, "dataclass": [11, 14], "ext": [11, 14, 19], "dataclassrowfactori": [11, 14], "anim": 11, "farm": 11, "georg": 11, "orwel": 11, "1945": 11, "37": [11, 16], "pictur": 11, "dorian": 11, "grai": 11, "oscar": 11, "wild": 11, "1890": 11, "fragil": 11, "frozen": [11, 14], "dataclass_kwarg": [11, 14], "nnow": 11, "AS": [11, 14], "book_id": 11, "book_year": 11, "typesconvertercursorfactori": [11, 14], "registrar": 11, "sqlitetypeadapt": [11, 14], "__repr__": 11, "__eq__": 11, "isinst": 11, "to_sqlite_valu": [11, 14], "staticmethod": 11, "convert_from_sqlit": 11, "split": [11, 18, 22], "complex_to_sqlite_valu": 11, "complex": [11, 12, 22], "imag": [11, 12], "register_adapt": [11, 14], "register_convert": [11, 14], "sqlite_to_complex": 11, "test_data": 11, "4j": 11, "query_info": [11, 14, 19], "char": 11, "customer_id": 11, "my_own_typ": 11, "index": [11, 13, 16, 19, 21, 22], "cust_addr": 11, "join": [11, 18], "street": 11, "qd": 11, "low": [11, 14, 15], "vdbe": 11, "explain_query_plan": [11, 14], "solv": 11, "pprint": 11, "nbind": 11, "nexpanded_sql": 11, "nfirst_queri": 11, "first_queri": [11, 14], "nquery_remain": 11, "query_remain": [11, 14], "nis_explain": 11, "nis_readonli": 11, "ndescript": 11, "pformat": 11, "hasattr": 11, "ndescription_ful": 11, "nquery_plan": 11, "query_plan": [11, 14], "nfirst": 11, "queryplan": [11, 14], "queryact": [11, 14], "21": [11, 13, 14, 16], "action_nam": [11, 14], "database_nam": [11, 14], "file_nam": [11, 14], "function_nam": [11, 14], "module_nam": [11, 14], "pragma_nam": [11, 14], "pragma_valu": [11, 14], "table_nam": [11, 14], "trigger_nam": [11, 14], "trigger_or_view": [11, 14], "view_nam": [11, 14], "vdbeinstruct": [11, 14], "addr": [11, 14], "init": [11, 18], "p1": [11, 14], "p2": [11, 14], "17": [11, 16], "p3": [11, 14], "p4": [11, 14], "p5": [11, 14], "openread": 11, "13": [11, 16], "rewind": 11, "larg": [11, 12, 15], "blobbi": 11, "10000": 11, "20000": 11, "hello": 11, "world": 11, "2000": 11, "deni": [11, 12], "auth": 11, "startswith": 11, "whose": [11, 19], "private_stuff": 11, "sqlite_mast": 11, "autherror": [11, 12], "feedback": 11, "cancel": 11, "some_numb": 11, "how_mani": 11, "_": [11, 14, 19], "yield": 11, "randint": 11, "9999999999": 11, "progress_handl": 11, "biggest": 11, "max_num": 11, "max": [11, 13], "9996980943": 11, "veto": 11, "my_commit_hook": 11, "hour": 11, "localtim": 11, "8am": 11, "6pm": 11, "constrainterror": [11, 12], "my_update_hook": 11, "file93": 11, "file94": 11, "heavi": 11, "lift": 11, "filter": [11, 13, 22], "vtcolumn": 11, "get_file_data": 11, "counter": 11, "listdir": 11, "isfil": 11, "st": 11, "stat": 11, "field": [11, 13, 14, 15, 18, 19, 22], "dir": 11, "st_": 11, "getattr": 11, "modulenam": [11, 22], "tablenam": [11, 22], "eval": 11, "disconnect": [11, 22], "po": 11, "eof": [11, 18, 22], "col": 11, "filesourc": 11, "sysdir": 11, "isdir": 11, "sysfil": 11, "st_size": 11, "desc": [11, 22], "ctime": 11, "st_ctime": 11, "546696": 11, "_ctype": [11, 21], "310d": 11, "dynload": 11, "511328": 11, "_ssl": 11, "450008": 11, "_testcapi": 11, "1641597423": 11, "5541885": 11, "sitecustom": 11, "1664920933": 11, "397524": 11, "_gdbm": 11, "1664921015": 11, "6046188": 11, "_tkinter": 11, "monitor": 11, "flow": 11, "xor": 11, "0xa5": 11, "obfuscatedvf": 11, "basevf": 11, "vfs_name": 11, "base_vf": 11, "uri_paramet": [11, 21], "uri_int": [11, 21], "warp": 11, "uri_boolean": [11, 21], "notpres": 11, "obfuscatedvfsfil": 11, "xread": [11, 21], "xwrite": [11, 21], "encrypt": 11, "inheritfromvfsnam": 11, "instanti": 11, "obfuvf": 11, "obfudb": 11, "myobfudb": 11, "And": [11, 17], "unobfusc": 11, "tidi": [11, 19], "memdb": 11, "excl": 11, "dotfil": 11, "journal": [11, 19, 21], "xf6": 11, "xe9": 11, "xcc": 11, "xd1": 11, "xc0": 11, "x85": 11, "xc3": 11, "xca": 11, "xd7": 11, "xc8": 11, "xc4": 11, "x96": 11, "xa5": 11, "xb5": 11, "xa4": 11, "x10": 11, "x01": 11, "sqlite_limit_": 11, "max_nam": 11, "orig": 11, "0x7fffffff": 11, "testlimit": 11, "1023": 11, "exceed": 11, "toobigerror": [11, 12], "caught": [11, 12], "toobig": [11, 13], "largest": 11, "1000000000": 11, "sqlite_max_length": 11, "sqlite_max_column": 11, "batch": [11, 18, 19], "memcon": 11, "export": 11, "io": 11, "stdout": [11, 13, 18], "dot": [11, 18], "process_command": [11, 18], "process_sql": [11, 18], "csvtest": 11, "column1": 11, "column2": 11, "figur": 11, "process_complete_lin": [11, 18], "getvalu": 11, "ndump": 11, "sun": 11, "nov": 11, "27": [11, 13, 16, 22], "07": 11, "clamp": 11, "page_s": 11, "4096": [11, 21], "utf": [11, 13, 18, 21], "max_page_count": 11, "1073741823": 11, "IF": [11, 19], "INTO": 11, "current_usag": 11, "max_usag": 11, "298832": 11, "345560": 11, "rule": [11, 14, 22], "middl": 11, "partial": [11, 19, 21], "shm": 11, "extendedresult": [12, 21], "connectionnotclosederror": 12, "connectionclosederror": 12, "incorrect": 12, "unnam": 12, "perfectli": 12, "spuriou": 12, "executioncompleteerror": 12, "exectraceabort": [12, 13], "vfsnotimplementederror": 12, "vfsfileclosederror": 12, "mismatcherror": 12, "mismatch": 12, "internalerror": 12, "protocolerror": 12, "misuseerror": [12, 19], "enough": 12, "spec": 12, "127": [12, 13], "rangeerror": 12, "2nd": 12, "sqlite3_bind": 12, "permissionserror": 12, "readonlyerror": [12, 22], "cantopenerror": 12, "aborterror": 12, "unlock": 12, "schemachangeerror": 12, "reprepar": [12, 13], "violat": 12, "nomemerror": 12, "ioerror": [12, 21], "corrupterror": 12, "inconsist": [12, 18], "exce": 12, "nolfserror": 12, "emptyerror": 12, "formaterror": 12, "auxiliari": 12, "notadberror": 12, "inde": 12, "difficult": [12, 19], "fire": 12, "myfunc": 12, "con": [12, 17, 19, 22], "fam": 12, "11": [12, 16], "zerodivisionerror": 12, "divis": 12, "modulo": 12, "3412": 12, "resetcursor": [12, 17], "1597": 12, "examin": 12, "But": 12, "aid": 12, "troubleshoot": [12, 16], "print_exc_plu": 12, "tb": 12, "exc_info": [12, 21], "tb_frame": 12, "f_code": 12, "co_nam": 12, "co_filenam": 12, "f_lineno": 12, "f_local": 12, "vstr": 12, "stringifi": 12, "tb_next": 12, "my": [12, 17], "erron": 12, "1387": 12, "testvtabl": 12, "allconstraint": 12, "vtabl": [12, 22], "__main__": 12, "0x988f30": 12, "1000": [12, 22], "4050": 12, "cursor_execut": 12, "0x978800": 12, "2681": 12, "virtualt": 12, "xbestindex": 12, "0x98d8c0": 12, "997": 12, "xea": 12, "2559": 12, "result_constraint": 12, "represent": [13, 14, 18, 20, 21], "bam": 13, "stdin": [13, 18], "chanc": 13, "aspw": [13, 20], "acquir": [13, 19], "timeout": [13, 18, 19], "arisen": 13, "rememb": [13, 21], "quantiti": [13, 20, 21, 22], "2125": 13, "3246": 13, "classic": 13, "trade": 13, "cpu": 13, "consumpt": [13, 14, 19], "least": [13, 21], "pick": [13, 18], "101": 13, "prioriti": 13, "yourscript": 13, "pythonscript": 13, "pythonscriptopt": 13, "send": [13, 18], "dash": [13, 18], "word": [13, 15, 18], "l": 13, "30": [13, 16], "top": 13, "15": [13, 16], "individu": 13, "1e0e5a0": 13, "152": 13, "7fccea8456e0": 13, "readwrit": 13, "1f72ac0": 13, "161": 13, "testdb": 13, "1f6b8d0": 13, "162": 13, "239": 13, "kjfhgk": 13, "gkjlfdhgjkhsdfkjg": 13, "gklsdfjgkldfjhnbnvc": 13, "mnxb": 13, "mnxcv": 13, "242": 13, "gdfklhj": 13, "gjkhgfdsgfd": 13, "gjkfhgjkhdfkjh": 13, "244": 13, "245": 13, "gdfjkhg": 13, "gkjlfd": 13, "247": 13, "257": 13, "threadid": 13, "remaind": 13, "given": [13, 18, 22], "sqlite_open": 13, "prefix": 13, "connectionid": 13, "slept": 13, "073": 13, "1308": 13, "3082": 13, "127973": 13, "578": 13, "2369": 13, "spent": 13, "530": 13, "121451": 13, "1220": 13, "1118": 13, "909": 13, "timesten": 13, "654": 13, "426": 13, "t1": 13, "146": 13, "88": 13, "79": 13, "76": 13, "71": 13, "locking_mod": 13, "abcdefghijklmnopqrstuvwxyz": 13, "t2": 13, "sum": [13, 14], "illustr": 13, "413": 13, "94": 13, "305": 13, "120637": 13, "941": 13, "121449": 13, "179": 13, "509": 13, "380": 13, "foo_x": 13, "715": 13, "38": [13, 16, 19], "420": 13, "241": 13, "206": 13, "61": 13, "170": 13, "165": 13, "158": 13, "snap": 13, "80": 13, "150": 13, "001": 13, "377": 13, "102": 13, "944": 13, "893": 13, "817": 13, "816": 13, "786": 13, "783": 13, "713": 13, "701": 13, "651": 13, "646": 13, "631": 13, "620": 13, "adapt": 14, "taken": 14, "bytecod": 14, "__description__": 14, "_2": 14, "_3": 14, "make_dataclass": 14, "slot": 14, "get_dataclass": 14, "potenti": 14, "get_typ": 14, "hint": 14, "affin": [14, 20], "__call__": 14, "metaclass": 14, "convers": [14, 16, 17, 18, 20], "yourclassher": 14, "suffici": 14, "abstract": [14, 17], "abstract_base_class": 14, "abcmeta": 14, "capabl": [14, 21], "klass": 14, "typeconvertercursor": 14, "adapt_valu": 14, "convert_valu": 14, "schematyp": 14, "wrap_bind": 14, "wrap_sequence_bind": 14, "dictadapt": 14, "querydetail": 14, "discov": 14, "goto": 14, "loop": [14, 18, 19], "human": 14, "readabl": 14, "fourth": 14, "fifth": 14, "intend": [15, 19, 22], "edg": 15, "network": [15, 18], "r1": 16, "januari": 16, "wrapper": [16, 17], "thinnest": 16, "vagu": 16, "compliant": [16, 17], "intention": 16, "primarili": 16, "unexpect": [16, 17, 21], "vtmodul": 16, "vtcursor": 16, "entranc": 16, "copyright": 16, "histori": 16, "36": 16, "35": 16, "34": 16, "33": 16, "31": 16, "29": 16, "28": 16, "26": [16, 20], "24": 16, "22": 16, "19": 16, "18": 16, "14": [16, 19], "r2": 16, "r3": 16, "fundament": 17, "hide": 17, "nuanc": 17, "suggest": 17, "independ": 17, "enhanc": 17, "stai": 17, "care": [17, 18, 22], "complianc": 17, "swallow": 17, "harder": 17, "poor": 17, "substitut": 17, "badfunc": 17, "create_funct": 17, "func": 17, "operationalerror": 17, "3660": 17, "1871": 17, "debugg": 17, "util": 17, "81": 17, "unsupport": 17, "awai": 17, "administr": 18, "quirk": 18, "edit": 18, "instantli": 18, "readlin": 18, "pyreadline3": 18, "registri": 18, "bail": 18, "echo": 18, "suitabl": [18, 22], "nullvalu": 18, "liter": 18, "quit": [18, 19], "pattern": 18, "accept": 18, "cmd": 18, "nocolour": 18, "screen": 18, "introspect": 18, "programmat": [18, 19], "transmit": 18, "iso8859": 18, "sji": 18, "offer": 18, "choic": [18, 22], "best": [18, 19, 20, 22], "strict": 18, "xml": 18, "entiti": 18, "iso": 18, "8859": 18, "pythonioencod": 18, "joel": [18, 20], "articl": [18, 20], "excel": 18, "Not": 18, "command_exit": 18, "doc": 18, "output_html": 18, "monkei": 18, "patch": 18, "textio": 18, "err": 18, "argv": [18, 22], "process_arg": 18, "wish": [18, 21], "ever": 18, "sent": 18, "command_help": 18, "output_column": 18, "huge": [18, 22], "baffl": 18, "cmdloop": 18, "intro": 18, "banner": 18, "token": 18, "member": [18, 22], "complete_command": 18, "complete_sql": 18, "beg": 18, "display_tim": 18, "b4": 18, "get_resource_usag": 18, "fixup_backslash": 18, "backlash": 18, "backslash": 18, "shlex": 18, "getcompletelin": 18, "semicolon": 18, "getlin": 18, "handle_except": 18, "rerais": 18, "handle_interrupt": 18, "keyboard": 18, "pop_input": 18, "linenumb": 18, "pop": 18, "pop_output": 18, "temporarili": 18, "push_output": 18, "initfil": 18, "sqlncommand": 18, "upon": 18, "enter": 18, "front": [18, 19], "unrecogn": 18, "process_unknown_arg": 18, "posix": 18, "recogn": 18, "push_input": 18, "set_encod": 18, "enc": 18, "dest": 18, "mail": [19, 21], "post": 19, "email": 19, "approxim": [19, 22], "quarterli": 19, "browser": 19, "client": 19, "photo": 19, "mobil": 19, "desktop": 19, "despit": 19, "retain": 19, "forward": 19, "think": 19, "lookup": 19, "mirror": 19, "todai": 19, "wouldn": 19, "broad": 19, "decad": 19, "strong": 19, "opt": 19, "foreign": 19, "robust": 19, "success": 19, "refactor": 19, "interpol": 19, "seem": 19, "difficulti": 19, "feel": 19, "experi": 19, "thought": 19, "signal": [19, 21], "facil": 19, "logger": 19, "errcod": 19, "errstr": 19, "sqlite_log": 19, "28729": 19, "7dd4968f23": 19, "os_unix": 19, "mainten": 19, "ensure_schema": 19, "baz": 19, "application_id": 19, "occasion": 19, "litter": 19, "fairli": 19, "alia": 19, "my_hook": 19, "driver": 19, "dict_row": 19, "k": 19, "enumer": 19, "my_factori": 19, "coordin": 19, "goal": 19, "lax": 19, "decid": 19, "techniqu": 19, "pitfal": 19, "big": [19, 22], "59": 19, "overal": 19, "tune": 19, "mp3": 19, "player": 19, "benefit": 19, "drawback": 19, "setwal": 19, "journal_mod": 19, "overflow": 20, "loss": 20, "precis": 20, "meet": [20, 22], "utf16": 20, "transpar": 20, "upper": 20, "lower": 20, "turkic": 20, "letter": 20, "german": 20, "\u00df": 20, "ss": 20, "accent": 20, "european": 20, "fortun": 20, "roman": 20, "stuff": 20, "confus": [20, 21], "sadli": 20, "latter": 20, "earli": 20, "late": 20, "troubl": 21, "convent": 21, "xcurrenttim": 21, "myvf": 21, "easiest": 21, "Then": 21, "overridden": 21, "translat": [21, 22], "vari": 21, "xdlopen": 21, "xsleep": 21, "unifi": 21, "obsolet": 21, "playback": 21, "obscur": 21, "pyerr_displai": 21, "divid": 21, "zerodivis": 21, "closest": 21, "recoveri": 21, "makedefault": 21, "maxpathnam": 21, "sqlite3_vfs_regist": 21, "sqlite3_vfs_find": 21, "unavail": 21, "sqlite3_vfs_unregist": 21, "accordingli": 21, "fraction": 21, "timezon": 21, "utc": 21, "syncdir": 21, "platter": 21, "reboot": 21, "xdlclose": 21, "unload": 21, "underscor": 21, "dlclose": 21, "freelibrari": 21, "xdlerror": 21, "cdll": 21, "loadlibrari": 21, "_handl": 21, "ptr": 21, "dlsym": 21, "win32": 21, "kernel32": 21, "getprocaddress": 21, "abspath": 21, "xgetsystemcal": 21, "xnextsystemcal": 21, "inputflag": 21, "outputflag": 21, "xrandom": 21, "numbyt": 21, "seed": 21, "surplu": 21, "xsetsystemcal": 21, "scenario": 21, "lifetim": 21, "systemcal": 21, "paus": 21, "millionth": 21, "nearest": 21, "inflag": 21, "outflag": 21, "xshm": 21, "xcheckreservedlock": 21, "xclose": 21, "xdevicecharacterist": 21, "bitwis": 21, "unrecognis": 21, "1027": 21, "process_quick": 21, "elif": 21, "1028": 21, "xfiles": 21, "xlock": 21, "famili": 21, "someon": 21, "fatal": 21, "xsectors": 21, "xsync": 21, "newsiz": 21, "decreas": 21, "convolut": 21, "sqlite3_uri_boolean": 21, "sqlite3_uri_int64": 21, "sqlite3_uri_paramet": 21, "person": 22, "might": 22, "ini": 22, "remot": 22, "backend": 22, "amazon": 22, "dynam": 22, "reformat": 22, "dataset": 22, "relation": 22, "helper": 22, "mymod": 22, "mymoduleclass": 22, "arg1": 22, "advis": 22, "heavyweight": 22, "mymodul": 22, "knowledg": 22, "seri": 22, "updatechangerow": 22, "orderbi": 22, "satisfi": 22, "slightli": 22, "unus": 22, "constraintarg": 22, "visit": 22, "price": 22, "74": 22, "answer": 22, "acm": 22, "widget": 22, "said": 22, "signific": 22, "descend": 22, "ascend": 22, "estim": 22, "cost": 22, "idx_pr_cust": 22, "opposit": 22, "newnam": 22, "notif": 22, "newrowid": 22, "updatedeleterow": 22, "updateinsertrow": 22, "assign": 22, "indexnum": 22, "indexnam": 22, "indexstr": 22, "recip": 22, "compound": 22, "mask": 22, "vice": 22, "versa": 22, "respons": 22}, "objects": {"": [[0, 0, 0, "-", "apsw"]], "apsw": [[12, 1, 1, "", "AbortError"], [0, 2, 1, "", "AggregateFactory"], [0, 2, 1, "", "AggregateFinal"], [0, 2, 1, "", "AggregateStep"], [0, 2, 1, "", "AggregateT"], [12, 1, 1, "", "AuthError"], [0, 2, 1, "", "Authorizer"], [1, 2, 1, "", "Backup"], [0, 2, 1, "", "Bindings"], [12, 1, 1, "", "BindingsError"], [3, 2, 1, "", "Blob"], [12, 1, 1, "", "BusyError"], [12, 1, 1, "", "CantOpenError"], [0, 2, 1, "", "CommitHook"], [6, 2, 1, "", "Connection"], [12, 1, 1, "", "ConnectionClosedError"], [12, 1, 1, "", "ConnectionNotClosedError"], [12, 1, 1, "", "ConstraintError"], [12, 1, 1, "", "CorruptError"], [8, 2, 1, "", "Cursor"], [12, 1, 1, "", "CursorClosedError"], [12, 1, 1, "", "EmptyError"], [12, 1, 1, "", "Error"], [12, 1, 1, "", "ExecTraceAbort"], [0, 2, 1, "", "ExecTracer"], [12, 1, 1, "", "ExecutionCompleteError"], [12, 1, 1, "", "ExtensionLoadingError"], [12, 1, 1, "", "ForkingViolationError"], [12, 1, 1, "", "FormatError"], [12, 1, 1, "", "FullError"], [12, 1, 1, "", "IOError"], [12, 1, 1, "", "IncompleteExecutionError"], [12, 1, 1, "", "InternalError"], [12, 1, 1, "", "InterruptError"], [12, 1, 1, "", "LockedError"], [12, 1, 1, "", "MismatchError"], [12, 1, 1, "", "MisuseError"], [12, 1, 1, "", "NoLFSError"], [12, 1, 1, "", "NoMemError"], [12, 1, 1, "", "NotADBError"], [12, 1, 1, "", "NotFoundError"], [12, 1, 1, "", "PermissionsError"], [12, 1, 1, "", "ProtocolError"], [12, 1, 1, "", "RangeError"], [12, 1, 1, "", "ReadOnlyError"], [0, 2, 1, "", "RowTracer"], [12, 1, 1, "", "SQLError"], [0, 4, 1, "", "SQLITE_VERSION_NUMBER"], [0, 2, 1, "", "SQLiteValue"], [0, 2, 1, "", "SQLiteValues"], [0, 2, 1, "", "ScalarProtocol"], [12, 1, 1, "", "SchemaChangeError"], [12, 1, 1, "", "ThreadingViolationError"], [12, 1, 1, "", "TooBigError"], [21, 2, 1, "", "URIFilename"], [21, 2, 1, "", "VFS"], [21, 2, 1, "", "VFSFile"], [12, 1, 1, "", "VFSFileClosedError"], [12, 1, 1, "", "VFSNotImplementedError"], [22, 2, 1, "", "VTCursor"], [22, 2, 1, "", "VTModule"], [22, 2, 1, "", "VTTable"], [0, 3, 1, "", "apswversion"], [0, 4, 1, "", "compile_options"], [0, 3, 1, "", "complete"], [0, 3, 1, "", "config"], [0, 4, 1, "", "connection_hooks"], [0, 3, 1, "", "enablesharedcache"], [0, 3, 1, "", "exceptionfor"], [14, 0, 0, "-", "ext"], [0, 3, 1, "", "fork_checker"], [0, 3, 1, "", "format_sql_value"], [0, 3, 1, "", "initialize"], [0, 4, 1, "", "keywords"], [0, 3, 1, "", "log"], [0, 6, 1, "", "mapping_access"], [0, 6, 1, "", "mapping_authorizer_function"], [0, 6, 1, "", "mapping_authorizer_return"], [0, 6, 1, "", "mapping_bestindex_constraints"], [0, 6, 1, "", "mapping_config"], [0, 6, 1, "", "mapping_conflict_resolution_modes"], [0, 6, 1, "", "mapping_db_config"], [0, 6, 1, "", "mapping_db_status"], [0, 6, 1, "", "mapping_device_characteristics"], [0, 6, 1, "", "mapping_extended_result_codes"], [0, 6, 1, "", "mapping_file_control"], [0, 6, 1, "", "mapping_limits"], [0, 6, 1, "", "mapping_locking_level"], [0, 6, 1, "", "mapping_open_flags"], [0, 6, 1, "", "mapping_prepare_flags"], [0, 6, 1, "", "mapping_result_codes"], [0, 6, 1, "", "mapping_status"], [0, 6, 1, "", "mapping_sync"], [0, 6, 1, "", "mapping_txn_state"], [0, 6, 1, "", "mapping_virtual_table_configuration_options"], [0, 6, 1, "", "mapping_virtual_table_scan_flags"], [0, 6, 1, "", "mapping_wal_checkpoint"], [0, 6, 1, "", "mapping_xshmlock_flags"], [0, 3, 1, "", "memoryhighwater"], [0, 3, 1, "", "memoryused"], [0, 3, 1, "", "randomness"], [0, 3, 1, "", "releasememory"], [18, 0, 0, "-", "shell"], [0, 3, 1, "", "shutdown"], [0, 3, 1, "", "softheaplimit"], [0, 3, 1, "", "sqlite3_sourceid"], [0, 3, 1, "", "sqlitelibversion"], [0, 3, 1, "", "status"], [0, 4, 1, "", "using_amalgamation"], [0, 3, 1, "", "vfsnames"], [3, 2, 1, "", "zeroblob"]], "apsw.Backup": [[1, 3, 1, "", "__enter__"], [1, 3, 1, "", "__exit__"], [1, 3, 1, "", "close"], [1, 4, 1, "", "done"], [1, 3, 1, "", "finish"], [1, 4, 1, "", "pagecount"], [1, 4, 1, "", "remaining"], [1, 3, 1, "", "step"]], "apsw.Blob": [[3, 3, 1, "", "__enter__"], [3, 3, 1, "", "__exit__"], [3, 3, 1, "", "close"], [3, 3, 1, "", "length"], [3, 3, 1, "", "read"], [3, 3, 1, "", "readinto"], [3, 3, 1, "", "reopen"], [3, 3, 1, "", "seek"], [3, 3, 1, "", "tell"], [3, 3, 1, "", "write"]], "apsw.Connection": [[6, 3, 1, "", "__enter__"], [6, 3, 1, "", "__exit__"], [6, 4, 1, "", "authorizer"], [6, 3, 1, "", "autovacuum_pages"], [6, 3, 1, "", "backup"], [6, 3, 1, "", "blobopen"], [6, 3, 1, "", "cache_stats"], [6, 3, 1, "", "changes"], [6, 3, 1, "", "close"], [6, 3, 1, "", "collationneeded"], [6, 3, 1, "", "config"], [6, 3, 1, "", "createaggregatefunction"], [6, 3, 1, "", "createcollation"], [6, 3, 1, "", "createmodule"], [6, 3, 1, "", "createscalarfunction"], [6, 3, 1, "", "cursor"], [6, 4, 1, "", "cursor_factory"], [6, 3, 1, "", "db_filename"], [6, 3, 1, "", "db_names"], [6, 3, 1, "", "deserialize"], [6, 3, 1, "", "enableloadextension"], [6, 4, 1, "", "exectrace"], [6, 3, 1, "", "execute"], [6, 3, 1, "", "executemany"], [6, 3, 1, "", "filecontrol"], [6, 4, 1, "", "filename"], [6, 3, 1, "", "getautocommit"], [6, 3, 1, "", "getexectrace"], [6, 3, 1, "", "getrowtrace"], [6, 4, 1, "", "in_transaction"], [6, 3, 1, "", "interrupt"], [6, 3, 1, "", "last_insert_rowid"], [6, 3, 1, "", "limit"], [6, 3, 1, "", "loadextension"], [6, 4, 1, "", "open_flags"], [6, 4, 1, "", "open_vfs"], [6, 3, 1, "", "overloadfunction"], [6, 3, 1, "", "readonly"], [6, 4, 1, "", "rowtrace"], [6, 3, 1, "", "serialize"], [6, 3, 1, "", "set_last_insert_rowid"], [6, 3, 1, "", "setauthorizer"], [6, 3, 1, "", "setbusyhandler"], [6, 3, 1, "", "setbusytimeout"], [6, 3, 1, "", "setcommithook"], [6, 3, 1, "", "setexectrace"], [6, 3, 1, "", "setprofile"], [6, 3, 1, "", "setprogresshandler"], [6, 3, 1, "", "setrollbackhook"], [6, 3, 1, "", "setrowtrace"], [6, 3, 1, "", "setupdatehook"], [6, 3, 1, "", "setwalhook"], [6, 3, 1, "", "sqlite3pointer"], [6, 3, 1, "", "status"], [6, 3, 1, "", "totalchanges"], [6, 3, 1, "", "txn_state"], [6, 3, 1, "", "wal_autocheckpoint"], [6, 3, 1, "", "wal_checkpoint"]], "apsw.Cursor": [[8, 3, 1, "", "__iter__"], [8, 3, 1, "", "__next__"], [8, 3, 1, "", "close"], [8, 4, 1, "", "connection"], [8, 4, 1, "", "description"], [8, 4, 1, "", "description_full"], [8, 4, 1, "", "exectrace"], [8, 3, 1, "", "execute"], [8, 3, 1, "", "executemany"], [8, 4, 1, "", "expanded_sql"], [8, 3, 1, "", "fetchall"], [8, 3, 1, "", "fetchone"], [8, 3, 1, "", "getconnection"], [8, 3, 1, "", "getdescription"], [8, 3, 1, "", "getexectrace"], [8, 3, 1, "", "getrowtrace"], [8, 4, 1, "", "is_explain"], [8, 4, 1, "", "is_readonly"], [8, 4, 1, "", "rowtrace"], [8, 3, 1, "", "setexectrace"], [8, 3, 1, "", "setrowtrace"]], "apsw.Error": [[12, 4, 1, "", "extendedresult"], [12, 4, 1, "", "result"]], "apsw.URIFilename": [[21, 3, 1, "", "filename"], [21, 3, 1, "", "uri_boolean"], [21, 3, 1, "", "uri_int"], [21, 3, 1, "", "uri_parameter"]], "apsw.VFS": [[21, 3, 1, "", "excepthook"], [21, 3, 1, "", "unregister"], [21, 3, 1, "", "xAccess"], [21, 3, 1, "", "xCurrentTime"], [21, 3, 1, "", "xDelete"], [21, 3, 1, "", "xDlClose"], [21, 3, 1, "", "xDlError"], [21, 3, 1, "", "xDlOpen"], [21, 3, 1, "", "xDlSym"], [21, 3, 1, "", "xFullPathname"], [21, 3, 1, "", "xGetLastError"], [21, 3, 1, "", "xGetSystemCall"], [21, 3, 1, "", "xNextSystemCall"], [21, 3, 1, "", "xOpen"], [21, 3, 1, "", "xRandomness"], [21, 3, 1, "", "xSetSystemCall"], [21, 3, 1, "", "xSleep"]], "apsw.VFSFile": [[21, 3, 1, "", "excepthook"], [21, 3, 1, "", "xCheckReservedLock"], [21, 3, 1, "", "xClose"], [21, 3, 1, "", "xDeviceCharacteristics"], [21, 3, 1, "", "xFileControl"], [21, 3, 1, "", "xFileSize"], [21, 3, 1, "", "xLock"], [21, 3, 1, "", "xRead"], [21, 3, 1, "", "xSectorSize"], [21, 3, 1, "", "xSync"], [21, 3, 1, "", "xTruncate"], [21, 3, 1, "", "xUnlock"], [21, 3, 1, "", "xWrite"]], "apsw.VTCursor": [[22, 3, 1, "", "Close"], [22, 3, 1, "", "Column"], [22, 3, 1, "", "Eof"], [22, 3, 1, "", "Filter"], [22, 3, 1, "", "Next"], [22, 3, 1, "", "Rowid"]], "apsw.VTModule": [[22, 3, 1, "", "Connect"], [22, 3, 1, "", "Create"]], "apsw.VTTable": [[22, 3, 1, "", "Begin"], [22, 3, 1, "", "BestIndex"], [22, 3, 1, "", "Commit"], [22, 3, 1, "", "Destroy"], [22, 3, 1, "", "Disconnect"], [22, 3, 1, "", "FindFunction"], [22, 3, 1, "", "Open"], [22, 3, 1, "", "Rename"], [22, 3, 1, "", "Rollback"], [22, 3, 1, "", "Sync"], [22, 3, 1, "", "UpdateChangeRow"], [22, 3, 1, "", "UpdateDeleteRow"], [22, 3, 1, "", "UpdateInsertRow"]], "apsw.ext": [[14, 2, 1, "", "DataClassRowFactory"], [14, 2, 1, "", "QueryAction"], [14, 2, 1, "", "QueryDetails"], [14, 2, 1, "", "QueryPlan"], [14, 2, 1, "", "SQLiteTypeAdapter"], [14, 2, 1, "", "TypesConverterCursorFactory"], [14, 2, 1, "", "VDBEInstruction"], [14, 5, 1, "", "query_info"]], "apsw.ext.DataClassRowFactory": [[14, 3, 1, "", "__call__"], [14, 3, 1, "", "get_dataclass"], [14, 3, 1, "", "get_type"]], "apsw.ext.QueryAction": [[14, 4, 1, "", "action"], [14, 4, 1, "", "action_name"], [14, 4, 1, "", "column_name"], [14, 4, 1, "", "database_name"], [14, 4, 1, "", "file_name"], [14, 4, 1, "", "function_name"], [14, 4, 1, "", "module_name"], [14, 4, 1, "", "operation"], [14, 4, 1, "", "pragma_name"], [14, 4, 1, "", "pragma_value"], [14, 4, 1, "", "table_name"], [14, 4, 1, "", "trigger_name"], [14, 4, 1, "", "trigger_or_view"], [14, 4, 1, "", "view_name"]], "apsw.ext.QueryDetails": [[14, 4, 1, "", "actions"], [14, 4, 1, "", "bindings"], [14, 4, 1, "", "description"], [14, 4, 1, "", "description_full"], [14, 4, 1, "", "expanded_sql"], [14, 4, 1, "", "explain"], [14, 4, 1, "", "first_query"], [14, 4, 1, "", "is_explain"], [14, 4, 1, "", "is_readonly"], [14, 4, 1, "", "query"], [14, 4, 1, "", "query_plan"], [14, 4, 1, "", "query_remaining"]], "apsw.ext.QueryPlan": [[14, 4, 1, "", "detail"], [14, 4, 1, "", "sub"]], "apsw.ext.SQLiteTypeAdapter": [[14, 3, 1, "", "to_sqlite_value"]], "apsw.ext.TypesConverterCursorFactory": [[14, 2, 1, "", "DictAdapter"], [14, 2, 1, "", "TypeConverterCursor"], [14, 3, 1, "", "__call__"], [14, 3, 1, "", "adapt_value"], [14, 3, 1, "", "convert_value"], [14, 3, 1, "", "register_adapter"], [14, 3, 1, "", "register_converter"], [14, 3, 1, "", "wrap_bindings"], [14, 3, 1, "", "wrap_sequence_bindings"]], "apsw.ext.TypesConverterCursorFactory.TypeConverterCursor": [[14, 3, 1, "", "execute"], [14, 3, 1, "", "executemany"]], "apsw.ext.VDBEInstruction": [[14, 4, 1, "", "addr"], [14, 4, 1, "", "comment"], [14, 4, 1, "", "opcode"], [14, 4, 1, "", "p1"], [14, 4, 1, "", "p2"], [14, 4, 1, "", "p3"], [14, 4, 1, "", "p4"], [14, 4, 1, "", "p5"]], "apsw.shell": [[18, 2, 1, "", "Shell"], [18, 5, 1, "", "main"]], "apsw.shell.Shell": [[18, 1, 1, "", "Error"], [18, 3, 1, "", "cmdloop"], [18, 3, 1, "", "complete"], [18, 3, 1, "", "complete_command"], [18, 3, 1, "", "complete_sql"], [18, 7, 1, "", "db"], [18, 3, 1, "", "display_timing"], [18, 3, 1, "", "fixup_backslashes"], [18, 3, 1, "", "get_resource_usage"], [18, 3, 1, "", "getcompleteline"], [18, 3, 1, "", "getline"], [18, 3, 1, "", "handle_exception"], [18, 3, 1, "", "handle_interrupt"], [18, 3, 1, "", "pop_input"], [18, 3, 1, "", "pop_output"], [18, 3, 1, "", "process_args"], [18, 3, 1, "", "process_command"], [18, 3, 1, "", "process_complete_line"], [18, 3, 1, "", "process_sql"], [18, 3, 1, "", "process_unknown_args"], [18, 3, 1, "", "push_input"], [18, 3, 1, "", "push_output"], [18, 3, 1, "", "set_encoding"], [18, 3, 1, "", "usage"], [18, 3, 1, "", "write"]], "apsw.zeroblob": [[3, 3, 1, "", "length"]]}, "objtypes": {"0": "py:module", "1": "py:exception", "2": "py:class", "3": "py:method", "4": "py:attribute", "5": "py:function", "6": "py:data", "7": "py:property"}, "objnames": {"0": ["py", "module", "Python module"], "1": ["py", "exception", "Python exception"], "2": ["py", "class", "Python class"], "3": ["py", "method", "Python method"], "4": ["py", "attribute", "Python attribute"], "5": ["py", "function", "Python function"], "6": ["py", "data", "Python data"], "7": ["py", "property", "Python property"]}, "titleterms": {"apsw": [0, 4, 11, 12, 13, 16, 17, 19], "modul": [0, 9, 17], "type": [0, 9, 11, 14, 20], "annot": 0, "api": [0, 9, 14], "refer": [0, 14], "sqlite": [0, 4, 11, 12, 14, 19], "constant": 0, "backup": [1, 11], "import": 1, "detail": [1, 11, 14], "class": [1, 3, 6, 8, 18, 21, 22], "benchmark": 2, "speedtest": 2, "blob": [3, 11], "input": 3, "output": 3, "zeroblob": 3, "build": 4, "setup": 4, "py": 4, "addit": 4, "flag": 4, "fetch": 4, "build_ext": 4, "match": 4, "option": [4, 9], "find": 4, "3": [4, 5], "recommend": 4, "sourc": [4, 10], "distribut": 4, "advanc": 4, "test": 4, "chang": 5, "histori": 5, "40": 5, "0": 5, "39": 5, "4": [5, 15], "2": 5, "1": 5, "38": 5, "5": [5, 15], "r1": 5, "37": 5, "36": 5, "35": 5, "34": 5, "33": 5, "32": 5, "31": 5, "30": 5, "29": 5, "28": 5, "27": 5, "26": 5, "25": 5, "24": 5, "23": 5, "22": 5, "21": 5, "20": 5, "19": 5, "18": 5, "17": 5, "16": 5, "15": 5, "14": 5, "13": 5, "12": 5, "11": 5, "9": 5, "8": 5, "10": 5, "7": 5, "6": 5, "r2": 5, "r3": 5, "connect": [6, 9, 19], "databas": [6, 11, 19], "copyright": 7, "licens": 7, "cursor": [8, 9, 19], "execut": [8, 11, 13], "sql": [8, 11, 19], "dbapi": 9, "note": [9, 18], "interfac": 9, "object": 9, "db": 9, "extens": [9, 15], "download": 10, "pypi": 10, "pip": 10, "verifi": 10, "your": [10, 11, 19], "code": 10, "control": [10, 11], "exampl": [11, 18], "tour": 11, "check": 11, "version": [11, 19], "open": 11, "why": 11, "you": 11, "us": [11, 14], "bind": [11, 19], "provid": 11, "valu": 11, "sequenc": 11, "dict": 11, "differ": [11, 17, 19], "transact": [11, 19], "executemani": 11, "trace": [11, 12, 13], "return": 11, "row": [11, 13, 14], "defin": 11, "own": 11, "function": [11, 14], "aggreg": 11, "collat": 11, "sort": 11, "access": [11, 14], "result": [11, 14], "column": [11, 14], "name": [11, 14], "convers": 11, "out": [11, 14], "queri": [11, 14], "i": [11, 19], "o": 11, "author": 11, "what": [11, 17], "can": 11, "do": 11, "progress": 11, "handler": 11, "commit": 11, "hook": 11, "updat": [11, 19], "virtual": [11, 21, 22], "tabl": [11, 22], "vf": [11, 21], "file": [11, 21], "system": [11, 21], "limit": 11, "an": 11, "shell": [11, 18], "statist": 11, "cleanup": 11, "except": [12, 21], "specif": 12, "gener": 12, "error": [12, 21], "intern": 12, "permiss": 12, "etc": 12, "abort": 12, "busi": [12, 19], "memori": 12, "disk": 12, "augment": 12, "stack": 12, "model": 13, "multi": 13, "thread": 13, "re": 13, "entranc": 13, "64": 13, "bit": [13, 14], "host": 13, "statement": 13, "cach": [13, 19], "tracer": 13, "variou": 14, "interest": 14, "convert": 14, "inform": 14, "fts3": 15, "icu": 15, "json1": 15, "rbu": 15, "rtree": 15, "document": 16, "sqlite3": 17, "doe": 17, "better": 17, "command": 18, "line": 18, "usag": 18, "unicod": [18, 20], "tip": 19, "about": 19, "python": 19, "diagnost": 19, "manag": 19, "schema": 19, "pars": 19, "unexpect": 19, "behaviour": 19, "custom": 19, "handl": 19, "share": 19, "mode": 19, "write": 19, "ahead": 19, "log": 19, "map": 20, "vfsfile": 21, "urifilenam": 21, "vtmodul": 22, "vttabl": 22, "vtcursor": 22, "troubleshoot": 22}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 8, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx.ext.intersphinx": 1, "sphinx.ext.viewcode": 1, "sphinx": 57}, "alltitles": {"Copyright and License": [[7, "copyright-and-license"]], "Benchmarking": [[2, "benchmarking"]], "speedtest": [[2, "speedtest"]], "Backup": [[1, "backup"]], "Important details": [[1, "important-details"]], "Backup class": [[1, "backup-class"]], "Blob Input/Output": [[3, "blob-input-output"]], "zeroblob class": [[3, "zeroblob-class"]], "Blob class": [[3, "blob-class"]], "Building": [[4, "building"]], "setup.py": [[4, "setup-py"]], "Additional setup.py flags": [[4, "additional-setup-py-flags"]], "fetch": [[4, "fetch"]], "build/build_ext": [[4, "build-build-ext"]], "Matching APSW and SQLite options": [[4, "matching-apsw-and-sqlite-options"]], "Finding SQLite 3": [[4, "finding-sqlite-3"]], "Recommended": [[4, "recommended"]], "Source distribution (advanced)": [[4, "source-distribution-advanced"]], "Testing": [[4, "testing"]], "Cursors (executing SQL)": [[8, "cursors-executing-sql"]], "Cursor class": [[8, "cursor-class"]], "DBAPI notes": [[9, "dbapi-notes"]], "Module Interface": [[9, "module-interface"]], "Connection Objects": [[9, "connection-objects"]], "Cursor Objects": [[9, "cursor-objects"]], "Type objects": [[9, "type-objects"]], "Optional DB API Extensions": [[9, "optional-db-api-extensions"]], "Download": [[10, "download"]], "PyPI/pip": [[10, "pypi-pip"]], "Source": [[10, "source"]], "Verifying your download": [[10, "verifying-your-download"]], "Source code control": [[10, "source-code-control"]], "Example/Tour": [[11, "example-tour"]], "Checking APSW and SQLite versions": [[11, "checking-apsw-and-sqlite-versions"]], "Opening the database": [[11, "opening-the-database"]], "Executing SQL": [[11, "executing-sql"]], "Why you use bindings to provide values": [[11, "why-you-use-bindings-to-provide-values"]], "Bindings (sequence)": [[11, "bindings-sequence"]], "Bindings (dict)": [[11, "bindings-dict"]], "Using different types": [[11, "using-different-types"]], "Transactions": [[11, "transactions"], [19, "transactions"]], "executemany": [[11, "executemany"]], "Tracing execution": [[11, "tracing-execution"]], "Tracing returned rows": [[11, "tracing-returned-rows"]], "Defining your own functions": [[11, "defining-your-own-functions"]], "Defining aggregate functions": [[11, "defining-aggregate-functions"]], "Defining collations (sorting)": [[11, "defining-collations-sorting"]], "Accessing results by column name": [[11, "accessing-results-by-column-name"]], "Type conversion into/out of database": [[11, "type-conversion-into-out-of-database"]], "Query details": [[11, "query-details"]], "Blob I/O": [[11, "blob-i-o"]], "Authorizer (control what SQL can do)": [[11, "authorizer-control-what-sql-can-do"]], "Progress handler": [[11, "progress-handler"]], "Commit hook": [[11, "commit-hook"]], "Update hook": [[11, "update-hook"]], "Virtual tables": [[11, "virtual-tables"]], "VFS - Virtual File System": [[11, "vfs-virtual-file-system"]], "Limits": [[11, "limits"]], "Backup an open database": [[11, "backup-an-open-database"]], "Shell": [[11, "shell"], [18, "shell"]], "Statistics": [[11, "statistics"]], "Cleanup": [[11, "cleanup"]], "Exceptions": [[12, "exceptions"]], "APSW specific exceptions": [[12, "apsw-specific-exceptions"]], "SQLite Exceptions": [[12, "sqlite-exceptions"]], "General Errors": [[12, "general-errors"]], "Internal Errors": [[12, "internal-errors"]], "Permissions Etc": [[12, "permissions-etc"]], "Abort/Busy Etc": [[12, "abort-busy-etc"]], "Memory/Disk": [[12, "memory-disk"]], "Augmented stack traces": [[12, "augmented-stack-traces"]], "Execution and tracing": [[13, "execution-and-tracing"]], "Execution model": [[13, "execution-model"]], "Multi-threading and re-entrancy": [[13, "multi-threading-and-re-entrancy"]], "64 bit hosts": [[13, "bit-hosts"]], "Statement Cache": [[13, "statement-cache"]], "Tracing": [[13, "tracing"]], "Execution Tracer": [[13, "execution-tracer"]], "Row Tracer": [[13, "row-tracer"]], "APSW Trace": [[13, "apsw-trace"]], "Extensions": [[15, "extensions"]], "FTS3/4/5": [[15, "fts3-4-5"]], "ICU": [[15, "icu"]], "JSON1": [[15, "json1"]], "RBU": [[15, "rbu"]], "RTree": [[15, "rtree"]], "APSW documentation": [[16, "apsw-documentation"]], "sqlite3 module differences": [[17, "sqlite3-module-differences"]], "What APSW does better": [[17, "what-apsw-does-better"]], "What sqlite3 does better": [[17, "what-sqlite3-does-better"]], "Tips": [[19, "tips"]], "About Python, APSW, and SQLite versions": [[19, "about-python-apsw-and-sqlite-versions"]], "SQLite is different": [[19, "sqlite-is-different"]], "Cursors": [[19, "cursors"]], "Bindings": [[19, "bindings"]], "Diagnostics": [[19, "diagnostics"]], "Managing and updating your schema": [[19, "managing-and-updating-your-schema"]], "Parsing SQL": [[19, "parsing-sql"]], "Unexpected behaviour": [[19, "unexpected-behaviour"]], "Customizing Connections": [[19, "customizing-connections"]], "Customizing Cursors": [[19, "customizing-cursors"]], "Busy handling": [[19, "busy-handling"]], "Database schema": [[19, "database-schema"]], "Shared Cache Mode": [[19, "shared-cache-mode"]], "Write Ahead Logging": [[19, "write-ahead-logging"]], "Types": [[20, "types"]], "Mapping": [[20, "mapping"]], "Unicode": [[20, "unicode"], [18, "unicode"]], "Virtual File System (VFS)": [[21, "virtual-file-system-vfs"]], "Exceptions and errors": [[21, "exceptions-and-errors"]], "VFS class": [[21, "vfs-class"]], "VFSFile class": [[21, "vfsfile-class"]], "URIFilename class": [[21, "urifilename-class"]], "Virtual Tables": [[22, "virtual-tables"]], "VTModule class": [[22, "vtmodule-class"]], "VTTable class": [[22, "vttable-class"]], "VTCursor class": [[22, "vtcursor-class"]], "Troubleshooting virtual tables": [[22, "troubleshooting-virtual-tables"]], "Change History": [[5, "change-history"]], "3.40.0.0": [[5, "id1"]], "3.39.4.0": [[5, "id2"]], "3.39.3.0": [[5, "id3"]], "3.39.2.1": [[5, "id4"]], "3.39.2.0": [[5, "id5"]], "3.38.5-r1": [[5, "r1"]], "3.38.1-r1": [[5, "id6"]], "3.37.0-r1": [[5, "id7"]], "3.36.0-r1": [[5, "id8"]], "3.35.4-r1": [[5, "id9"]], "3.34.0-r1": [[5, "id10"]], "3.33.0-r1": [[5, "id11"]], "3.32.2-r1": [[5, "id12"]], "3.31.1-r1": [[5, "id13"]], "3.30.1-r1": [[5, "id14"]], "3.29.0-r1": [[5, "id15"]], "3.28.0-r1": [[5, "id16"]], "3.27.2-r1": [[5, "id17"]], "3.26.0-r1": [[5, "id18"]], "3.25.2-r1": [[5, "id19"]], "3.24.0-r1": [[5, "id20"]], "3.23.1-r1": [[5, "id21"]], "3.22.0-r1": [[5, "id22"]], "3.21.0-r1": [[5, "id23"]], "3.20.1-r1": [[5, "id24"]], "3.19.3-r1": [[5, "id25"]], "3.18.0-r1": [[5, "id26"]], "3.17.0-r1": [[5, "id27"]], "3.16.2-r1": [[5, "id28"]], "3.15.2-r1": [[5, "id29"]], "3.15.1-r1": [[5, "id30"]], "3.15.0-r1": [[5, "id31"]], "3.14.1-r1": [[5, "id32"]], "3.13.0-r1": [[5, "id33"]], "3.12.2-r1": [[5, "id34"]], "3.11.1-r1": [[5, "id35"]], "3.11.0-r1": [[5, "id36"]], "3.9.2-r1": [[5, "id37"]], "3.8.11.1-r1": [[5, "id38"]], "3.8.10.1-r1": [[5, "id39"]], "3.8.9-r1": [[5, "id40"]], "3.8.8.2-r1": [[5, "id41"]], "3.8.8.1-r1": [[5, "id42"]], "3.8.7.3-r1": [[5, "id43"]], "3.8.7.2-r1": [[5, "id44"]], "3.8.7.1-r1": [[5, "id45"]], "3.8.6-r1": [[5, "id46"]], "3.8.5-r1": [[5, "id47"]], "3.8.4.3-r1": [[5, "id48"]], "3.8.4.2-r1": [[5, "id49"]], "3.8.4.1-r1": [[5, "id50"]], "3.8.3.1-r1": [[5, "id51"]], "3.8.3-r1": [[5, "id52"]], "3.8.2-r1": [[5, "id53"]], "3.8.1-r1": [[5, "id54"]], "3.8.0.2-r1": [[5, "id55"]], "3.8.0.1-r1": [[5, "id56"]], "3.8.0-r2": [[5, "r2"]], "3.8.0-r1": [[5, "id57"]], "3.7.17-r1": [[5, "id58"]], "3.7.16.2-r1": [[5, "id59"]], "3.7.16.1-r1": [[5, "id60"]], "3.7.16-r1": [[5, "id61"]], "3.7.15.2-r1": [[5, "id62"]], "3.7.15.1-r1": [[5, "id63"]], "3.7.15-r1": [[5, "id64"]], "3.7.14.1-r1": [[5, "id65"]], "3.7.14-r2": [[5, "id66"]], "3.7.14-r1": [[5, "id67"]], "3.7.13-r1": [[5, "id68"]], "3.7.12.1-r1": [[5, "id69"]], "3.7.12-r1": [[5, "id70"]], "3.7.11-r1": [[5, "id71"]], "3.7.10-r1": [[5, "id72"]], "3.7.9-r1": [[5, "id73"]], "3.7.8-r1": [[5, "id74"]], "3.7.7.1-r1": [[5, "id75"]], "3.7.6.3-r1": [[5, "id76"]], "3.7.6.2-r1": [[5, "id77"]], "3.7.5-r1": [[5, "id78"]], "3.7.4-r1": [[5, "id79"]], "3.7.3-r1": [[5, "id80"]], "3.7.2-r1": [[5, "id81"]], "3.7.1-r1": [[5, "id82"]], "3.7.0.1-r1": [[5, "id83"]], "3.7.0-r1": [[5, "id84"]], "3.6.23.1-r1": [[5, "id85"]], "3.6.23-r1": [[5, "id86"]], "3.6.22-r1": [[5, "id87"]], "3.6.21-r1": [[5, "id88"]], "3.6.20-r1": [[5, "id89"]], "3.6.19-r1": [[5, "id90"]], "3.6.18-r1": [[5, "id91"]], "3.6.17-r1": [[5, "id92"]], "3.6.16-r1": [[5, "id93"]], "3.6.15-r1": [[5, "id94"]], "3.6.14.2-r1": [[5, "id95"]], "3.6.14.1-r1": [[5, "id96"]], "3.6.13-r1": [[5, "id97"]], "3.6.11-r1": [[5, "id98"]], "3.6.10-r1": [[5, "id99"]], "3.6.6.2-r1": [[5, "id100"]], "3.6.5-r1": [[5, "id101"]], "3.6.3-r1": [[5, "id102"]], "3.5.9-r2": [[5, "id103"]], "3.5.9-r1": [[5, "id104"]], "3.3.13-r1": [[5, "id105"]], "3.3.10-r1": [[5, "id106"]], "3.3.9-r1": [[5, "id107"]], "3.3.8-r1": [[5, "id109"]], "3.3.7-r1": [[5, "id110"]], "3.3.5-r1": [[5, "id111"]], "3.2.7-r1": [[5, "id112"]], "3.2.2-r1": [[5, "id113"]], "3.2.1-r1": [[5, "id114"]], "3.1.3-r1": [[5, "id115"]], "3.0.8-r3": [[5, "r3"]], "3.0.8-r2": [[5, "id116"]], "3.0.8-r1": [[5, "id117"]], "APSW Module": [[0, "apsw-module"]], "Type Annotations": [[0, "type-annotations"]], "API Reference": [[0, "api-reference"], [14, "module-apsw.ext"]], "SQLite constants": [[0, "sqlite-constants"]], "Connections to a database": [[6, "connections-to-a-database"]], "Connection class": [[6, "connection-class"]], "Various interesting and useful bits of functionality": [[14, "various-interesting-and-useful-bits-of-functionality"]], "Accessing result rows by column name": [[14, "accessing-result-rows-by-column-name"]], "Converting types into and out of SQLite": [[14, "converting-types-into-and-out-of-sqlite"]], "Detailed Query Information": [[14, "detailed-query-information"]], "Notes": [[18, "notes"]], "Commands": [[18, "commands"]], "Command Line Usage": [[18, "command-line-usage"]], "Example": [[18, "example"]], "Shell class": [[18, "shell-class"]]}, "indexentries": {"aggregatefactory (class in apsw)": [[0, "apsw.AggregateFactory"]], "aggregatefinal (class in apsw)": [[0, "apsw.AggregateFinal"]], "aggregatestep (class in apsw)": [[0, "apsw.AggregateStep"]], "aggregatet (class in apsw)": [[0, "apsw.AggregateT"]], "authorizer (class in apsw)": [[0, "apsw.Authorizer"]], "bindings (class in apsw)": [[0, "apsw.Bindings"]], "commithook (class in apsw)": [[0, "apsw.CommitHook"]], "exectracer (class in apsw)": [[0, "apsw.ExecTracer"]], "rowtracer (class in apsw)": [[0, "apsw.RowTracer"]], "sqlite_version_number (in module apsw)": [[0, "apsw.SQLITE_VERSION_NUMBER"]], "sqlitevalue (class in apsw)": [[0, "apsw.SQLiteValue"]], "sqlitevalues (class in apsw)": [[0, "apsw.SQLiteValues"]], "scalarprotocol (class in apsw)": [[0, "apsw.ScalarProtocol"]], "apsw": [[0, "module-apsw"]], "apswversion() (in module apsw)": [[0, "apsw.apswversion"]], "compile_options (in module apsw)": [[0, "apsw.compile_options"]], "complete() (in module apsw)": [[0, "apsw.complete"]], "config() (in module apsw)": [[0, "apsw.config"]], "connection_hooks (in module apsw)": [[0, "apsw.connection_hooks"]], "enablesharedcache() (in module apsw)": [[0, "apsw.enablesharedcache"]], "exceptionfor() (in module apsw)": [[0, "apsw.exceptionfor"]], "fork_checker() (in module apsw)": [[0, "apsw.fork_checker"]], "format_sql_value() (in module apsw)": [[0, "apsw.format_sql_value"]], "initialize() (in module apsw)": [[0, "apsw.initialize"]], "keywords (in module apsw)": [[0, "apsw.keywords"]], "log() (in module apsw)": [[0, "apsw.log"]], "mapping_access (in module apsw)": [[0, "apsw.mapping_access"]], "mapping_authorizer_function (in module apsw)": [[0, "apsw.mapping_authorizer_function"]], "mapping_authorizer_return (in module apsw)": [[0, "apsw.mapping_authorizer_return"]], "mapping_bestindex_constraints (in module apsw)": [[0, "apsw.mapping_bestindex_constraints"]], "mapping_config (in module apsw)": [[0, "apsw.mapping_config"]], "mapping_conflict_resolution_modes (in module apsw)": [[0, "apsw.mapping_conflict_resolution_modes"]], "mapping_db_config (in module apsw)": [[0, "apsw.mapping_db_config"]], "mapping_db_status (in module apsw)": [[0, "apsw.mapping_db_status"]], "mapping_device_characteristics (in module apsw)": [[0, "apsw.mapping_device_characteristics"]], "mapping_extended_result_codes (in module apsw)": [[0, "apsw.mapping_extended_result_codes"]], "mapping_file_control (in module apsw)": [[0, "apsw.mapping_file_control"]], "mapping_limits (in module apsw)": [[0, "apsw.mapping_limits"]], "mapping_locking_level (in module apsw)": [[0, "apsw.mapping_locking_level"]], "mapping_open_flags (in module apsw)": [[0, "apsw.mapping_open_flags"]], "mapping_prepare_flags (in module apsw)": [[0, "apsw.mapping_prepare_flags"]], "mapping_result_codes (in module apsw)": [[0, "apsw.mapping_result_codes"]], "mapping_status (in module apsw)": [[0, "apsw.mapping_status"]], "mapping_sync (in module apsw)": [[0, "apsw.mapping_sync"]], "mapping_txn_state (in module apsw)": [[0, "apsw.mapping_txn_state"]], "mapping_virtual_table_configuration_options (in module apsw)": [[0, "apsw.mapping_virtual_table_configuration_options"]], "mapping_virtual_table_scan_flags (in module apsw)": [[0, "apsw.mapping_virtual_table_scan_flags"]], "mapping_wal_checkpoint (in module apsw)": [[0, "apsw.mapping_wal_checkpoint"]], "mapping_xshmlock_flags (in module apsw)": [[0, "apsw.mapping_xshmlock_flags"]], "memoryhighwater() (in module apsw)": [[0, "apsw.memoryhighwater"]], "memoryused() (in module apsw)": [[0, "apsw.memoryused"]], "module": [[0, "module-apsw"], [14, "module-apsw.ext"], [18, "module-apsw.shell"]], "randomness() (in module apsw)": [[0, "apsw.randomness"]], "releasememory() (in module apsw)": [[0, "apsw.releasememory"]], "shutdown() (in module apsw)": [[0, "apsw.shutdown"]], "softheaplimit() (in module apsw)": [[0, "apsw.softheaplimit"]], "sqlite3_compileoption_get": [[0, "index-0"]], "sqlite3_complete": [[0, "index-1"]], "sqlite3_config": [[0, "index-2"]], "sqlite3_enable_shared_cache": [[0, "index-3"]], "sqlite3_initialize": [[0, "index-4"]], "sqlite3_keyword_count": [[0, "index-5"]], "sqlite3_keyword_name": [[0, "index-5"]], "sqlite3_libversion": [[0, "index-14"]], "sqlite3_log": [[0, "index-6"]], "sqlite3_memory_highwater": [[0, "index-7"]], "sqlite3_memory_used": [[0, "index-8"]], "sqlite3_randomness": [[0, "index-9"]], "sqlite3_release_memory": [[0, "index-10"]], "sqlite3_shutdown": [[0, "index-11"]], "sqlite3_soft_heap_limit64": [[0, "index-12"]], "sqlite3_sourceid": [[0, "index-13"]], "sqlite3_sourceid() (in module apsw)": [[0, "apsw.sqlite3_sourceid"]], "sqlite3_status64": [[0, "index-15"]], "sqlitelibversion() (in module apsw)": [[0, "apsw.sqlitelibversion"]], "status() (in module apsw)": [[0, "apsw.status"]], "using_amalgamation (in module apsw)": [[0, "apsw.using_amalgamation"]], "vfsnames() (in module apsw)": [[0, "apsw.vfsnames"]], "backup (class in apsw)": [[1, "apsw.Backup"]], "pep 0343": [[1, "index-0"], [3, "index-0"], [5, "index-0"], [6, "index-1"]], "python enhancement proposals": [[1, "index-0"], [3, "index-0"], [4, "index-0"], [4, "index-1"], [5, "index-0"], [6, "index-1"], [9, "index-0"], [16, "index-0"]], "__enter__() (backup method)": [[1, "apsw.Backup.__enter__"]], "__exit__() (backup method)": [[1, "apsw.Backup.__exit__"]], "close() (backup method)": [[1, "apsw.Backup.close"]], "done (backup attribute)": [[1, "apsw.Backup.done"]], "finish() (backup method)": [[1, "apsw.Backup.finish"]], "pagecount (backup attribute)": [[1, "apsw.Backup.pagecount"]], "remaining (backup attribute)": [[1, "apsw.Backup.remaining"]], "sqlite3_backup_finish": [[1, "index-1"]], "sqlite3_backup_pagecount": [[1, "index-2"]], "sqlite3_backup_remaining": [[1, "index-3"]], "sqlite3_backup_step": [[1, "index-4"]], "step() (backup method)": [[1, "apsw.Backup.step"]], "blob (class in apsw)": [[3, "apsw.Blob"]], "__enter__() (blob method)": [[3, "apsw.Blob.__enter__"]], "__exit__() (blob method)": [[3, "apsw.Blob.__exit__"]], "close() (blob method)": [[3, "apsw.Blob.close"]], "length() (blob method)": [[3, "apsw.Blob.length"]], "length() (zeroblob method)": [[3, "apsw.zeroblob.length"]], "read() (blob method)": [[3, "apsw.Blob.read"]], "readinto() (blob method)": [[3, "apsw.Blob.readinto"]], "reopen() (blob method)": [[3, "apsw.Blob.reopen"]], "seek() (blob method)": [[3, "apsw.Blob.seek"]], "sqlite3_blob_bytes": [[3, "index-2"]], "sqlite3_blob_close": [[3, "index-1"]], "sqlite3_blob_read": [[3, "index-3"], [3, "index-4"]], "sqlite3_blob_reopen": [[3, "index-5"]], "sqlite3_blob_write": [[3, "index-6"]], "tell() (blob method)": [[3, "apsw.Blob.tell"]], "write() (blob method)": [[3, "apsw.Blob.write"]], "zeroblob (class in apsw)": [[3, "apsw.zeroblob"]], "pep 370": [[4, "index-0"], [4, "index-1"]], "connection (class in apsw)": [[6, "apsw.Connection"]], "__enter__() (connection method)": [[6, "apsw.Connection.__enter__"]], "__exit__() (connection method)": [[6, "apsw.Connection.__exit__"]], "authorizer (connection attribute)": [[6, "apsw.Connection.authorizer"]], "autovacuum_pages() (connection method)": [[6, "apsw.Connection.autovacuum_pages"]], "backup() (connection method)": [[6, "apsw.Connection.backup"]], "blobopen() (connection method)": [[6, "apsw.Connection.blobopen"]], "cache_stats() (connection method)": [[6, "apsw.Connection.cache_stats"]], "changes() (connection method)": [[6, "apsw.Connection.changes"]], "close() (connection method)": [[6, "apsw.Connection.close"]], "collationneeded() (connection method)": [[6, "apsw.Connection.collationneeded"]], "config() (connection method)": [[6, "apsw.Connection.config"]], "createaggregatefunction() (connection method)": [[6, "apsw.Connection.createaggregatefunction"]], "createcollation() (connection method)": [[6, "apsw.Connection.createcollation"]], "createmodule() (connection method)": [[6, "apsw.Connection.createmodule"]], "createscalarfunction() (connection method)": [[6, "apsw.Connection.createscalarfunction"]], "cursor() (connection method)": [[6, "apsw.Connection.cursor"]], "cursor_factory (connection attribute)": [[6, "apsw.Connection.cursor_factory"]], "db_filename() (connection method)": [[6, "apsw.Connection.db_filename"]], "db_names() (connection method)": [[6, "apsw.Connection.db_names"]], "deserialize() (connection method)": [[6, "apsw.Connection.deserialize"]], "enableloadextension() (connection method)": [[6, "apsw.Connection.enableloadextension"]], "exectrace (connection attribute)": [[6, "apsw.Connection.exectrace"]], "execute() (connection method)": [[6, "apsw.Connection.execute"]], "executemany() (connection method)": [[6, "apsw.Connection.executemany"]], "filecontrol() (connection method)": [[6, "apsw.Connection.filecontrol"]], "filename (connection attribute)": [[6, "apsw.Connection.filename"]], "getautocommit() (connection method)": [[6, "apsw.Connection.getautocommit"]], "getexectrace() (connection method)": [[6, "apsw.Connection.getexectrace"]], "getrowtrace() (connection method)": [[6, "apsw.Connection.getrowtrace"]], "in_transaction (connection attribute)": [[6, "apsw.Connection.in_transaction"]], "interrupt() (connection method)": [[6, "apsw.Connection.interrupt"]], "last_insert_rowid() (connection method)": [[6, "apsw.Connection.last_insert_rowid"]], "limit() (connection method)": [[6, "apsw.Connection.limit"]], "loadextension() (connection method)": [[6, "apsw.Connection.loadextension"]], "open_flags (connection attribute)": [[6, "apsw.Connection.open_flags"]], "open_vfs (connection attribute)": [[6, "apsw.Connection.open_vfs"]], "overloadfunction() (connection method)": [[6, "apsw.Connection.overloadfunction"]], "readonly() (connection method)": [[6, "apsw.Connection.readonly"]], "rowtrace (connection attribute)": [[6, "apsw.Connection.rowtrace"]], "serialize() (connection method)": [[6, "apsw.Connection.serialize"]], "set_last_insert_rowid() (connection method)": [[6, "apsw.Connection.set_last_insert_rowid"]], "setauthorizer() (connection method)": [[6, "apsw.Connection.setauthorizer"]], "setbusyhandler() (connection method)": [[6, "apsw.Connection.setbusyhandler"]], "setbusytimeout() (connection method)": [[6, "apsw.Connection.setbusytimeout"]], "setcommithook() (connection method)": [[6, "apsw.Connection.setcommithook"]], "setexectrace() (connection method)": [[6, "apsw.Connection.setexectrace"]], "setprofile() (connection method)": [[6, "apsw.Connection.setprofile"]], "setprogresshandler() (connection method)": [[6, "apsw.Connection.setprogresshandler"]], "setrollbackhook() (connection method)": [[6, "apsw.Connection.setrollbackhook"]], "setrowtrace() (connection method)": [[6, "apsw.Connection.setrowtrace"]], "setupdatehook() (connection method)": [[6, "apsw.Connection.setupdatehook"]], "setwalhook() (connection method)": [[6, "apsw.Connection.setwalhook"]], "sqlite3_autovacuum_pages": [[6, "index-3"]], "sqlite3_backup_init": [[6, "index-4"]], "sqlite3_blob_open": [[6, "index-5"]], "sqlite3_busy_handler": [[6, "index-30"]], "sqlite3_busy_timeout": [[6, "index-31"]], "sqlite3_changes64": [[6, "index-6"]], "sqlite3_close": [[6, "index-7"]], "sqlite3_collation_needed": [[6, "index-8"]], "sqlite3_commit_hook": [[6, "index-32"]], "sqlite3_create_collation_v2": [[6, "index-11"]], "sqlite3_create_function_v2": [[6, "index-10"], [6, "index-13"]], "sqlite3_create_module_v2": [[6, "index-12"]], "sqlite3_db_config": [[6, "index-9"]], "sqlite3_db_filename": [[6, "index-14"], [6, "index-19"]], "sqlite3_db_name": [[6, "index-15"]], "sqlite3_db_readonly": [[6, "index-27"]], "sqlite3_db_status": [[6, "index-38"]], "sqlite3_deserialize": [[6, "index-16"]], "sqlite3_enable_load_extension": [[6, "index-17"]], "sqlite3_file_control": [[6, "index-18"]], "sqlite3_get_autocommit": [[6, "index-20"], [6, "index-21"]], "sqlite3_interrupt": [[6, "index-22"]], "sqlite3_last_insert_rowid": [[6, "index-23"]], "sqlite3_limit": [[6, "index-24"]], "sqlite3_load_extension": [[6, "index-25"]], "sqlite3_open_v2": [[6, "index-0"]], "sqlite3_overload_function": [[6, "index-26"]], "sqlite3_profile": [[6, "index-33"]], "sqlite3_progress_handler": [[6, "index-34"]], "sqlite3_rollback_hook": [[6, "index-35"]], "sqlite3_serialize": [[6, "index-28"]], "sqlite3_set_authorizer": [[6, "index-2"]], "sqlite3_set_last_insert_rowid": [[6, "index-29"]], "sqlite3_total_changes64": [[6, "index-39"]], "sqlite3_txn_state": [[6, "index-40"]], "sqlite3_update_hook": [[6, "index-36"]], "sqlite3_wal_autocheckpoint": [[6, "index-41"]], "sqlite3_wal_checkpoint_v2": [[6, "index-42"]], "sqlite3_wal_hook": [[6, "index-37"]], "sqlite3pointer() (connection method)": [[6, "apsw.Connection.sqlite3pointer"]], "status() (connection method)": [[6, "apsw.Connection.status"]], "totalchanges() (connection method)": [[6, "apsw.Connection.totalchanges"]], "txn_state() (connection method)": [[6, "apsw.Connection.txn_state"]], "wal_autocheckpoint() (connection method)": [[6, "apsw.Connection.wal_autocheckpoint"]], "wal_checkpoint() (connection method)": [[6, "apsw.Connection.wal_checkpoint"]], "cursor (class in apsw)": [[8, "apsw.Cursor"]], "__iter__() (cursor method)": [[8, "apsw.Cursor.__iter__"]], "__next__() (cursor method)": [[8, "apsw.Cursor.__next__"]], "close() (cursor method)": [[8, "apsw.Cursor.close"]], "connection (cursor attribute)": [[8, "apsw.Cursor.connection"]], "description (cursor attribute)": [[8, "apsw.Cursor.description"]], "description_full (cursor attribute)": [[8, "apsw.Cursor.description_full"]], "exectrace (cursor attribute)": [[8, "apsw.Cursor.exectrace"]], "execute() (cursor method)": [[8, "apsw.Cursor.execute"]], "executemany() (cursor method)": [[8, "apsw.Cursor.executemany"]], "expanded_sql (cursor attribute)": [[8, "apsw.Cursor.expanded_sql"]], "fetchall() (cursor method)": [[8, "apsw.Cursor.fetchall"]], "fetchone() (cursor method)": [[8, "apsw.Cursor.fetchone"]], "getconnection() (cursor method)": [[8, "apsw.Cursor.getconnection"]], "getdescription() (cursor method)": [[8, "apsw.Cursor.getdescription"]], "getexectrace() (cursor method)": [[8, "apsw.Cursor.getexectrace"]], "getrowtrace() (cursor method)": [[8, "apsw.Cursor.getrowtrace"]], "is_explain (cursor attribute)": [[8, "apsw.Cursor.is_explain"]], "is_readonly (cursor attribute)": [[8, "apsw.Cursor.is_readonly"]], "rowtrace (cursor attribute)": [[8, "apsw.Cursor.rowtrace"]], "setexectrace() (cursor method)": [[8, "apsw.Cursor.setexectrace"]], "setrowtrace() (cursor method)": [[8, "apsw.Cursor.setrowtrace"]], "sqlite3_bind_blob": [[8, "index-1"]], "sqlite3_bind_double": [[8, "index-1"]], "sqlite3_bind_int64": [[8, "index-1"]], "sqlite3_bind_null": [[8, "index-1"]], "sqlite3_bind_text": [[8, "index-1"]], "sqlite3_bind_zeroblob": [[8, "index-1"]], "sqlite3_column_database_name": [[8, "index-0"]], "sqlite3_column_decltype": [[8, "index-0"], [8, "index-3"]], "sqlite3_column_name": [[8, "index-0"], [8, "index-3"]], "sqlite3_column_origin_name": [[8, "index-0"]], "sqlite3_column_table_name": [[8, "index-0"]], "sqlite3_expanded_sql": [[8, "index-2"]], "sqlite3_prepare_v3": [[8, "index-1"]], "sqlite3_step": [[8, "index-1"]], "sqlite3_stmt_isexplain": [[8, "index-4"]], "sqlite3_stmt_readonly": [[8, "index-5"]], "pep 249": [[9, "index-0"], [16, "index-0"]], "accessing results by column name (example code)": [[11, "index-14"]], "authorizer (control what sql can do) (example code)": [[11, "index-18"]], "backup an open database (example code)": [[11, "index-25"]], "bindings (dict) (example code)": [[11, "index-5"]], "bindings (sequence) (example code)": [[11, "index-4"]], "blob i/o (example code)": [[11, "index-17"]], "checking apsw and sqlite versions (example code)": [[11, "index-0"]], "cleanup (example code)": [[11, "index-28"]], "commit hook (example code)": [[11, "index-20"]], "defining aggregate functions (example code)": [[11, "index-12"]], "defining collations (sorting) (example code)": [[11, "index-13"]], "defining your own functions (example code)": [[11, "index-11"]], "executing sql (example code)": [[11, "index-2"]], "limits (example code)": [[11, "index-24"]], "opening the database (example code)": [[11, "index-1"]], "progress handler (example code)": [[11, "index-19"]], "query details (example code)": [[11, "index-16"]], "shell (example code)": [[11, "index-26"]], "statistics (example code)": [[11, "index-27"]], "tracing execution (example code)": [[11, "index-9"]], "tracing returned rows (example code)": [[11, "index-10"]], "transactions (example code)": [[11, "index-7"]], "type conversion into/out of database (example code)": [[11, "index-15"]], "update hook (example code)": [[11, "index-21"]], "using different types (example code)": [[11, "index-6"]], "vfs - virtual file system (example code)": [[11, "index-23"]], "virtual tables (example code)": [[11, "index-22"]], "why you use bindings to provide values (example code)": [[11, "index-3"]], "executemany (example code)": [[11, "index-8"]], "aborterror": [[12, "apsw.AbortError"]], "autherror": [[12, "apsw.AuthError"]], "bindingserror": [[12, "apsw.BindingsError"]], "busyerror": [[12, "apsw.BusyError"]], "cantopenerror": [[12, "apsw.CantOpenError"]], "connectionclosederror": [[12, "apsw.ConnectionClosedError"]], "connectionnotclosederror": [[12, "apsw.ConnectionNotClosedError"]], "constrainterror": [[12, "apsw.ConstraintError"]], "corrupterror": [[12, "apsw.CorruptError"]], "cursorclosederror": [[12, "apsw.CursorClosedError"]], "emptyerror": [[12, "apsw.EmptyError"]], "error": [[12, "apsw.Error"]], "exectraceabort": [[12, "apsw.ExecTraceAbort"]], "executioncompleteerror": [[12, "apsw.ExecutionCompleteError"]], "extensionloadingerror": [[12, "apsw.ExtensionLoadingError"]], "forkingviolationerror": [[12, "apsw.ForkingViolationError"]], "formaterror": [[12, "apsw.FormatError"]], "fullerror": [[12, "apsw.FullError"]], "ioerror": [[12, "apsw.IOError"]], "incompleteexecutionerror": [[12, "apsw.IncompleteExecutionError"]], "internalerror": [[12, "apsw.InternalError"]], "interrupterror": [[12, "apsw.InterruptError"]], "lockederror": [[12, "apsw.LockedError"]], "mismatcherror": [[12, "apsw.MismatchError"]], "misuseerror": [[12, "apsw.MisuseError"]], "nolfserror": [[12, "apsw.NoLFSError"]], "nomemerror": [[12, "apsw.NoMemError"]], "notadberror": [[12, "apsw.NotADBError"]], "notfounderror": [[12, "apsw.NotFoundError"]], "permissionserror": [[12, "apsw.PermissionsError"]], "protocolerror": [[12, "apsw.ProtocolError"]], "rangeerror": [[12, "apsw.RangeError"]], "readonlyerror": [[12, "apsw.ReadOnlyError"]], "sqlerror": [[12, "apsw.SQLError"]], "schemachangeerror": [[12, "apsw.SchemaChangeError"]], "threadingviolationerror": [[12, "apsw.ThreadingViolationError"]], "toobigerror": [[12, "apsw.TooBigError"]], "vfsfileclosederror": [[12, "apsw.VFSFileClosedError"]], "vfsnotimplementederror": [[12, "apsw.VFSNotImplementedError"]], "extendedresult (error attribute)": [[12, "apsw.Error.extendedresult"]], "result (error attribute)": [[12, "apsw.Error.result"]], "dataclassrowfactory (class in apsw.ext)": [[14, "apsw.ext.DataClassRowFactory"]], "queryaction (class in apsw.ext)": [[14, "apsw.ext.QueryAction"]], "querydetails (class in apsw.ext)": [[14, "apsw.ext.QueryDetails"]], "queryplan (class in apsw.ext)": [[14, "apsw.ext.QueryPlan"]], "sqlitetypeadapter (class in apsw.ext)": [[14, "apsw.ext.SQLiteTypeAdapter"]], "typesconvertercursorfactory (class in apsw.ext)": [[14, "apsw.ext.TypesConverterCursorFactory"]], "typesconvertercursorfactory.dictadapter (class in apsw.ext)": [[14, "apsw.ext.TypesConverterCursorFactory.DictAdapter"]], "typesconvertercursorfactory.typeconvertercursor (class in apsw.ext)": [[14, "apsw.ext.TypesConverterCursorFactory.TypeConverterCursor"]], "vdbeinstruction (class in apsw.ext)": [[14, "apsw.ext.VDBEInstruction"]], "__call__() (dataclassrowfactory method)": [[14, "apsw.ext.DataClassRowFactory.__call__"]], "__call__() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.__call__"]], "action (queryaction attribute)": [[14, "apsw.ext.QueryAction.action"]], "action_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.action_name"]], "actions (querydetails attribute)": [[14, "apsw.ext.QueryDetails.actions"]], "adapt_value() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.adapt_value"]], "addr (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.addr"]], "apsw.ext": [[14, "module-apsw.ext"]], "bindings (querydetails attribute)": [[14, "apsw.ext.QueryDetails.bindings"]], "column_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.column_name"]], "comment (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.comment"]], "convert_value() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.convert_value"]], "database_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.database_name"]], "description (querydetails attribute)": [[14, "apsw.ext.QueryDetails.description"]], "description_full (querydetails attribute)": [[14, "apsw.ext.QueryDetails.description_full"]], "detail (queryplan attribute)": [[14, "apsw.ext.QueryPlan.detail"]], "execute() (typesconvertercursorfactory.typeconvertercursor method)": [[14, "apsw.ext.TypesConverterCursorFactory.TypeConverterCursor.execute"]], "executemany() (typesconvertercursorfactory.typeconvertercursor method)": [[14, "apsw.ext.TypesConverterCursorFactory.TypeConverterCursor.executemany"]], "expanded_sql (querydetails attribute)": [[14, "apsw.ext.QueryDetails.expanded_sql"]], "explain (querydetails attribute)": [[14, "apsw.ext.QueryDetails.explain"]], "file_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.file_name"]], "first_query (querydetails attribute)": [[14, "apsw.ext.QueryDetails.first_query"]], "function_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.function_name"]], "get_dataclass() (dataclassrowfactory method)": [[14, "apsw.ext.DataClassRowFactory.get_dataclass"]], "get_type() (dataclassrowfactory method)": [[14, "apsw.ext.DataClassRowFactory.get_type"]], "is_explain (querydetails attribute)": [[14, "apsw.ext.QueryDetails.is_explain"]], "is_readonly (querydetails attribute)": [[14, "apsw.ext.QueryDetails.is_readonly"]], "module_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.module_name"]], "opcode (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.opcode"]], "operation (queryaction attribute)": [[14, "apsw.ext.QueryAction.operation"]], "p1 (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.p1"]], "p2 (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.p2"]], "p3 (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.p3"]], "p4 (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.p4"]], "p5 (vdbeinstruction attribute)": [[14, "apsw.ext.VDBEInstruction.p5"]], "pragma_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.pragma_name"]], "pragma_value (queryaction attribute)": [[14, "apsw.ext.QueryAction.pragma_value"]], "query (querydetails attribute)": [[14, "apsw.ext.QueryDetails.query"]], "query_info() (in module apsw.ext)": [[14, "apsw.ext.query_info"]], "query_plan (querydetails attribute)": [[14, "apsw.ext.QueryDetails.query_plan"]], "query_remaining (querydetails attribute)": [[14, "apsw.ext.QueryDetails.query_remaining"]], "register_adapter() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.register_adapter"]], "register_converter() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.register_converter"]], "sub (queryplan attribute)": [[14, "apsw.ext.QueryPlan.sub"]], "table_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.table_name"]], "to_sqlite_value() (sqlitetypeadapter method)": [[14, "apsw.ext.SQLiteTypeAdapter.to_sqlite_value"]], "trigger_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.trigger_name"]], "trigger_or_view (queryaction attribute)": [[14, "apsw.ext.QueryAction.trigger_or_view"]], "view_name (queryaction attribute)": [[14, "apsw.ext.QueryAction.view_name"]], "wrap_bindings() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.wrap_bindings"]], "wrap_sequence_bindings() (typesconvertercursorfactory method)": [[14, "apsw.ext.TypesConverterCursorFactory.wrap_sequence_bindings"]], "shell (class in apsw.shell)": [[18, "apsw.shell.Shell"]], "shell.error": [[18, "apsw.shell.Shell.Error"]], "apsw.shell": [[18, "module-apsw.shell"]], "cmdloop() (shell method)": [[18, "apsw.shell.Shell.cmdloop"]], "complete() (shell method)": [[18, "apsw.shell.Shell.complete"]], "complete_command() (shell method)": [[18, "apsw.shell.Shell.complete_command"]], "complete_sql() (shell method)": [[18, "apsw.shell.Shell.complete_sql"]], "db (shell property)": [[18, "apsw.shell.Shell.db"]], "display_timing() (shell method)": [[18, "apsw.shell.Shell.display_timing"]], "fixup_backslashes() (shell method)": [[18, "apsw.shell.Shell.fixup_backslashes"]], "get_resource_usage() (shell method)": [[18, "apsw.shell.Shell.get_resource_usage"]], "getcompleteline() (shell method)": [[18, "apsw.shell.Shell.getcompleteline"]], "getline() (shell method)": [[18, "apsw.shell.Shell.getline"]], "handle_exception() (shell method)": [[18, "apsw.shell.Shell.handle_exception"]], "handle_interrupt() (shell method)": [[18, "apsw.shell.Shell.handle_interrupt"]], "main() (in module apsw.shell)": [[18, "apsw.shell.main"]], "pop_input() (shell method)": [[18, "apsw.shell.Shell.pop_input"]], "pop_output() (shell method)": [[18, "apsw.shell.Shell.pop_output"]], "process_args() (shell method)": [[18, "apsw.shell.Shell.process_args"]], "process_command() (shell method)": [[18, "apsw.shell.Shell.process_command"]], "process_complete_line() (shell method)": [[18, "apsw.shell.Shell.process_complete_line"]], "process_sql() (shell method)": [[18, "apsw.shell.Shell.process_sql"]], "process_unknown_args() (shell method)": [[18, "apsw.shell.Shell.process_unknown_args"]], "push_input() (shell method)": [[18, "apsw.shell.Shell.push_input"]], "push_output() (shell method)": [[18, "apsw.shell.Shell.push_output"]], "set_encoding() (shell method)": [[18, "apsw.shell.Shell.set_encoding"]], "usage() (shell method)": [[18, "apsw.shell.Shell.usage"]], "write() (shell method)": [[18, "apsw.shell.Shell.write"]], "urifilename (class in apsw)": [[21, "apsw.URIFilename"]], "vfs (class in apsw)": [[21, "apsw.VFS"]], "vfsfile (class in apsw)": [[21, "apsw.VFSFile"]], "excepthook() (vfs method)": [[21, "apsw.VFS.excepthook"]], "excepthook() (vfsfile method)": [[21, "apsw.VFSFile.excepthook"]], "filename() (urifilename method)": [[21, "apsw.URIFilename.filename"]], "sqlite3_uri_boolean": [[21, "index-2"]], "sqlite3_uri_int64": [[21, "index-3"]], "sqlite3_uri_parameter": [[21, "index-4"]], "sqlite3_vfs_find": [[21, "index-0"]], "sqlite3_vfs_register": [[21, "index-0"]], "sqlite3_vfs_unregister": [[21, "index-1"]], "unregister() (vfs method)": [[21, "apsw.VFS.unregister"]], "uri_boolean() (urifilename method)": [[21, "apsw.URIFilename.uri_boolean"]], "uri_int() (urifilename method)": [[21, "apsw.URIFilename.uri_int"]], "uri_parameter() (urifilename method)": [[21, "apsw.URIFilename.uri_parameter"]], "xaccess() (vfs method)": [[21, "apsw.VFS.xAccess"]], "xcheckreservedlock() (vfsfile method)": [[21, "apsw.VFSFile.xCheckReservedLock"]], "xclose() (vfsfile method)": [[21, "apsw.VFSFile.xClose"]], "xcurrenttime() (vfs method)": [[21, "apsw.VFS.xCurrentTime"]], "xdelete() (vfs method)": [[21, "apsw.VFS.xDelete"]], "xdevicecharacteristics() (vfsfile method)": [[21, "apsw.VFSFile.xDeviceCharacteristics"]], "xdlclose() (vfs method)": [[21, "apsw.VFS.xDlClose"]], "xdlerror() (vfs method)": [[21, "apsw.VFS.xDlError"]], "xdlopen() (vfs method)": [[21, "apsw.VFS.xDlOpen"]], "xdlsym() (vfs method)": [[21, "apsw.VFS.xDlSym"]], "xfilecontrol() (vfsfile method)": [[21, "apsw.VFSFile.xFileControl"]], "xfilesize() (vfsfile method)": [[21, "apsw.VFSFile.xFileSize"]], "xfullpathname() (vfs method)": [[21, "apsw.VFS.xFullPathname"]], "xgetlasterror() (vfs method)": [[21, "apsw.VFS.xGetLastError"]], "xgetsystemcall() (vfs method)": [[21, "apsw.VFS.xGetSystemCall"]], "xlock() (vfsfile method)": [[21, "apsw.VFSFile.xLock"]], "xnextsystemcall() (vfs method)": [[21, "apsw.VFS.xNextSystemCall"]], "xopen() (vfs method)": [[21, "apsw.VFS.xOpen"]], "xrandomness() (vfs method)": [[21, "apsw.VFS.xRandomness"]], "xread() (vfsfile method)": [[21, "apsw.VFSFile.xRead"]], "xsectorsize() (vfsfile method)": [[21, "apsw.VFSFile.xSectorSize"]], "xsetsystemcall() (vfs method)": [[21, "apsw.VFS.xSetSystemCall"]], "xsleep() (vfs method)": [[21, "apsw.VFS.xSleep"]], "xsync() (vfsfile method)": [[21, "apsw.VFSFile.xSync"]], "xtruncate() (vfsfile method)": [[21, "apsw.VFSFile.xTruncate"]], "xunlock() (vfsfile method)": [[21, "apsw.VFSFile.xUnlock"]], "xwrite() (vfsfile method)": [[21, "apsw.VFSFile.xWrite"]], "begin() (vttable method)": [[22, "apsw.VTTable.Begin"]], "bestindex() (vttable method)": [[22, "apsw.VTTable.BestIndex"]], "close() (vtcursor method)": [[22, "apsw.VTCursor.Close"]], "column() (vtcursor method)": [[22, "apsw.VTCursor.Column"]], "commit() (vttable method)": [[22, "apsw.VTTable.Commit"]], "connect() (vtmodule method)": [[22, "apsw.VTModule.Connect"]], "create() (vtmodule method)": [[22, "apsw.VTModule.Create"]], "destroy() (vttable method)": [[22, "apsw.VTTable.Destroy"]], "disconnect() (vttable method)": [[22, "apsw.VTTable.Disconnect"]], "eof() (vtcursor method)": [[22, "apsw.VTCursor.Eof"]], "filter() (vtcursor method)": [[22, "apsw.VTCursor.Filter"]], "findfunction() (vttable method)": [[22, "apsw.VTTable.FindFunction"]], "next() (vtcursor method)": [[22, "apsw.VTCursor.Next"]], "open() (vttable method)": [[22, "apsw.VTTable.Open"]], "rename() (vttable method)": [[22, "apsw.VTTable.Rename"]], "rollback() (vttable method)": [[22, "apsw.VTTable.Rollback"]], "rowid() (vtcursor method)": [[22, "apsw.VTCursor.Rowid"]], "sync() (vttable method)": [[22, "apsw.VTTable.Sync"]], "updatechangerow() (vttable method)": [[22, "apsw.VTTable.UpdateChangeRow"]], "updatedeleterow() (vttable method)": [[22, "apsw.VTTable.UpdateDeleteRow"]], "updateinsertrow() (vttable method)": [[22, "apsw.VTTable.UpdateInsertRow"]], "vtcursor (class in apsw)": [[22, "apsw.VTCursor"]], "vtmodule (class in apsw)": [[22, "apsw.VTModule"]], "vttable (class in apsw)": [[22, "apsw.VTTable"]]}})