mfwgenerics / koala

SQL generation for Kotlin
https://mfwgenerics.github.io/koala/
MIT License
13 stars 4 forks source link

Add jsonb type #27

Closed eleleung closed 1 year ago

eleleung commented 1 year ago

I feel like I'm spamming a lot lol but would be nice to have support for Postgres' JSONB. Since we're not using Koala to manage the actual creation of the tables we just use JSON in the Koala table definitions while our Flyway definitions specify JSONB.

It didn't appear too difficult to add (see branch I'm playing with here but I could be missing something. This implementation meant I had to add JSONB awareness into the MySQL schema diff logic which also seems not ideal.

mfwgenerics commented 1 year ago

Now available as io.koalaql.postgres.ddl.JSONB