The most recent version of our net-im/py-matrix-synapse port requires json1 support for sqlite3.
Can we include this in the default options for the sqlite3 port? Otherwise people relying on packages and using synapse w/ sqlite3 cannot upgrade past 1.11.0. I'm also open to other suggestions.
Created attachment 212156 [details]
databases/sqlite3: include json1 support by default
I've attached a trivial patch to enable JSON1 support by default for the databases/sqlite3 port.
- ... doesn't incur any additional dependencies
- ... resolves this bug and allows us to move forward with updating py-matrix-synapse
- ... seems like the most trivial solution for this current problem
Can we get this committed? There's a security critical update for py-matrix-synapse that is waiting for any action on this issue. I'm completely open for suggestions on how to resolve this differently, but I'd like to move on this rather quickly for obvious reasons.
I've checked a few Linux distributions about the status of the json extension. At least the following have it enabled:
- Debian (buster)
- Alpine Linux
In the ArchLinux PKGBUILD  there is a comment "json extensions breaks parallel build" where I am not sure if that is still valid.
Technically we already have a maintainer timeout but i'll prefer to wait a few more days to hopefully get some feedback from the maintainer.
Since the matrix-synapse update in bug 244279 needs to be MFH's (security update), this will need to be merged too
Is more comprehensize QA (such as an exp-run) required or indicated given the number of consumers of sqlite?
Hello. I'm added this path to PR#243602. Please check it status.