Full text search - SQL Platform - Releases

← App details

Nextcloud 31

Full text search - SQL Platform 1.2.0
Release Details
UpdatedSept. 11, 2025, 7:55 p.m.
Changelog

Changed

  • Enforce configured encodings strictly, rejecting documents matching none of them. This makes it possible to reject binary documents from being indexed (#15).

Fixed

  • Delete documents from DB when they are deleted from Nextcloud (#19).
  • Actually use PostgreSQL fulltext index, fixing slow search query performance (#14, #16). Thanks to @joergsch!
Licenses AGPLv3+
Certificate-----BEGIN CERTIFICATE-----
MIIEDTCCAvUCAhKyMA0GCSqGSIb3DQEBCwUAMHsxCzAJBgNVBAYTAkRFMRswGQYD
VQQIDBJCYWRlbi1XdWVydHRlbWJlcmcxFzAVBgNVBAoMDk5leHRjbG91ZCBHbWJI
MTYwNAYDVQQDDC1OZXh0Y2xvdWQgQ29kZSBTaWduaW5nIEludGVybWVkaWF0ZSBB
dXRob3JpdHkwHhcNMjUwNzMxMDczOTE0WhcNMzUxMTA2MDczOTE0WjAdMRswGQYD
VQQDDBJmdWxsdGV4dHNlYXJjaF9zcWwwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw
ggIKAoICAQC1LKU9cVRVTBKrateJm1X2mykGoaYS36g2UmXZ/TfWq0aUzZeMWu4C
2MbwYmyr6MTDSblj5yHhEMCluak12E1aWJ6O3coSCN4f/RhrnSSVONRp7rmpUWLj
wpr+LULJeR4HJVP/Mx9yMaFylp/gHZxEAioypufxL6/dKngn8XKo/r48uyM+UPDz
n5z5NEY5d3M+jYsQUUhrmonWzhE3jj1FS2MqJXD42VGACFwKCUZD+H0Dzi4CgIyN
/HYygAez5PhLrvAMrm6pj8gC/d8mRTbaztgp7xCC98PvuuNwbHwGHik76z8sWIjX
Pet26We2xWCd5ObYcVqlIRgKWQj7ZQ8IwJX6KRedGx+UHtrilhtWvWFcE329neYR
Kac36XBCpOjP3BuhF9fS3lRDFLNvcDS0mS0XxR7RbYNz42tJbzFl99Mco3dMzw7D
xwwbJZdahhZ+uWciV5w4aHgvbeaZWJtLIo1il0cTRML24Hq7AwBIN0omRmuyHMlU
nthRClFCg2tdbk/S26CHkoHr9Xfrh80d7HbqUoI4WNo+W6ajoHqOhVxZMSB6kfuE
fXsGGVrvoCT03oF69Xu/rrEeqAv96DOANsIDY/w9ZTbakOJcmnWyUUqIuXA67a1e
4OCDMRCt3s4RPc36sOhNzrvC1dDUxg2ZJcZx85KqR8sMJ7XrZHE5cwIDAQABMA0G
CSqGSIb3DQEBCwUAA4IBAQAm1k8GkkE/8iixk2ucpUyxaUPs+WFtCNM1rSIjuOQT
JUm1wXgWriWbDZCkl0ncs/SCk8Fyp3LoTZ0aJBtdXMKuvFq5SFgCyuz1RWWxMefb
7pPYKcp/bXP58S8xS0NrCa3A4s+awl+rIbGya1Xww7No9ca+25oDXSlZAAVBdRaf
TcYBTXiiB8F1K76dMq9UpqxZrad9EsKzdIiri9inzhrlPU3CAHHWLvcDq2Aa35kt
hr0CcMFJ/NdOMBqvOSig5hGOERQVO9K6S4wayLiQ6yvzgooOkQcmpsSK0xqK8bSn
Gx8C/5vplkItnUMDzgK4LW0dlmDExmxfslFGwojWXUxR
-----END CERTIFICATE-----
SignaturegyNx2FirRGwwwHzVBrVFUMqwCIo8Wv469clHnPwL8Uiqsefpd9PerHVoZBMyaidrn+pjBOVpydT/3uvOmFFKmQTvXmgvJyMFKl/XvmF69WjD1HowGdIBLbGZ+gHVzXDHrv1GsHaNAcmiWEKRuEyaIAw/6CXSijeYOjs6ZXGwKmh7pW63Q+ncf3AUTVGljYU8207YNgBx0peGZ/zTfoDuhaDjLcHRNwurlfpIPlwWqraM2kKTbUVa/EtGN8ORaeLAQcgUPngSOUUa6j3VQfFGyCE1re9vfZYh6W5V46+NWhv5XUO55eClYElPR5PzAejZrjIu8M6sRongNz5qoKplZJgr9HgeFXAlOncl7qZOWGQeWdtAvSvLMhDJh2gE9+jKxqSYpjCHF7MSgA3M6d07WfT/TKh4TXTmN/Ib0j7zF6Jxmy/nD/zCArgQq+oBoVFEoQ+PRZfXlG7pGl/nKoEOA3PUPTxJgLM8X4XpzzqwJph4K2YSVX+PjEBdMFaF9rBq1i8ToJDlP/LxWjSRHTenBdhYVcvKrXXaDAk4+Z7fJij4+BOZ1Ooz7s2RyAHhjVVtnWM8cCubj0LjM84przHcg1NS7MiZl7q/Jat4CL0YrwF3QRgM6KAc5OLgB2sjrGT/6wPesneZ4/nN217ifwJMwK6dLHseUk1rH7OnaLsKj0U=
Signature digestsha512
Dependencies
Required Nextcloud versions >=31.0.0,<32.0.0
Databases MySQL
PostgreSQL
Minimum Integer bits32
Download Full text search - SQL Platform 1.2.0
Full text search - SQL Platform 1.1.0
Release Details
UpdatedAug. 13, 2025, 7:15 p.m.
Licenses AGPLv3+
Certificate-----BEGIN CERTIFICATE-----
MIIEDTCCAvUCAhKyMA0GCSqGSIb3DQEBCwUAMHsxCzAJBgNVBAYTAkRFMRswGQYD
VQQIDBJCYWRlbi1XdWVydHRlbWJlcmcxFzAVBgNVBAoMDk5leHRjbG91ZCBHbWJI
MTYwNAYDVQQDDC1OZXh0Y2xvdWQgQ29kZSBTaWduaW5nIEludGVybWVkaWF0ZSBB
dXRob3JpdHkwHhcNMjUwNzMxMDczOTE0WhcNMzUxMTA2MDczOTE0WjAdMRswGQYD
VQQDDBJmdWxsdGV4dHNlYXJjaF9zcWwwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw
ggIKAoICAQC1LKU9cVRVTBKrateJm1X2mykGoaYS36g2UmXZ/TfWq0aUzZeMWu4C
2MbwYmyr6MTDSblj5yHhEMCluak12E1aWJ6O3coSCN4f/RhrnSSVONRp7rmpUWLj
wpr+LULJeR4HJVP/Mx9yMaFylp/gHZxEAioypufxL6/dKngn8XKo/r48uyM+UPDz
n5z5NEY5d3M+jYsQUUhrmonWzhE3jj1FS2MqJXD42VGACFwKCUZD+H0Dzi4CgIyN
/HYygAez5PhLrvAMrm6pj8gC/d8mRTbaztgp7xCC98PvuuNwbHwGHik76z8sWIjX
Pet26We2xWCd5ObYcVqlIRgKWQj7ZQ8IwJX6KRedGx+UHtrilhtWvWFcE329neYR
Kac36XBCpOjP3BuhF9fS3lRDFLNvcDS0mS0XxR7RbYNz42tJbzFl99Mco3dMzw7D
xwwbJZdahhZ+uWciV5w4aHgvbeaZWJtLIo1il0cTRML24Hq7AwBIN0omRmuyHMlU
nthRClFCg2tdbk/S26CHkoHr9Xfrh80d7HbqUoI4WNo+W6ajoHqOhVxZMSB6kfuE
fXsGGVrvoCT03oF69Xu/rrEeqAv96DOANsIDY/w9ZTbakOJcmnWyUUqIuXA67a1e
4OCDMRCt3s4RPc36sOhNzrvC1dDUxg2ZJcZx85KqR8sMJ7XrZHE5cwIDAQABMA0G
CSqGSIb3DQEBCwUAA4IBAQAm1k8GkkE/8iixk2ucpUyxaUPs+WFtCNM1rSIjuOQT
JUm1wXgWriWbDZCkl0ncs/SCk8Fyp3LoTZ0aJBtdXMKuvFq5SFgCyuz1RWWxMefb
7pPYKcp/bXP58S8xS0NrCa3A4s+awl+rIbGya1Xww7No9ca+25oDXSlZAAVBdRaf
TcYBTXiiB8F1K76dMq9UpqxZrad9EsKzdIiri9inzhrlPU3CAHHWLvcDq2Aa35kt
hr0CcMFJ/NdOMBqvOSig5hGOERQVO9K6S4wayLiQ6yvzgooOkQcmpsSK0xqK8bSn
Gx8C/5vplkItnUMDzgK4LW0dlmDExmxfslFGwojWXUxR
-----END CERTIFICATE-----
SignatureRB5s4WHc5E6QDwxHs3QXutdXSKI1NgyRfu8oI4NOvGC33XaWmXpq3DjZ6e+WsAcYiiDDRt0tUgZsUq4DID6ojmdvkZM9ilV67wBdrTM8NeJ0FbEepSideGt4GSRK+scNGrygqkKiu1yNfALJ+SXVWPPJvCpms7hnjQkJLRjmltvvZ3RueV9ewV5ncOqYbj+apVzTUya8+UhTO9vgupjWBnq/FefSBG1dfX/h+nFt5/Zg/Q5meaEijE44rufcOxq9hlg47ZMmnwqOhx8V7g2cbs9v7iza7ALpHA5MhNT/vQ9yfZ5AlE+ali5tbkuaK95QcY3OjkmIpFu9daF6x+L0WiWnKrCBefaKrNUdj5WtsfhNgFeSumXLv8J9n9sYdSSx9Wbsdtu1vw2Yte+3Vlvla6Uja/Xvc3WyigAzOvS/Jf+XyAXw7eYAEf0qj/OZWEmqwoVRWYNTis4S3uqxRf5tN0C93w0MItr7RZJEowwkAIWiGgjPO8MRFWPDKXa1iBLJec3lhg0jP9T6LneWKnaizOQ6P/lwrEy/UKKvc3iBaRwBTepHm3acqYMm7VTp95ReCavkwjBA76JNLYVA6crqnmexyUWRl9GnXTNC+Hbd/f+Co959yFjvzWeBzQA6jFQLAx9f9E1eL3TeUKfy9uqKugGwWgNyZfZzr8dhemJEkLs=
Signature digestsha512
Dependencies
Required Nextcloud versions >=31.0.0,<32.0.0
Databases MySQL
PostgreSQL
Minimum Integer bits32
Download Full text search - SQL Platform 1.1.0
Full text search - SQL Platform 1.0.0
Release Details
UpdatedJuly 31, 2025, 9 a.m.
Licenses AGPLv3+
Certificate-----BEGIN CERTIFICATE-----
MIIEDTCCAvUCAhKyMA0GCSqGSIb3DQEBCwUAMHsxCzAJBgNVBAYTAkRFMRswGQYD
VQQIDBJCYWRlbi1XdWVydHRlbWJlcmcxFzAVBgNVBAoMDk5leHRjbG91ZCBHbWJI
MTYwNAYDVQQDDC1OZXh0Y2xvdWQgQ29kZSBTaWduaW5nIEludGVybWVkaWF0ZSBB
dXRob3JpdHkwHhcNMjUwNzMxMDczOTE0WhcNMzUxMTA2MDczOTE0WjAdMRswGQYD
VQQDDBJmdWxsdGV4dHNlYXJjaF9zcWwwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw
ggIKAoICAQC1LKU9cVRVTBKrateJm1X2mykGoaYS36g2UmXZ/TfWq0aUzZeMWu4C
2MbwYmyr6MTDSblj5yHhEMCluak12E1aWJ6O3coSCN4f/RhrnSSVONRp7rmpUWLj
wpr+LULJeR4HJVP/Mx9yMaFylp/gHZxEAioypufxL6/dKngn8XKo/r48uyM+UPDz
n5z5NEY5d3M+jYsQUUhrmonWzhE3jj1FS2MqJXD42VGACFwKCUZD+H0Dzi4CgIyN
/HYygAez5PhLrvAMrm6pj8gC/d8mRTbaztgp7xCC98PvuuNwbHwGHik76z8sWIjX
Pet26We2xWCd5ObYcVqlIRgKWQj7ZQ8IwJX6KRedGx+UHtrilhtWvWFcE329neYR
Kac36XBCpOjP3BuhF9fS3lRDFLNvcDS0mS0XxR7RbYNz42tJbzFl99Mco3dMzw7D
xwwbJZdahhZ+uWciV5w4aHgvbeaZWJtLIo1il0cTRML24Hq7AwBIN0omRmuyHMlU
nthRClFCg2tdbk/S26CHkoHr9Xfrh80d7HbqUoI4WNo+W6ajoHqOhVxZMSB6kfuE
fXsGGVrvoCT03oF69Xu/rrEeqAv96DOANsIDY/w9ZTbakOJcmnWyUUqIuXA67a1e
4OCDMRCt3s4RPc36sOhNzrvC1dDUxg2ZJcZx85KqR8sMJ7XrZHE5cwIDAQABMA0G
CSqGSIb3DQEBCwUAA4IBAQAm1k8GkkE/8iixk2ucpUyxaUPs+WFtCNM1rSIjuOQT
JUm1wXgWriWbDZCkl0ncs/SCk8Fyp3LoTZ0aJBtdXMKuvFq5SFgCyuz1RWWxMefb
7pPYKcp/bXP58S8xS0NrCa3A4s+awl+rIbGya1Xww7No9ca+25oDXSlZAAVBdRaf
TcYBTXiiB8F1K76dMq9UpqxZrad9EsKzdIiri9inzhrlPU3CAHHWLvcDq2Aa35kt
hr0CcMFJ/NdOMBqvOSig5hGOERQVO9K6S4wayLiQ6yvzgooOkQcmpsSK0xqK8bSn
Gx8C/5vplkItnUMDzgK4LW0dlmDExmxfslFGwojWXUxR
-----END CERTIFICATE-----
SignatureWIEdHfO/JXE9RxZRWOe2rsqvFxuk7oAAf72i9UDUTY7eiHa08qe0qqTzOX7o+RUHhPPh93GJRLfM/L3bY7smU2zG3SpXlriWa8qFX4F4DZmjoZfBfuzgHb4j1w3T8RLTLcgdt76BfeLZ77h0BfoY8TEmJwze2AHaNUcbIPAgppE5MFZTPIOFi4lZiS0JqnJ64ktKY1qSEkn617eVZphCPzkYJ1woy5VuIISsko6hjnD0bO40b2FNw+PnTIzdpR2DALbU+Z01UJUDgVVo9zWCDjciYlAwdvbsG3wF9wFUamw4+FRBCwsAUqmiQjT6cDwCz3XIVdBmn4mviL1BWPLumKpTWrT9w5hbyZB0SoFb/snhCNf2GBsxfejnkgFriaii3gI5keGVF9yWN8ALr8ZRYijLQWYK6eVNzn7nXCP7YXILNxcXHfhuhEIIEycdbrbv94rgLIIwzVj8hHsLdZaM5sUwipiC96xr1Ob82Dd5C+HRTywlWPDt72hopqLmfR38G7qxNBq09np/hWJIm1VXA/Blfwu8mJei5i4SE3R0Lxb3MarrMXI/z9NYYaYLwxqp1Fu0uu24tZe1iG6BSq3y91DgMUiD3w6XyallWRPMN1iqxv/Jzf3SF970dIZYL9FiuuO/iAt08H7sQsfAo2Wr4aBsyloXu0JoDSzOsmbhvrI=
Signature digestsha512
Dependencies
Required Nextcloud versions >=31.0.0,<32.0.0
Databases MySQL
PostgreSQL
Minimum Integer bits32
Download Full text search - SQL Platform 1.0.0