what field type can be used o reflect pg integer[] datatype

[keinagae]

Hi i have an existing database where we have a field with type integer[] what fiield can i use in edgy to reflect that?

[tarsil]

IntegerField?

[tarsil]

@devkral ?

[devkral]

me currently not, because JSONField is doing a great job and is more interoperable.
But I am open for a PR.

[YaBatman]

ARRAY is more reliable because it allows us to store only one type of data. For example, sqlalchemy.ARRAY(sqlalchemy.String) ensures that only strings are stored.

[devkral]

you can have this with pydantic too+it is portable ;)

https://docs.pydantic.dev/latest/concepts/validators/#field-validators

But yeah I put it on my list.

[devkral]

And you should see: sqlalchemy.ARRAY is highly db specific. All all-upper types are.