SingleStoreDB - Flyway

Verified Versions: 8.9
Maintainer: {% include redgate-badge.html %}

Supported Versions and Support Levels

{% include database-boilerplate.html %}

Driver

Item	Details
URL format	<code>jdbc:singlestore://<i>host</i>:<i>port</i>/<i>database</i></code>
SSL support	Yes - add `?useSsl=true`
Ships with Flyway Command-line	Yes
Maven Central coordinates	`com.singlestore:singlestore-jdbc-client`
Supported versions	`1.2.8` and later
Default Java class	`com.singlestore.jdbc.Driver`

Flyway's SinglestoreDB implementation reuses significant parts of the MySQL Database parser so it is worth reviewing that as part of your configuration setup.

Java Usage

SingleStoreDB support is a separate dependency for Flyway and will need to be added to your Java project to access these features.

SQL Script Syntax

Standard SQL syntax with a default statement delimiter of ; (semicolon)
If you are defining stored procedures and need to use semicolons in your script then Flyway will respect prefixing your script with the DELIMITER statement to change the statement delimiter
Comment directives generated by mysqldump /!.../;
MySQL-style single-line comments (# Comment)

Maven

Redgate

xml

<dependency>
    <groupId>com.redgate.flyway</groupId>
    <artifactId>flyway-singlestore</artifactId>
    <version>{{ site.flywayVersion }}</version>
</dependency>

Open Source

xml

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-singlestore</artifactId>
    <version>{{ site.flywayVersion }}</version>
</dependency>

You will also need to configure the repository

Gradle

Redgate

groovy

buildscript {
    dependencies {
        implementation "com.redgate.flyway:flyway-singlestore"
    }
}

You will also need to configure the repository