[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Jelle Zijlstra added the comment: Thanks, this will be in Python 3.11. -- resolution: -> fixed stage: patch review -> resolved status: open -> closed ___ Python tracker ___ _

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Jelle Zijlstra added the comment: New changeset a7551247e7cb7010fb4735281f1afa4abeb8a9cc by Erlend Egeberg Aasland in branch 'main': bpo-41930: Add support for SQLite serialise/deserialise API (GH-26728) https://github.com/python/cpython/commit/a7551247e7cb7010fb4735281f1afa4abeb8a9cc -

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Erlend E. Aasland added the comment: I've been fiddling with this between others projects lately; the PR is mostly ready. The only remaining issue is how to include this in the Connection object: - The serialize API was added as a compile-time option (SQLITE_ENABLE_DESERIALIZE) in SQLite 3.23

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Erlend E. Aasland added the comment: > What would be the use case for this? Quoting D. Richard Hipp, from the sqlite-users mailing list, 2018-03-18, FWIW: These APIs support the concept of using small databases (small enough to fit in memory) as a container for passing information around.

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Change by Erlend E. Aasland : -- keywords: +patch pull_requests: +25318 stage: -> patch review pull_request: https://github.com/python/cpython/pull/26728 ___ Python tracker __

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Erlend E. Aasland added the comment: FYI, the pending release log of the upcoming SQLite 3.36.0 now mentions that these API's are enabled by default: https://sqlite.org/releaselog/3_36_0.html -- ___ Python tracker

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Erlend E. Aasland added the comment: FYI, this was just checked into the SQLite fossil repo: $ fossil update trunk updated-to: 6df3b03e00b1143be8fed3a39a58ce8106302027 2021-05-08 17:18:23 UTC tags: trunk comment: Enable the sqlite3_serialize() and sqlite3_deserialize() interfac

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

Erlend E. Aasland added the comment: What would be the use case for this? -- nosy: +erlendaasland ___ Python tracker ___ ___ Python

[issue41930] Wrap sqlite3_serialize API in sqlite3 module

New submission from Kerrick Staley : It would be useful to provide a wrapper (in the Python sqlite3 stdlib module) for the sqlite3_serialize API. This API allows you to get a database's content as a byte string, as if you had called open('foo.sqlite3', 'rb').read(). sqlite3_serialize can even