[InterNetNews/inn] c1798d: ovsqlite-util: Fix how transactions are handled

[Julien ÉLIE]

  Branch: refs/heads/2.7
  Home:   https://github.com/InterNetNews/inn
  Commit: c1798d6562b60541c8b78b203b6097ecffe04568
      https://github.com/InterNetNews/inn/commit/c1798d6562b60541c8b78b203b6097ecffe04568
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M storage/ovsqlite/ovsqlite-util.in

  Log Message:
  -----------
  ovsqlite-util: Fix how transactions are handled

Turning enforcement of foreign key constraints on or off is an SQLite
operation that can only be done outside of any transaction.

When the AutoCommit attribute is false, the do method of the database
handle will helpfully start a transaction if one isn't active already.
That is why this AutoCommit attribute has to be set to true for that
operation.

Patch from Bo Lindbergh.


  Commit: e643a341b863fa7ed5aade9f65c1e03ef6b2d967
      https://github.com/InterNetNews/inn/commit/e643a341b863fa7ed5aade9f65c1e03ef6b2d967
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M doc/pod/ovsqlite-util.pod
    M storage/ovsqlite/ovsqlite-util.in

  Log Message:
  -----------
  ovsqlite-util: Add support for compressed overview data

Many thanks to Bo Lindbergh for having provided the decompression code!


  Commit: c3185ac5da95af0eccf8a88c4d8fac8cddbf7f73
      https://github.com/InterNetNews/inn/commit/c3185ac5da95af0eccf8a88c4d8fac8cddbf7f73
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M storage/ovsqlite/sql-init.sql

  Log Message:
  -----------
  ovsqlite: Document how the length is encoded

Thanks to Bo Lindbergh for the clarification.


  Commit: 1c414c97c0286da3fde3e250ac07372fd37770f7
      https://github.com/InterNetNews/inn/commit/1c414c97c0286da3fde3e250ac07372fd37770f7
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M storage/ovsqlite/ovsqlite-util.in

  Log Message:
  -----------
  ovsqlite-util: Style homogenization


Compare: https://github.com/InterNetNews/inn/compare/20189adfbcf0...1c414c97c028