SQL
Declarative, relational. First appeared 1974; logic and declarative; data definition and query.
Record¶
| First appeared | 1974 |
|---|---|
| Family | Logic and declarative |
| Paradigm emphasis | Declarative, relational |
| Typing | Static, dialect-dependent |
| Memory | Engine-managed |
| Execution | Query planner |
| Primary domain | Data definition and query |
| Designers | Chamberlin and Boyce |
| Reference | https://www.iso.org/standard/76583.html |
| Last verified | not yet checked against its source by a human |
Dates are first public release or publication, not the start of internal development. Colour on the typing and memory tags encodes kind, never rank.
Influence¶
Within the Logic and declarative¶
Programs stated as relations or constraints, with the runtime searching for satisfying answers.
| Language | First appeared | Typing | Memory | Execution |
|---|---|---|---|---|
| Prolog | 1972 | Dynamic | Tracing GC | Interpreted or compiled |
1 other languages in this family, ordered by first appearance. SQL itself is omitted. Source: languages.json.