Install Extensions and Plugins

SynxDB’s functionality can be enhanced through various plugins and extensions. This document guides you on which features are built-in and which require separate installation.

Built-in plugins and extensions

The core RPM package of SynxDB comes pre-packaged with most of the commonly used plugins and extensions. After you have completed the database deployment, these features can typically be enabled simply by executing CREATE EXTENSION in the database, without requiring any additional installation steps.

The main built-in plugins and extensions include:

  • ZomboDB: Provides integration with Elasticsearch for full-text indexing and search capabilities.

  • pgvector: Used for storing and querying vector embeddings, which is fundamental for building AI applications like similarity search.

  • RoaringBitmap: Offers an efficient bitmap data structure for high-performance aggregation and filtering operations.

  • PL/Java: Allows executing Java code within the database to implement complex data processing logic.

  • PL/Python: Allows executing Python code within the database to implement complex data processing logic.

  • Anon: Provides data anonymization features to protect sensitive data.

Components requiring separate installation

Some features are provided as separate components with their own installation packages and deployment processes. If you need to use these features, see their respective documents for installation.

  • PXF (Platform Extension Framework). PXF provides the ability to interact with external data sources such as HDFS, object storage, and Hive, supporting in-place querying and high-speed data loading. For installation instructions, see Load Data Using PXF.

  • SynxML Platform. SynxML is an end-to-end data science and machine learning platform that integrates the entire lifecycle of data preparation, model training, deployment, and management. For installation instructions, see Deploy ML Platform.

  • DBCC (Monitoring Console). DBCC is a console tool specifically for monitoring the status and performance of a SynxDB cluster, providing visual monitoring metrics and alerting capabilities. For installation instructions, please refer to Install DBCC Monitoring Console.

  • MADlib. MADlib is an extensible, open-source in-database machine learning library that provides data scientists with a rich set of data-parallel algorithms. For installation instructions, please refer to MADlib Machine Learning.

  • UnionStore. UnionStore is a storage engine for Heap tables and their indexes, which, combined with SynxDB, forms a compute-storage separated architecture. For installation instructions, please refer to UnionStore Storage Format.