IvorySQL Ecosystem Plugin Compatibility List
IvorySQL, as an advanced open-source database compatible with Oracle and based on PostgreSQL, has powerful extension capabilities and supports a rich ecosystem of plugins. These plugins can help users enhance database functionality in different scenarios, including geospatial information processing, vector retrieval, full-text search, data definition extraction, and path planning. The following is a list of major plugins currently officially compatible with and supported by IvorySQL:
+
Plugin Name |
Version |
Function Description |
Use Cases |
3.4.0 |
Provides geospatial data support for IvorySQL, including spatial indexes, spatial functions, and geographic object storage |
Geographic Information Systems (GIS), map services, location data analysis |
|
0.8.0 |
Supports vector similarity search, can be used to store and retrieve high-dimensional vector data |
AI applications, image retrieval, recommendation systems, semantic search |
|
4.0.1 |
Provides multilingual full-text search functionality, supports ultra-fast text retrieval and fuzzy matching |
Log analysis, multilingual content search, real-time search engines |
|
0.20 |
Extracts DDL (Data Definition Language) statements from databases, facilitating version management and migration |
Database version control, CI/CD integration, structure comparison and synchronization |
|
3.5.1 |
Geographic data-based path planning extension, supports shortest path, traveling salesman problem and other algorithms |
Logistics planning, traffic network analysis, path optimization services |
|
1.6.0 |
Provides database-internal scheduled task scheduling functionality, supports regular SQL statement execution |
Data cleanup, regular statistics, automated maintenance tasks |
|
1.7.0 |
Allows HTTP requests to be initiated in SQL, interacting with external web services |
Data collection, API integration, microservice calls |
|
0.8.0 |
Provides sharding and distributed extension support for vector data, improving large-scale vector processing performance |
Distributed vector databases, high-concurrency vector queries |
These plugins have all been tested and adapted by the IvorySQL team to ensure stable operation in the IvorySQL environment. Users can select appropriate plugins based on business needs to further enhance the capabilities and flexibility of the database system.
We will continue to expand and enrich the IvorySQL plugin ecosystem. Community developers are welcome to submit new plugin adaptation suggestions or code contributions. For more detailed usage methods and the latest compatible versions of each plugin, please refer to the corresponding documentation chapters for each plugin.