Remove autoincrement for SQLite #1856

Closed
opened 2026-03-13 09:08:42 -05:00 by GiteaMirror · 0 comments
Owner

Originally created by @pspeter3 on GitHub (Sep 5, 2025).

Is this suited for github?

  • Yes, this is suited for github

SQLite recommends not using Auto Increment for numeric IDs. Source

Describe the solution you'd like

Remove auto increment from the SQLite schema with the numeric ID option enabled.

Describe alternatives you've considered

Create an option to disable autoincrement so users can decide whether or not they want autoincrement.

Additional context

I'm unsure if other SQLite options such as creating strict tables should also use this configuration API.

Originally created by @pspeter3 on GitHub (Sep 5, 2025). ### Is this suited for github? - [x] Yes, this is suited for github ### Is your feature request related to a problem? Please describe. SQLite recommends **not** using Auto Increment for numeric IDs. [Source](https://www.sqlite.org/autoinc.html) ### Describe the solution you'd like Remove auto increment from the SQLite schema with the numeric ID option enabled. ### Describe alternatives you've considered Create an option to disable autoincrement so users can decide whether or not they want autoincrement. ### Additional context I'm unsure if other SQLite options such as creating [strict tables](https://www.sqlite.org/stricttables.html) should also use this configuration API.
GiteaMirror added the enhancement label 2026-03-13 09:08:42 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#1856