Databases have built-in features for this now. What the author is talking about ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		_elf on Aug 3, 2024 \| parent \| context \| favorite \| on: "We ran out of columns" Databases have built-in features for this now. What the author is talking about is a regular table. In reality, that wasn't too unusual to see because frameworks would use that technique because it's a lowest common denominator across RDMS.

ssdspoimdsjvv on Aug 3, 2024 [–]

Does SQLite have sequences yet?

immibis on Aug 4, 2024 | [–]

Sqlite only has automatically assigned row ID. You can type a column as "integer primary key" to make it an alias for the row ID, or use ROWID directly (not recommended for compatibility).

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact