documentdb_core

Overview

PIGSTY 3rd Party Extension: pg_documentdb_core : Core API surface for DocumentDB on PostgreSQL

Information

• Extension ID: 2740
• Extension Name: documentdb_core
• Package Name: pg_documentdb_core
• Category: FEAT
• License: MIT
• Website: https://github.com/microsoft/documentdb
• Language: C
• Extra Tags: N/A
• Comment:

Metadata

• Latest Version: 0.100-0
• Postgres Support: 17,16,15
• Need Load: Explicit Loading Required
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_documentdb_core_$v*
• RPM Ver : 0.100-0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-documentdb-core
• DEB Ver : 0.100-0
• DEB Deps: N/A

Packages

Installation

Install documentdb_core via the pig CLI tool:

pig ext install pg_documentdb_core; # Extension Namepig ext install documentdb_core; # normalized package name

Install pg_documentdb_core via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_documentdb_core"]}' # -l <cls>

Install pg_documentdb_core RPM from YUM repo directly:

dnf install pg_documentdb_core_17*;
dnf install pg_documentdb_core_16*;
dnf install pg_documentdb_core_15*;

Install pg_documentdb_core DEB from APT repo directly:

apt install postgresql-17-documentdb-core;
apt install postgresql-16-documentdb-core;
apt install postgresql-15-documentdb-core;

Extension documentdb_core has to be added to shared_preload_libraries

shared_preload_libraries = 'pg_documentdb_core'; # add to pg cluster config

Enable documentdb_core extension on PostgreSQL cluster：

CREATE EXTENSION documentdb_core;

Usage

Add to shared_preload_libraries first:

-    shared_preload_libraries: documentdb_core, pg_stat_statements, auto_explain
+    shared_preload_libraries: pg_documentdb_core, pg_stat_statements, auto_explain

Example, create extension and perform DDL & CRUD

CREATE EXTENSION documentdb_core ;

Currently we only have documentdb_core extension, It can be used with the FerretDB 2.0+