Skip to content

Releases: AnswerDotAI/fastlite

v0.2.1

07 Jul 23:57
Compare
Choose a tag to compare

New Features

  • Auto handle UNSET values in update kwargs (#71)

v0.2.0

18 Jun 05:03
Compare
Choose a tag to compare

Breaking Changes

  • fetchone renamed to selectone, and now raises exception for non-unique return

New Features

  • Check for multi row return in selectone (#70)

v0.1.4

30 May 03:58
Compare
Choose a tag to compare

Bugs Squashed

  • upsert method doesn't support composite primary keys (#69)

v0.1.3

01 Apr 07:18
Compare
Choose a tag to compare

New Features

  • Add link_dcs and have create_mod output __all__ (#64)

v0.1.2

26 Feb 20:25
Compare
Choose a tag to compare

New Features

  • Add optional default value for get (#55), thanks to @tom-pollak
  • Add table iter; Add set_classes and get_tables (#51)
  • Add table.fetchone (#50)

v0.1.1

23 Dec 23:44
Compare
Choose a tag to compare

Breaking Changes

  • fastlite has been rewritten to now use apsw instead of sqlite3 (#47), thanks to @pydanny
    • The key driver of this is that we found major concurrency and performance regressions in the python 3.12 sqlite3 module. However, there are many other good reasons also to switch to apsw. The python stdlib sqlite3 module is designed to focus on compatibility with the Python DB API, where apsw is designed to focus on compatibility with sqlite itself. We have found in production applications that with apsw's design it is far easier to get good performance and reliability compared to the stdlib module.

New Features

  • Use new sqlite_minutils.Table.result attribute (#45), thanks to @pydanny
  • Make get_last defensive (#39), thanks to @pydanny
  • Rewrite insert() function to take advantage of RETURNING data (#37), thanks to @pydanny

Bugs Squashed

  • Table.insert() with Falsy value generates an error (#42)

v0.1.0

23 Dec 22:22
Compare
Choose a tag to compare

Breaking Changes

  • fastlite has been rewritten to now use apsw instead of sqlite3 (#47), thanks to @pydanny
    • The key driver of this is that we found major concurrency and performance regressions in the python 3.12 sqlite3 module. However, there are many other good reasons also to switch to apsw. The python stdlib sqlite3 module is designed to focus on compatibility with the Python DB API, where apsw is designed to focus on compatibility with sqlite itself. We have found in production applications that with apsw's design it is far easier to get good performance and reliability compared to the stdlib module.

New Features

  • Use new sqlite_minutils.Table.result attribute (#45), thanks to @pydanny
  • Make get_last defensive (#39), thanks to @pydanny
  • Rewrite insert() function to take advantage of RETURNING data (#37), thanks to @pydanny

Bugs Squashed

  • Table.insert() with Falsy value generates an error (#42)

v0.0.13

22 Oct 07:52
Compare
Choose a tag to compare

New Features

  • Add xtra param to all methods that use xtra instance var (#34)

v0.0.12

22 Oct 04:21
Compare
Choose a tag to compare

Breaking Changes

  • Bump sqlite-minutils dependency to use sqlite transactions

New Features

v0.0.11

07 Sep 00:29
Compare
Choose a tag to compare

New Features

  • add import_file (#24)