SQL: Difference between revisions
Jump to navigation
Jump to search
(→Modes) |
|||
(11 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
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 | 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 | ||
= | = Engines = | ||
Engines or database systems are provided by different companies and projects. The supported ones are listed below. Contact us if you need access to a database that is not yet implemented. | |||
== MySQL == | |||
* Link: https://www.mysql.com/ | * Link: https://www.mysql.com/ | ||
* | * released by: Oracle | ||
== MariaDB == | |||
* Link: https://mariadb.com/ | * Link: https://mariadb.com/ | ||
* | * released by: MariaDB Corporation Ab | ||
== | == SQL Server == | ||
* Link: https://www.microsoft.com/sql-server | * Link: https://www.microsoft.com/sql-server | ||
* | * released by: Microsoft | ||
* | |||
=== Usage === | |||
* Options 'driver' and 'schema' are supported | |||
== SQLite == | |||
* Link: https://www.sqlite.org/index.html | |||
* released by: Hipp, Wyrick & Company, Inc., (Hwaci) | |||
=== 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". | |||
* Do not alter properties of your database file. Otherwise your measurement might be aborted. | |||
* Options 'user', 'password', 'server', 'driver', and 'schema' are not supported. | |||
= Modes = | |||
There are basically two modes supported: You can add data | There are basically two modes supported: You can add data into an existing database or you can fetch data from a database. | ||
== Insert/add data to a database == | |||
* Database and Table must already exist. | * Database and Table must already exist. | ||
* Values for all columns of an existing table must be submitted. | * Values for all columns of an existing table must be submitted. | ||
== Select and fetch data from a database == | |||
* | * |
Revision as of 10:32, 3 December 2020
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
Engines
Engines or database systems are provided by different companies and projects. The supported ones are listed below. Contact us if you need access to a database that is not yet implemented.
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
Usage
- Options 'driver' and 'schema' are supported
SQLite
- Link: https://www.sqlite.org/index.html
- released by: Hipp, Wyrick & Company, Inc., (Hwaci)
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".
- Do not alter properties of your database file. Otherwise your measurement might be aborted.
- Options 'user', 'password', 'server', 'driver', and 'schema' are not supported.
Modes
There are basically two modes supported: You can add data into an existing database or you can fetch data from a database.
Insert/add data to a database
- Database and Table must already exist.
- Values for all columns of an existing table must be submitted.