ScalarDB SQL
ScalarDB SQL is an SQL layer for ScalarDB. Specifically, it parses SQL and converts it to a set of ScalarDB (API) operations.
Install
The libraries for ScalarDB SQL are available on the Maven Central Repository and as packages on GitHub. Since they are available under a commercial license, you need to get a license and permission to access them. For more details, please contact us.
Before you add the dependency, you need to add the Maven repository using your build tool such as Gradle and Maven.
To add the Maven repository using Gradle, add the following repository to your build.gradle
:
repositories {
maven {
url = uri("https://maven.pkg.github.com/scalar-labs/scalardb-sql")
credentials {
username = project.findProperty("gpr.user") ?: System.getenv("USERNAME")
password = project.findProperty("gpr.key") ?: System.getenv("TOKEN")
}
}
}
In this case, you need the gpr.user
property for your GitHub username and the gpr.key
property for your personal access token.
So you need to have the properties in ~/.gradle/gradle.properties
, or specify the properties with the -P
option when running the ./gradlew
command as follows:
./gradlew build -Pgpr.user=<your GitHub username> -Pgpr.key=<your personal access token>
Or you can also use environment variables, USERNAME
for your GitHub username and TOKEN
for your personal access token.
export USERNAME=<your GitHub username>
export TOKEN=<your personal access token>
To add the Maven repository using Maven, edit your ~/.m2/settings.xml
file as follows:
<settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0
http://maven.apache.org/xsd/settings-1.0.0.xsd">
<activeProfiles>
<activeProfile>github</activeProfile>
</activeProfiles>
<profiles>
<profile>
<id>github</id>
<repositories>
<repository>
<id>central</id>
<url>https://repo1.maven.org/maven2</url>
</repository>
<repository>
<id>github</id>
<url>https://maven.pkg.github.com/scalar-labs/scalardb-sql</url>
<snapshots>
<enabled>true</enabled>
</snapshots>
</repository>
</repositories>
</profile>
</profiles>
<servers>
<server>
<id>github</id>
<username>USERNAME</username>
<password>TOKEN</password>
</server>
</servers>
</settings>
In the servers
tag, add a child server
tag with an id
, replacing USERNAME with your GitHub username, and TOKEN with your personal access token.
Please see also the following documents for more details:
And then, you can install the library in your application using your build tool such as Gradle and Maven.
To add a dependency on ScalarDB SQL using Gradle, use the following:
dependencies {
// For Direct mode
implementation 'com.scalar-labs:scalardb-sql-direct-mode:3.12.4'
// For Server mode
implementation 'com.scalar-labs:scalardb-sql-server-mode:3.12.4'
}
To add a dependency using Maven:
<dependencies>
<!-- For Direct mode -->
<dependency>
<groupId>com.scalar-labs</groupId>
<artifactId>scalardb-sql-direct-mode</artifactId>
<version>3.12.4</version>
</dependency>
<!-- For Server mode -->
<dependency>
<groupId>com.scalar-labs</groupId>
<artifactId>scalardb-sql-server-mode</artifactId>
<version>3.12.4</version>
</dependency>
</dependencies>
Docs
- Getting Started with ScalarDB SQL
- Getting Started with ScalarDB JDBC
- ScalarDB SQL API Guide
- ScalarDB JDBC Guide
- ScalarDB SQL Grammar
- ScalarDB SQL Command Line interface
- ScalarDB SQL Server
- ScalarDB SQL Configurations
- Guide of Spring Data JDBC for ScalarDB
- Javadoc
- scalardb-sql - ScalarDB SQL: A SQL layer for ScalarDB
- scalardb-direct-mode - ScalarDB SQL Direct mode
- scalardb-sql-rpc - ScalarDB SQL RPC libraries
- scalardb-sql-server - ScalarDB SQL Server: A gRPC interface of ScalarDB SQL
- scalardb-server-mode - ScalarDB SQL Server mode
- scalardb-sql-jdbc - ScalarDB SQL JDBC: JDBC Driver for ScalarDB SQL
- scalardb-sql-cli - ScalarDB SQL CLI: ScalarDB SQL Command Line Interface
- scalardb-sql-integration-test - ScalarDB SQL Integration test: Integration tests for ScalarDB SQL
- scalardb-sql-spring-data - Spring Data JDBC for ScalarDB: Spring Data JDBC integration for ScalarDB