On Sun, Apr 13, 2025 at 9:24 AM Patrick McFadin <pmcfa...@gmail.com> wrote:

> I'm loving all the syntax discussion lately. It's a good debate and
> essential for the project's future with a good developer experience.
>

+1


> On NULL. I've been asked this a million times by end users. Why is there
> no "NOT NULL" in the schema?
>

I would've expected this to be in billions by now ;)


> I'm in favor of the standard SQL syntax here because it's what users have
> been using forever:
> name       text NOT NULL
>

I hold a weak opinion on this. We don't have to necessarily align on to the
standard SQL syntax. In my experience, users subconsciously feel Cassandra
is a SQL database and try to design their schema to fit the traditional SQL
/ RDBMS design and then later are disappointed to find out it doesn't have
joins or foreign key constraints. But that's just my personal experience
working with users. However, I think we should strive for consistency and
if it aligns with SQL I have no issues with the syntax. Just sharing my
experience.


> On CHECK. Also in favor of making this a reserved word but in context.
> Namely, how Postgres SQL works. CHECK ( boolean_expression_on_column)
>

Making CHECK a reserved keyword may result in issues that Scott described.
It will present a substantial barrier for users to upgrade as applications
will have to be updated.

Thanks,

Dinesh

Reply via email to