Database System

About

A database is a type of system that stores its data in a table fashion and understands SQL statements.

You can:

• add/create/update database connections parameters
• perform perf operation on a SQL query
• perform operation on a table
• perform operation on a schema
• manage foreign keys (ie relation between tables)

Supported Relational Databases

For the supported database, Tabulify introduces a layer that:

• corrects the driver mistakes
• and/or implements the database SQL dialect

Sqlite

PostgreSQL

Oracle Database

MySql

SQL Server

Other databases

We support all relational databases that:

• provides a JDBC driver,
• supports ANSI SQL

The most controversial parts being:

• the data type provided by the database driver may be outdated
• the upsert sql statement:

insert into "howto"."d_category" ("cat_id", "cat_desc", "load_timestamp")
values (?, ?, ?)
on duplicate key update "load_timestamp" = values ("load_timestamp")

If you want a relational database that does not support this syntax, you can always:

• add the driver in the jars directory
• and use the other standard operations (ie sql query, insert, or update)

If you still want the upsert operation and or support for a third SQL database, contact us.

Type

Database may be categorized in 2 types