Skip to content

Releases: AnswerDotAI/fastlite

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)

v0.0.10

29 Aug 07:35
Compare
Choose a tag to compare

New Features

  • add markdown to doc output (#22)
  • Use fastcore asdict instead of dataclasses asdict (#17), thanks to @pydanny

Bugs Squashed

  • Fix __contains__ on tuple pk searches (#20), thanks to @pydanny
  • Compound primary keys fail on __contains__ when done with tuple (#19)

v0.0.9

16 Aug 04:33
Compare
Choose a tag to compare

New Features

  • sqlite-minutil 3.37 compatibility

v0.0.8

15 Aug 16:58
Compare
Choose a tag to compare

New Features

  • Use flexiclass (#16)
  • Add select param (#15)

v0.0.7

10 Jul 00:43
Compare
Choose a tag to compare

New Features

  • Database.create for creating a table from a class (#12)

v0.0.6

09 Jun 03:24
Compare
Choose a tag to compare

Bugs Squashed

  • Fix None checks in fastlite.kw (#11)