When defining a table column with INTEGER PRIMARY KEY
in SQLite, it is an alias for the interal rowid
which basically is auto-generated each time a new row is inserted. When using kysely codegen with a defined sqlite column in a table like this, it will instead just generate the plain type (in this case number
). I have to explicitly use the AUTOINCREMENT
keyword in my table definition for the primary key and then the code will be generated correctly. That being said, autoincrement should not be used for reasons of being a bit more resource intensive (at least not for primary keys). I can provide examples if needed.
Otherwise, thank you for the great tool. Really love it saved me so much time already.
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
You're funding impactful open source efforts
You want to contribute to this effort
You want to get funding like this too