1 of 6

SQL Databases

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

MariaDB

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

<dependency>
       <groupId>one.microstream</groupId>
       <artifactId>filesystem.sql</artifactId>
       <version>04.01.00-MS-GA</version>
</dependency>
<dependency>
       <groupId>org.mariadb.jdbc</groupId>
       <artifactId>mariadb-java-client</artifactId>
       <version>2.7.1</version>
</dependency>

MariaDbDataSource dataSource = new MariaDbDataSource();
dataSource.setUrl("jdbc:mysql://host:3306/mydb");
dataSource.setUser("user");
dataSource.setPassword("secret");

SqlFileSystem fileSystem = SqlFileSystem.New(
     SqlConnector.Caching(
          SqlProviderMariaDb.New(dataSource)
     )
);

EmbeddedStorage.start(fileSystem.ensureDirectoryPath("microstream_storage"));

MySQL

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

<dependency>
       <groupId>one.microstream</groupId>
       <artifactId>filesystem.sql</artifactId>
       <version>04.01.00-MS-GA</version>
</dependency>
<dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>8.0.21</version>
</dependency>

MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUrl("jdbc:mysql://host:3306/mydb");
dataSource.setUser("user");
dataSource.setPassword("secret");

SqlFileSystem fileSystem = SqlFileSystem.New(
     SqlConnector.Caching(
          SqlProviderMySql.New(dataSource)
     )
);

EmbeddedStorage.start(fileSystem.ensureDirectoryPath("microstream_storage"));

Oracle

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

<dependency>
       <groupId>one.microstream</groupId>
       <artifactId>filesystem.sql</artifactId>
       <version>04.01.00-MS-GA</version>
</dependency>
<dependency>
       <groupId>com.oracle.database.jdbc</groupId>
       <artifactId>ojdbc8</artifactId>
       <version>19.7.0.0</version>
</dependency>

OracleDataSource dataSource = new OracleDataSource();
dataSource.setURL("jdbc:oracle:thin:@localhost:1521/db");
dataSource.setUser("user");
dataSource.setPassword("secret");
            
SqlFileSystem fileSystem = SqlFileSystem.New(
     SqlConnector.Caching(
          SqlProviderOracle.New(dataSource)
     )
);

EmbeddedStorage.start(fileSystem.ensureDirectoryPath("microstream_storage"));

PostgreSQL

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

<dependency>
       <groupId>one.microstream</groupId>
       <artifactId>filesystem.sql</artifactId>
       <version>04.01.00-MS-GA</version>
</dependency>
<dependency>
       <groupId>org.postgresql</groupId>
       <artifactId>postgresql</artifactId>
       <version>42.2.14</version>
</dependency>

PGSimpleDataSource dataSource = new PGSimpleDataSource();
dataSource.setUrl("jdbc:postgresql://localhost:5432/mydb");
dataSource.setUser("postgres");
dataSource.setPassword("secret");

SqlFileSystem fileSystem = SqlFileSystem.New(
     SqlConnector.Caching(
          SqlProviderPostgres.New(dataSource)
     )
);

EmbeddedStorage.start(fileSystem.ensureDirectoryPath("microstream_storage"));

SQLite

This is the manual for older MicroStream versions (Version < 5.0).

The new documentation (Version >= 5.0) is located at:

https://docs.microstream.one/

<dependency>
       <groupId>one.microstream</groupId>
       <artifactId>filesystem.sql</artifactId>
       <version>04.01.00-MS-GA</version>
</dependency>
<dependency>
       <groupId>org.xerial</groupId>
       <artifactId>sqlite-jdbc</artifactId>
       <version>3.32.3</version>
</dependency>

SQLiteDataSource dataSource = new SQLiteDataSource();
dataSource.setUrl("jdbc:sqlite:microstreamdb");

SqlFileSystem fileSystem = SqlFileSystem.New(
     SqlConnector.Caching(
          SqlProviderSqlite.New(dataSource)
     )
);

EmbeddedStorage.start(fileSystem.ensureDirectoryPath("microstream_storage"));