Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-25604

Provide a KeyValueStore implementation in SQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.10
    • Component/s: Runtime
    • Impact type:
      API change
    • Upgrade notes:
      Hide

      A new Key/Value Store based on SQL is available. To configure a server to use it, use:

        <extension target="org.nuxeo.runtime.kv.KeyValueService" point="configuration">
          <store name="default" class="org.nuxeo.ecm.core.storage.sql.kv.SQLKeyValueStore">
            <property name="datasource">jdbc/nuxeo</property>
            <property name="table">kv</property>
          </store>
        </extension>
      

      Note that the PostgreSQL implementation requires the use of a version of PostgreSQL >= 9.5 to implement the put operation (PostgreSQL 11.x is the supported version with Nuxeo 10.10 anyway).

      Show
      A new Key/Value Store based on SQL is available. To configure a server to use it, use: <extension target= "org.nuxeo.runtime.kv.KeyValueService" point= "configuration" > <store name= "default" class= "org.nuxeo.ecm.core.storage.sql.kv.SQLKeyValueStore" > <property name= "datasource" > jdbc/nuxeo </property> <property name= "table" > kv </property> </store> </extension> Note that the PostgreSQL implementation requires the use of a version of PostgreSQL >= 9.5 to implement the put operation (PostgreSQL 11.x is the supported version with Nuxeo 10.10 anyway).
    • Sprint:
      nxFG 10.10.1
    • Story Points:
      5

      Description

      The default implementation of the KVStore is Redis, only MongoDB comes with alternative implementation.

      It makes sense to have a KVStore in SQL as well so we don't need to deploy a Redis especially.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days
                  3d

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.