Remix.run Logo
bob1029 2 hours ago

> CQL is not a database management system: it neither stores nor updates data.

The same could be said for SQL. How does CQL differ from SQL? If I squint my eyes just a tiny amount, these ideas become really difficult to separate. I was always under the impression that the relational model is based upon many concepts studied in category theory. To my mind, all of the following things are overlapping parts of the exact same monster:

  Set theory
  Category theory
  Graph theory
  Type theory
  Discrete mathematics 
  Relational algebra
  Relational calculus
  Relational modeling
  An actual sql schema
js8 2 hours ago | parent [-]

> How does CQL differ from SQL?

SQL is like Java, CQL is like Haskell. SQL has been around and used in production. CQL is a research language, possibly cleaner foundation but YMMV.

The math fields you list are connected, but whether they are the same monster - again it's kinda like claiming all programming languages and implementations are the same (Turing-complete?) monster.

randomNumber7 2 hours ago | parent [-]

SQL is not an imperative programming language.

adrian_b 35 minutes ago | parent [-]

DROP TABLE ?

Most of SQL is not imperative, but it certainly also includes some imperative commands.

Inserting a new row into an existing table is an imperative command, which may be the most frequently used of the SQL features, in certain applications concerned with recording transactions.

Only the subset of SQL that is used for queries can be said to not be an imperative programming language.