haven't researched too much yet, but kinda thinkin...
# randomc
Colton Idle
08/03/2023, 9:33 PMhaven't researched too much yet, but kinda thinking out loud. im Implementing a database for the first time in a while. still might go room or sqldelight. i want to have a column that accepts an enum. should i just make it a string or an int, or is there a way to actually have an enum in a sqlite db?
h
hfhbd
08/03/2023, 9:52 PMSome sql dialects support custom types, but afaik not sqlite.
c
Chris Fillmore
08/04/2023, 1:33 AMAsk in #C7KS458SJ
Chris Fillmore
08/04/2023, 1:33 AMThere was some recent update around value classes I think. Not sure about enums
s
Stefan Oltmann
08/04/2023, 5:41 AMI think there is no need for custom enum types.
I give all my enums a unique ID and save it as int with sqldelight.
Saving enum names as String removes the ability to rename them later.
And saving the ordinal is just an huge accident waiting to happen.
👍 2
c
Colton Idle
08/04/2023, 4:03 PMlooks like sqldelight has support for exactly this:
As a convenience the SQLDelight runtime includes afor storing an enum as String data.ColumnAdapter
https://cashapp.github.io/sqldelight/2.0.0-rc01/jvm_mysql/types/
Colton Idle
08/04/2023, 4:03 PMgoing to use that for now
v
Vaizin Nikita
08/07/2023, 3:36 PMRoom has support for enums too I think
Vaizin Nikita
08/07/2023, 3:36 PMBut yeah I'd use sqldelight in your place for other reasons
4 Views