DolphinDB database supports dynamic loading of external plugins to extend system functionality. The plug-in can be written in C++, and it needs to be compiled into ".so" shared libraries or ".dll" shared library files.
include
The directory contains the class declarations and some tool class declarations for the core data structures of DolphinDB. These classes are important basic tools for implementing plug-ins.demo
The directory contains a demo plug-in implementation.odbc
The directory contains an implementation of the odbc plugin.
Use the loadPlugin
function to load external plug-ins. This function accepts a file path, which describes the format of the plug-in, for example:
loadPlugin("/YOUR_SEVER_PATH/plugins/odbc/PluginODBC.txt");
The premise is that the DolphinDB server version>=1.20; the plug-in that needs to be pre-loaded should exist. Otherwise, there will be an exception when the sever starts. Multiple plug-ins are easy to separate by ','.
preloadModules=plugins::mysql,plugins::odbc
DolphinDB uses a text file to describe the plugin. The file format is as follows:
The first line describes the plug-in name and shared library file name.
Each of the following lines describes the mapping between a shared library function and the DolphinDB function.
module name, lib file
function name in lib, function name in DolphinDB, function type, minParamCount, maxParamCount, isAggregated
...
Explanation:
- module name: plugin module name
- lib file: shared library file name
- function name in lib: the function name in the shared library
- function name in DolphinDB: corresponding function name in DolphinDB
- function type: operator or system
- minParamCount: the minimum number of parameters
- maxParamCount: the maximum number of parameters
- isAggregated: whether it is an aggregate function
PluginDemo.txt:
demo,libPluginDemo.so
minmax,minmax,operator,1,1,0
foo,foo,system,1,1,0
The description file above defines a plugin named demo
. The shared library file is named libPluginDemo.so
.
The plug-in exports two functions. The first function is named minmax
. The name of the function is also minmax
in DolphinDB. The function type is "operator" and accepts one parameter. The second function name is echo
, the name in DolphinDB is also echo
, the function type is "system" and accepts one argument.
After finishing the description file, you can start writing plugins. For content, please refer to demo
folder contents.
The compiler needs to use DolphinDB's core library libDolphinDB.so
, which implements the classes declared in include
directories.
cd demo
g++ -DLINUX -fPIC -c src/Demo.cpp -I../include -o Demo.o
g++ -fPIC -shared -o libPluginDemo.so Demo.o -lDolphinDB
After successful compilation, a shared library file named libPluginDemo.so
will be generated under the directory.
Enter the following command in the DolphinDB console to load the plugin and use it.
>loadPlugin(Path to PluginDemo.txt); // Load the plugin
(minmax,echo)
>use demo; // Import the plugin's namespace
>demo::minmax([12,3,4]); // You can also use minmax([12,3,4])
[3,12]
>demo::echo("foo");
foo
>echo(1);
1
For examples of implementation of more complex plugins please refer to the odbc
directory.
- We recommend that you use the command
ld
to check if the compiler link is successful and if there are undefined references in the so. If the commandld
generates an error, then DolphinDB can not load the plug-in correctly. - If the program crashes after loading the plug-in, try the following steps:
- Make sure that the
include
headers are consistent with thelibDolphinDB.so
implementation. - Make sure that the version of
gcc
used to compile the plugin is consistent with the version of ``libBoardDB.so``` in order to avoid the incompatibilities between different versions of the compiler ABI.
- Make sure that the