SQL

Structured Query Language (SQL) is a database language that is used in relational database management system such MySQL, SQL Server, PostgreSQL, or SQLite. Further information can be found here: https://en.wikipedia.org/wiki/SQL

Supported engines

MySQL

• Link: https://www.mysql.com/
• released by: Oracle

MariaDB

• Link: https://mariadb.com/
• released by: MariaDB Corporation Ab

SQL Server

• Link: https://www.microsoft.com/sql-server
• released by: Microsoft
• Comment: supports options 'driver' and 'schema'

SQLite

• Link: https://www.sqlite.org/index.html
• released by: Hipp, Wyrick & Company, Inc., (Hwaci)
• Comment: no support for options 'user', 'password', 'server', 'driver' and 'schema'

Usage

SQLite databases can be created with tools such as https://sqlitebrowser.org/. To access your database, enter the path in the database field, e.g "C:\test.db".

Modes

There are basically two modes supported: You can add data to an existing database into or you can fetch data from an database.

Insert/add data to a database

• Database and Table must already exist.
• Values for all columns of an existing table must be submitted.