SQL: Difference between revisions

From SweepMe! Wiki
Jump to navigation Jump to search
Line 23: Line 23:
* Link: https://www.sqlite.org/index.html
* Link: https://www.sqlite.org/index.html
* released by: Hipp, Wyrick & Company, Inc., (Hwaci)
* released by: Hipp, Wyrick & Company, Inc., (Hwaci)
* Comment:  no support for options 'user', 'password', 'server', 'driver' and 'schema'
 


=== Usage ===
=== Usage ===
Line 29: Line 29:
* To access your database, enter the path in the database field, e.g "C:\test.db".
* 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.
* 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 ==
== Modes ==

Revision as of 22:59, 6 December 2019

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

MariaDB

SQL Server

Usage

  • Options 'driver' and 'schema' are supported

SQLite


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 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.

Select and fetch data from a database