SingleStoreDB
Published 15 January 2025
- Verified Versions: 7.1, 7.8
- Maintainer: Redgate
Supported Versions and Support Levels
- For information regarding the supported version and support levels available, please see Supported Databases for Flyway
- For information regarding the Flyway features available, please see Flyway feature summary
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