haven't researched too much yet, but kinda thinking out loud. im Implementing a database for the fir...

# random

[Colton Idle]

haven'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?

[hfhbd]

Some sql dialects support custom types, but afaik not sqlite.

[Chris Fillmore]

Ask in #C7KS458SJ

[Chris Fillmore]

There was some recent update around value classes I think. Not sure about enums

[Stefan Oltmann]

I 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.

[Colton Idle]

looks like sqldelight has support for exactly this:

As a convenience the SQLDelight runtime includes a ColumnAdapter for storing an enum as String data.

https://cashapp.github.io/sqldelight/2.0.0-rc01/jvm_mysql/types/

[Colton Idle]

going to use that for now

[Vaizin Nikita]

Room has support for enums too I think

[Vaizin Nikita]

But yeah I'd use sqldelight in your place for other reasons