Managed Database

Dear Digital Ocean! In my application the following use case came up, that I would like to do long term data archiving on parts of my operational data in a managed postgreSQL cluster. I found the list of the supported extensions here in the docs . I figured, that I would like to use Parquet files for archiving and analytics in my s3 compatible (do spaces) storage. For that I need the following extension: pg_parquet But sadly this extension is not supported yet. To configure this extension, you have to provide credentials for your object storage , which could be set from a config file or environment variables . That capability to manage some parts of the filesystem or extend envvars alongside the pg_parquet extension support would be really helpful. Hope to hear from this feature request soon! Best Regards, Bendegúz

It would be nice if knowledge bases supported the parque format

There is no point of using unnecessary TLS handshakes etc slowing down performance of apps if we are connecting a managed database from within a secure and trusted VPC.

Apache AGE is a PostgreSQL extension that provides graph database functionality. The goal of Apache AGE is to enable users of Postgres to use graph query modeling in unison with Postgres’ existing relational model. Apache AGE is a Top-Level Project of the Apache Software Foundation since May 2022. It is licensed under the Apache License 2.0.

DuckDB has just launched a new pg_duckdb extension and I want to use it in my PostgreSQL database to improve the performance in analytics. pg_duckdb is a Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres. The GitHub repo: https://github.com/duckdb/pg_duckdb

pganalyze provides a more robust set of utilities for managing queries

Add a non-English full text search extension called pgroonga for the managed Postgres database

"A lightweight message queue. Like AWS SQS and RSMQ but on Postgres." See: https://github.com/tembo-io/pgmq

Our server heavily relies on PGroonga for various text search capabilities. We wanted to move to DigitalOcean and use the Managed service However, we’ve reviewed the supported extensions and it seems this extension is not supported. Is there any possibility to enable this extension ? It’s a real issue for us, and I assume for many more that rely on the Groonga project.

This library provides PostgreSQL bindings for the H3 Core Library Please refer to the below page: https://github.com/zachasme/h3-pg