Terminology - noresources/ns-php-sql GitHub Wiki

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, ...)
⚠️ **GitHub.com Fallback** ⚠️