This adds support for the Pivotal's SqlFire database to Liquibase
SqlFire is an in-memory distributed SQL database. In the category of NewSQL databases, SQLFire delivers dynamic scalability and high performance for data-intensive modern applications.
SqlFire provides it's sql interface by using a port of Apache Derby.
Add the compiled jar to the Liquibase distribution's "lib" folder.
SqlFire reports its Database Product Name as "Apache Derby". The Priority for SqlFireDatabase has been set to PRIORITY_DATABASE and should be picked up before the DerbyDatabse implementation.
With SqlFire there are two layers where a Liquibase refactor may not be supported. As SqlFire uses Apache Derby as it's sql interface a method may not supported at the Apache Derby. It is also possible that the underlying SqlFire Database may not support certain features.
Generally the SqlFire features is a subset of those support by Apache Derby.
N=Not supported Y=Supported ?=Untried
| Liquibase Refactoring | Derby | SqlFire | Description |
|---|---|---|---|
| ADD AUTO INCREMENT | N | N | Not supported by Derby |
| ADD COLUMN | Y | Y | |
| ADD DEFAULT VALUE | Y | N | Column Modification not supported by SqlFire |
| ADD FOREIGN KEY CONSTRAINT | Y | ? | |
| ADD LOOKUP TABLE | Y | Y | |
| ADD NOT NULL CONSTRAINT | Y | N | Column Modification not supported by SqlFire |
| ADD PRIMARY KEY | Y | Y | |
| ADD UNIQUE CONSTRAINT | Y | Y | |
| ALTER SEQUENCE | N | N | Sequence not supported by Derby |
| CREATE INDEX | N | N | Sequence not supported by Derby |
| CREATE PROCEDURE | Y | Y | |
| CREATE SEQUENCE | N | N | Sequence not supported by Derby |
| CREATE TABLE | Y | Y | |
| CREATE VIEW | Y | Y | |
| CUSTOM CHANGE | Y | Y | |
| DELETE | Y | Y | |
| DROP ALL FOREIGN KEY CONSTRAINTS | Y | ? | |
| DROP COLUMN | Y | Y | |
| DROP DEFAULT VALUE | Y | N | Column Modification not supported by SqlFire |
| DROP FOREIGN KEY CONSTRAINT | Y | ? | |
| DROP INDEX | Y | Y | |
| DROP NOT NULL CONSTRAINT | Y | N | Column Modification not supported by SqlFire |
| DROP PRIMARY KEY | Y | Y | |
| DROP SEQUENCE | Y | Y | |
| DROP TABLE | Y | Y | |
| DROP UNIQUE CONSTRAINT | Y | Y | |
| DROP VIEW | Y | Y | |
| EMPTY | Y | Y | |
| EXECUTE COMMAND | Y | ? | |
| INSERT | Y | Y | |
| LOAD DATA | Y | ? | |
| LOAD UPDATE DATA | Y | ? | |
| MERGE COLUMNS | Y | N | Column Modification not supported by SqlFire |
| MODIFY DATA TYPE | Y | N | Column Modification not supported by SqlFire |
| RENAME COLUMN | Y | N | RENAME statement not yet implemented by SqlFire. |
| RENAME TABLE | Y | N | RENAME statement not yet implemented by SqlFire. |
| RENAME VIEW | N | N | RENAME statement not yet implemented by SqlFire. |
| SQL | Y | ? | |
| SQL FILE | Y | ? | |
| STOP | Y | Y | |
| TAG DATABASE | Y | Y | |
| UPDATE | Y | Y |