News for hackers. Stuff that matters.
Re:SQL: 2023 Has Been Released by dmux on Thursday June 01, 2023 @04:29PM (#36156930)
SQLite does support auto-incrementing: https://www.sqlite.org/autoinc.html. Is your gripe with the lack of "GENERATED BY DEFAULT AS IDENTITY" syntax specifically?
Re:SQL: 2023 Has Been Released by jchw on Thursday June 01, 2023 @04:49PM (#36157129)
Yes, sorry. My gripe is that we don't have a single general way to say "I don't really care about the specifics, I just want a number that goes roughly upward" for all database engines. SQLite is interesting in that it supports at least two distinct sets of semantics for auto-incrementing rows, but neither of them are the standard syntax...
Re:SQL: 2023 Has Been Released by richardwhiuk on Thursday June 01, 2023 @04:51PM (#36157150)
The gripe is that there's not a standard say of defining this in SQL.

SQLite SQL != MySQL SQL != ISO SQL