./databases/py-sqlite2, SQLite database adapter for Python

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 2.8.3nb1, Package name: py27-sqlite2-2.8.3nb1, Maintainer: pkgsrc-users

PySQLite is a Python interface to the SQLite library,
allowing Python programs to access SQLite databases.

This module wraps sqlite3 by using code not contained in the python

Required to run:

Required to build:

Master sites:

SHA1: 70e6ed5e771b1b584ffe23f93e3eb1ceef44895a
RMD160: ec33a3083d8af35935c879796fce67ac0a9cf93d
Filesize: 78.679 KB

Version history: (Expand)

CVS history: (Expand)

   2018-04-14 09:34:46 by Adam Ciarcinski | Files touched by this commit (681) | Package updated
Log message:
revbump after icu update
   2018-04-04 13:40:34 by Filip Hajny | Files touched by this commit (4) | Package updated
Log message:
databases/py-sqlite2: Update to 2.8.3.

Version 2.8.3

- Fixed bug where cursor.description was an emtpy tuple instead of None for
  non-SELECT statements

Version 2.8.2

- Make sure pysqlite compiles with Visual Studio, which does not support C99
- Switch to sqlite3_open_v2. The flags parameter is now exposed. You can use it
  to modify the behaviour of the opened database connection, for example
  opening a database file in read-only mode or enable URI mode.

Version 2.8.1


- Fixed multiple refcount problems.


- Added versionchanged about changed transaction behaviour wrt DDL statements
  to documentation.
- I was informed by Roger Binns that FTS5 is not stable yet. The amalgamation
  is now built with FTS3 and FTS4 instead.

Version 2.8.0


- No new features, but tons of bugfixes. These mean that things now work that
  didn't before:
- Transactional DDL now works
- You can use SAVEPOINTs now


- Python 2.7.x is now required. If trying to use it with Python 3, print a
  useful error message.  Integrated all fixes from the sqlite3 module in Python


- Completety got rid of statement parsing. We now use SQLite functions to
  determine if a statement modifies the database or not. If a statement
  modifies the database, then we implicitly start a transaction. For backwards
  compatibility reasons, we do NOT implicitly start a transaction if we
  encounter a DDL statement.

  You can, however, now have transactional DDL if you want to:

    cur = con.cursor()
    cur.execute("create table foo(bar)")

  This also means that people can now finally use SAVEPOINTS.

- Use sqlite3_get_autocommit() to determine if we are within a transaction
  instead of trying to be smart.

- Switch to v2 statement API. This simplified the code and will increase


- You can use unicode strings as index for Row objects.


- Fixed a regression: statements should not be reset after a commit.


- Since december 2005, row_factory is a feature of the Connection class
  instead of the Cursor class.
- DEPRECATE converters and adapters.
- DEPRECATE text_factory.
- Remove compatibility workarounds for old Python versions.
- Remove workarounds for old SQLite versions.
- Remove apsw related code.

Version 2.7.0


- The limit functionality of SQLite is now wrapped.


- Instead of fts3, build fts5 extension when using amalgamation.
- use pkg-config for finding SQLite if available
- Removed the download/unpacking of SQLite amalgamation files.


- Use toc.db file from the SQLite web site and a custom script to make sure
  that we have all integer constants mapped to Python.
- Use Travis CI
- Added Trove classifier to make sure Python 3 users do not accidentally
  try to install it.


- Fix for parsing fractional second part of timestamps.
- Fixed bug where when using converters, empty strings ended up as None
  on the Python side.
- SQLite can cope with text with embedded NUL. We can now, too.
- many others
   2017-11-30 17:45:43 by Adam Ciarcinski | Files touched by this commit (654) | Package updated
Log message:
Revbump after textproc/icu update
   2017-09-18 11:53:40 by Maya Rashish | Files touched by this commit (676)
Log message:
revbump for requiring ICU 59.x
   2017-09-04 20:55:10 by Thomas Klausner | Files touched by this commit (40) | Package updated
Log message:
Update some URLs.
   2017-09-04 20:01:05 by Thomas Klausner | Files touched by this commit (192)
Log message:
Comment out dead sites.
   2017-04-22 23:04:05 by Adam Ciarcinski | Files touched by this commit (670) | Package updated
Log message:
Revbump after icu update
   2017-01-01 15:44:09 by Thomas Klausner | Files touched by this commit (577)
Log message:
Add python-3.6 to incompatible versions.