Want to deploy your JVM, Node.js and Go apps effortlessly to AWS? Try our service Boxfuse

solidDB

Versions

  • 6.5 and later

Default Driver

  • solid.jdbc.SolidDriver

Sql Script Syntax

  • Standard Sql syntax with statement delimiter ;
  • Triggers and procedures are enclosed in double quotation marks like 
    "CREATE TRIGGER ... END;"

Compatibility

  • DDL exported by 'soldd' command can be used unchanged in a Flyway migration.
  • Any Solid SQL script executed by Flyway, can be executed by the solidDB tools.

Example

/* Single line comment */
CREATE TABLE test_data (
  value VARCHAR(25) NOT NULL PRIMARY KEY
);

/*
Multi-line
comment
*/

-- Sql-style comment

-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');

"CREATE TRIGGER update_customer_address ON customers
  BEFORE INSERT REFERENCING NEW street AS new_street
  BEGIN
    UPDATE orders SET street = new_street WHERE customer_name = name;
  END;"

Limitations

  • Support for DDL transaction is only partly implemented inside solidDB, therefore best practice is to separate DDL and DML scripts for migration tasks

Sybase ASE