The NetBSD Project

CVS log for pkgsrc/databases/py-sqlite2/distinfo

[BACK] Up to [] / pkgsrc / databases / py-sqlite2

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.14 / (download) - annotate - [select for diffs], Tue Oct 26 10:09:53 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3, pkgsrc-2023Q2-base, pkgsrc-2023Q2, pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4, pkgsrc-2022Q3-base, pkgsrc-2022Q3, pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4, HEAD
Changes since 1.13: +2 -2 lines
Diff to previous 1.13 (colored)

databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched

./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz

Revision 1.13 / (download) - annotate - [select for diffs], Thu Oct 7 13:35:40 2021 UTC (2 years, 1 month ago) by nia
Branch: MAIN
Changes since 1.12: +1 -2 lines
Diff to previous 1.12 (colored)

databases: Remove SHA1 distfile hashes

Revision 1.12 / (download) - annotate - [select for diffs], Wed Apr 4 11:40:34 2018 UTC (5 years, 8 months ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2, pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2, pkgsrc-2020Q1-base, pkgsrc-2020Q1, pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3, pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4, pkgsrc-2018Q3-base, pkgsrc-2018Q3, pkgsrc-2018Q2-base, pkgsrc-2018Q2
Changes since 1.11: +6 -6 lines
Diff to previous 1.11 (colored)

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

Revision 1.11 / (download) - annotate - [select for diffs], Tue Nov 3 01:56:28 2015 UTC (8 years, 1 month ago) by agc
Branch: MAIN
CVS Tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1, pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3, pkgsrc-2017Q2-base, pkgsrc-2017Q2, pkgsrc-2017Q1-base, pkgsrc-2017Q1, pkgsrc-2016Q4-base, pkgsrc-2016Q4, pkgsrc-2016Q3-base, pkgsrc-2016Q3, pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1, pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.10: +2 -1 lines
Diff to previous 1.10 (colored)

Add SHA512 digests for distfiles for databases category

Problems found with existing distfiles:
No changes made to the cstore or mariadb55-client distinfo files.

Otherwise, existing SHA1 digests verified and found to be the same on
the machine holding the existing distfiles (morden).  All existing
SHA1 digests retained for now as an audit trail.

Revision 1.10 / (download) - annotate - [select for diffs], Mon May 16 13:43:07 2011 UTC (12 years, 6 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2, pkgsrc-2014Q1-base, pkgsrc-2014Q1, pkgsrc-2013Q4-base, pkgsrc-2013Q4, pkgsrc-2013Q3-base, pkgsrc-2013Q3, pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2013Q1-base, pkgsrc-2013Q1, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2012Q3-base, pkgsrc-2012Q3, pkgsrc-2012Q2-base, pkgsrc-2012Q2, pkgsrc-2012Q1-base, pkgsrc-2012Q1, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q3-base, pkgsrc-2011Q3, pkgsrc-2011Q2-base, pkgsrc-2011Q2
Changes since 1.9: +4 -4 lines
Diff to previous 1.9 (colored)

Changes 2.6.3:
Bug fixes.

Revision 1.9 / (download) - annotate - [select for diffs], Thu Sep 16 11:31:16 2010 UTC (13 years, 2 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2011Q1-base, pkgsrc-2011Q1, pkgsrc-2010Q4-base, pkgsrc-2010Q4, pkgsrc-2010Q3-base, pkgsrc-2010Q3
Changes since 1.8: +5 -5 lines
Diff to previous 1.8 (colored)

Changes 2.6.0:
No release notes available.

Revision 1.8 / (download) - annotate - [select for diffs], Thu Jul 9 19:02:58 2009 UTC (14 years, 4 months ago) by drochner
Branch: MAIN
CVS Tags: pkgsrc-2010Q2-base, pkgsrc-2010Q2, pkgsrc-2010Q1-base, pkgsrc-2010Q1, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2009Q3-base, pkgsrc-2009Q3
Changes since 1.7: +4 -4 lines
Diff to previous 1.7 (colored)

update to 2.5.5
changes: many bugfixes and compatibility fixes

The 2.5.0 version in pkgsrc was broken:
>>> from pysqlite2 import dbapi2
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/pkg/lib/python2.5/site-packages/pysqlite2/", line 27, in <module>
from pysqlite2._sqlite import *
ImportError: /usr/pkg/lib/python2.5/site-packages/pysqlite2/ Undefined PLT symbol "sqlite3_enable_load_extension" (symnum = 158)

Revision 1.7 / (download) - annotate - [select for diffs], Mon Nov 10 22:36:50 2008 UTC (15 years ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2009Q2-base, pkgsrc-2009Q2, pkgsrc-2009Q1-base, pkgsrc-2009Q1, pkgsrc-2008Q4-base, pkgsrc-2008Q4
Changes since 1.6: +4 -4 lines
Diff to previous 1.6 (colored)

Update to 2.5.0a:
Mostly documentation changes.

Revision 1.6 / (download) - annotate - [select for diffs], Sat Sep 6 16:12:44 2008 UTC (15 years, 3 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2008Q3-base, pkgsrc-2008Q3, cube-native-xorg-base, cube-native-xorg
Changes since 1.5: +4 -4 lines
Diff to previous 1.5 (colored)

Found a new homepage, and an even newer version, including changelogs:

- Windows binaries are now cross-built using mingw on Linux
- import various fixes from Python 2.6 version
- Connection has new method iterdump() that allows you to create a script file
  that can be used to clone a database
- the docs are now built using Sphinx and were imported from Python 2.6's
  sqlite3 module
- Connection.enable_load_extension(enabled) to allow/disallow extension
  loading. Allows you to use fulltext search extension, for example ;-)
- Give the remaining C functions used in multiple .c source files the pysqlite_
- Release GIL during sqlite3_prepare() calls for better concurrency.
- Automatically download the SQLite amalgamation when building statically.

- Made unicode strings for the database parameter in connect() work again
- Removed bad defaults from setup.cfg

- Implemented context managers. pysqlite's connections can now be used as
  context managers with Python 2.5 or later:

        from __future__ import with_statement
        from pysqlite2 import dbapi2 as sqlite

        con = sqlite.connect(":memory:")
        con.execute("create table person (id integer primary key, firstname varchar unique)")

        # Successful, con.commit() is called automatically afterwards
        with con:
            con.execute("insert into person(firstname) values (?)", ("Joe",))

        # con.rollback() is called after the with block finishes with an exception, the
        # exception is still raised and must be catched
            with con:
                con.execute("insert into person(firstname) values (?)", ("Joe",))
        except sqlite.IntegrityError:
            print "couldn't add Joe twice"

- pysqlite connections can now be created from APSW connections. This enables
  users to use APSW functionality in applications using the DB-API from

        from pysqlite2 import dbapi2 as sqlite
        import apsw

        apsw_con = apsw.Connection(":memory:")
        apsw_con.createscalarfunction("times_two", lambda x: 2*x, 1)

        # Create pysqlite connection from APSW connection
        con = sqlite.connect(apsw_con)
        result = con.execute("select times_two(15)").fetchone()[0]
        assert result == 30

  Caveat: This will only work if both pysqlite and APSW are dynamically
  linked against the same SQLite shared library. Otherwise you will
  experience a segfault.

- Fixed shuffled docstrings for fetchXXX methods.

- Workaround for SQLite 3.5.x versions which apparently return NULL for
  "no-operation" statements.

- Disable the test for rollback detection on old SQLite versions. This prevents
  test failures on systems that ship outdated SQLite libraries like MacOS X.

- Implemented set_progress_handler for progress callbacks from SQLite. This is
  particularly useful to update GUIs during long-running queries.  Thanks to
  exarkun for the original patch.

Revision 1.5 / (download) - annotate - [select for diffs], Sat Sep 6 16:03:09 2008 UTC (15 years, 3 months ago) by wiz
Branch: MAIN
Changes since 1.4: +4 -4 lines
Diff to previous 1.4 (colored)

Update to 2.4.1, changes undocumented.

Revision 1.4 / (download) - annotate - [select for diffs], Mon Aug 13 17:37:58 2007 UTC (16 years, 3 months ago) by drochner
Branch: MAIN
CVS Tags: pkgsrc-2008Q2-base, pkgsrc-2008Q2, pkgsrc-2008Q1-base, pkgsrc-2008Q1, pkgsrc-2007Q4-base, pkgsrc-2007Q4, pkgsrc-2007Q3-base, pkgsrc-2007Q3, cwrapper
Changes since 1.3: +4 -4 lines
Diff to previous 1.3 (colored)

update to 2.3.5
-pysqlite is now easy_install-able
-misc bugfixes
-Allow the size parameter for fetchmany() for better DB-API compliance
-Allow a static build of pysqlite using the SQLite amalgamation
-improve concurrency
-Using mappings and sequences as parameters works now
-Performance optimizations

Revision 1.3 / (download) - annotate - [select for diffs], Sat Jan 20 17:28:37 2007 UTC (16 years, 10 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2007Q2-base, pkgsrc-2007Q2, pkgsrc-2007Q1-base, pkgsrc-2007Q1
Changes since 1.2: +4 -4 lines
Diff to previous 1.2 (colored)

Update to 2.3.3:

- self->statement was not checked while fetching data, which could
  lead to crashes if you used the pysqlite API in unusual ways.
  Closing the cursor and continuing to fetch data was enough.

- Converters are stored in a converters dictionary. The converter name
  is uppercased first. The old upper-casing algorithm was wrong and
  was replaced by a simple call to the Python string's upper() method

- Applied patch by Glyph Lefkowitz that fixes the problem with
  subsequent SQLITE_SCHEMA errors.

- Improvement to the row type: rows can now be iterated over and have a keys()
  method. This improves compatibility with both tuple and dict a lot.

- A bugfix for the subsecond resolution in timestamps.

- Corrected the way the flags PARSE_DECLTYPES and PARSE_COLNAMES are
  checked for. Now they work as documented.

- gcc on Linux sucks. It exports all symbols by default in shared
  libraries, so if symbols are not unique it can lead to problems with
  symbol lookup.  pysqlite used to crash under Apache when mod_cache
  was enabled because both modules had the symbol cache_init. I fixed
  this by applying the prefix pysqlite_ almost everywhere. Sigh.

Revision 1.2 / (download) - annotate - [select for diffs], Wed Jan 10 10:39:18 2007 UTC (16 years, 10 months ago) by drochner
Branch: MAIN
Changes since 1.1: +5 -4 lines
Diff to previous 1.1 (colored)

update to 2.3.2
This is a major update (since 2.0.7), involving an API rework

add a bl3 file

Revision / (download) - annotate - [select for diffs] (vendor branch), Tue Mar 14 20:17:59 2006 UTC (17 years, 8 months ago) by drochner
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2006Q4-base, pkgsrc-2006Q4, pkgsrc-2006Q3-base, pkgsrc-2006Q3, pkgsrc-2006Q2-base, pkgsrc-2006Q2, pkgsrc-2006Q1-base, pkgsrc-2006Q1
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

import pysqlite-2.0.7, an (incompatible) redesign of pysqlite

Revision 1.1 / (download) - annotate - [select for diffs], Tue Mar 14 20:17:59 2006 UTC (17 years, 8 months ago) by drochner
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>