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¶
Login, and navigate to and check Build Information to determine the exact version of GeoServer you are running.
Visit the website download page, change the Development tab, and locate the nightly release that corresponds to the GeoServer you are running.
Follow the Community Modules link and download singlestore zip archive.
3.0-SNAPSHOT example: geoserver-3.0-SNAPSHOT-singlestore-plugin.zip
The website lists active nightly builds to provide feedback to developers, you may also browse for earlier branches.
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. |