SQLite

Appendix H. Python Interface Reference

This appendix is a reference for the PySQLite extension, which provides an interface to SQLite that is compliant with the Python Database Specification 2.0.

Before attempting any database connectivity with PySQLite, you must import the sqlite module, using

import sqlite

In this appendix, the commands are shown first, followed by the explanation.

Opening and Closing a Database

cx = sqlite.connect(database, mode=0755, converters={}, autocommit=0,
                    encoding=None, timeout=None, command_logfile=None)

Opens a SQLite connection to database and returns a connection object to cx.

The mode argument is currently ignored but may be used in the future to specify the file mode with which the database file is opened.

The converters ...