Redgate Flyway

SingleStoreDB

  • Verified Versions: 7.1, 7.8
  • Maintainer: Redgate

Supported Versions and Support Levels

Driver

Item Details
URL format jdbc:singlestore://host:port/database
SSL support Yes - add ?useSsl=true
Ships with Flyway Command-line Yes
Maven Central coordinates com.singlestore:singlestore-jdbc-client
Supported versions 1.1.4 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

<dependency>
    <groupId>com.redgate.flyway</groupId>
    <artifactId>flyway-singlestore</artifactId>
    <version>11.13.1</version>
</dependency>

Open Source

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-singlestore</artifactId>
    <version>11.13.1</version>
</dependency>

You will also need to configure the repository

Gradle

Redgate

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

You will also need to configure the repository


Didn't find what you were looking for?