SingleStore¶
Warning
Currently the SingleStore extension is a community module. While still usable, do not expect the same reliability as with supported extensions.
SingleStore is an open source relational database with some limited spatial functionality.
In particular, it supports only GEOGRAPHY data types, does not support multipart geometries,
and has a specialized GEOGRAPHYPOINT type that is used to store points with higher performance than the
generic GEOGRAPHY type. Spatial functionality is limited to simple search operations, such as
intersects, contains, and within distance.
Installing the SingleStore extension¶
Download the singlestore community module from geoserver-2.27.x-singlestore-plugin.zip
Warning
As a community module, it can only be found in community nightly builds, and not in the official GeoServer releases. Make sure to match the version of the extension to the version of the GeoServer instance!
Extract the contents of the archive into the
WEB-INF/libdirectory of the GeoServer installation.
Adding a SingleStore database¶
Once the extension is properly installed SingleStore will show up as an option when creating a new data store.
SingleStore in the list of data sources¶
Configuring a SingleStore data store¶
Configuring a SingleStore data store¶
|
The SingleStore server host name or ip address. |
|
The port on which the SingleStore server is accepting connections. |
|
The name of the database to connect to. Can also contain a suffix with a connection URL query, such as mydbname?useSSL=false |
|
The name of the user to connect to the SingleStore database as. |
|
The password to use when connecting to the database. Left blank for no password. |
|
Connection pool configuration parameters. See the Database Connection Pooling section for details. |