@@ -13,7 +13,7 @@ SQLite for internal data storage. It's also possible to prototype an
1313application using SQLite and then port the code to a larger database such as
1414PostgreSQL or Oracle.
1515
16- pysqlite was written by Gerhard Häring and provides a SQL interface compliant
16+ sqlite3 was written by Gerhard Häring and provides a SQL interface compliant
1717with the DB-API 2.0 specification described by :pep: `249 `.
1818
1919To use the module, you must first create a :class: `Connection ` object that
@@ -50,8 +50,9 @@ is insecure; it makes your program vulnerable to an SQL injection attack.
5050
5151Instead, use the DB-API's parameter substitution. Put ``? `` as a placeholder
5252wherever you want to use a value, and then provide a tuple of values as the
53- second argument to the cursor's :meth: `~Cursor.execute ` method. (Other database modules
54- may use a different placeholder, such as ``%s `` or ``:1 ``.) For example::
53+ second argument to the cursor's :meth: `~Cursor.execute ` method. (Other database
54+ modules may use a different placeholder, such as ``%s `` or ``:1 ``.) For
55+ example::
5556
5657 # Never do this -- insecure!
5758 symbol = 'IBM'
@@ -90,11 +91,12 @@ This example uses the iterator form::
9091.. seealso ::
9192
9293 http://www.pysqlite.org
93- The pysqlite web page.
94+ The pysqlite web page -- sqlite3 is developed externally under the name
95+ "pysqlite".
9496
9597 http://www.sqlite.org
96- The SQLite web page; the documentation describes the syntax and the available
97- data types for the supported SQL dialect.
98+ The SQLite web page; the documentation describes the syntax and the
99+ available data types for the supported SQL dialect.
98100
99101 :pep: `249 ` - Database API Specification 2.0
100102 PEP written by Marc-André Lemburg.
@@ -784,10 +786,10 @@ So if you are within a transaction and issue a command like ``CREATE TABLE
784786... ``, ``VACUUM ``, ``PRAGMA ``, the :mod: `sqlite3 ` module will commit implicitly
785787before executing that command. There are two reasons for doing that. The first
786788is that some of these commands don't work within transactions. The other reason
787- is that pysqlite needs to keep track of the transaction state (if a transaction
789+ is that sqlite3 needs to keep track of the transaction state (if a transaction
788790is active or not).
789791
790- You can control which kind of ``BEGIN `` statements pysqlite implicitly executes
792+ You can control which kind of ``BEGIN `` statements sqlite3 implicitly executes
791793(or none at all) via the *isolation_level * parameter to the :func: `connect `
792794call, or via the :attr: `isolation_level ` property of connections.
793795
@@ -799,8 +801,8 @@ statement, or set it to one of SQLite's supported isolation levels: "DEFERRED",
799801
800802
801803
802- Using pysqlite efficiently
803- --------------------------
804+ Using :mod: ` sqlite3 ` efficiently
805+ --------------------------------
804806
805807
806808Using shortcut methods
0 commit comments