Skip to content
This repository was archived by the owner on Aug 11, 2022. It is now read-only.

Terminology

Renaud Guillard edited this page Feb 29, 2020 · 1 revision

Terminology

Data structure description

`DatasourceStructure`
A collection of namespaces and global elements
MySQL
A connection to a MySQL server
SQLite
A client session with one or more attached SQLite database file
PostgreSQL
A connection to a Postgres server on a given Postgres database
`NamespaceStructure`
The SQL object which holds a collection of tables, views, indexes, functions and triggers.
MySQL
A MySQL DATABASE or SCHEMA
SQLite
A SQLite file
PostgreSQL
A Postgres SCHEMA
`TableStructure`
A SQL table
`ColumnStructure`
DBMS independant table column description

Statements & results

Recordset
A set of row, result of a data query
Result column
Column appearing in a data query result (Recordset)

DBMS

Connection
A connection to a DBMS server
Platform
Interface between abstract API and DBMS connection

SQL syntax

Evaluable
Anything that can be interpreter by the Expression\Evaluator
  • A string representing a valid expression
  • An array representing a polish notation operation
  • Any basic type (float, int, bool, null, ...)
Clone this wiki locally