Is it not possible to update an Object schema column once data have been added?

Options

This object is currently set to null. Initialize or disable nullability.

Is this expected behaviour?

When my table is empty, I can see the schema and edit it.

But, as soon as data is added, I get this message, the schema is hidden away, and cannot be edited.

Tagged:

Answers

  • Ambroise
    Ambroise Member
    Options

    Damn, that's definitely a bug.

    https://watch.screencastify.com/v/X7UXB1rqxiYNLfMgbaAp

  • Ray Deck
    Ray Deck Trusted Xano Expert ✭✭✭
    Options

    I find the Xano object types to be often more trouble than they are worth, and fall back to JSON with some regularity. Object types are at their best when that internal data schema is known at the start and is stable. Otherwise they throw lots of errors when you're not using them just right. JSON requires you to manage data validation at the business logic level, but if you're using object types, you're already living a complicated life and owning this responsibility is a marginal cost.

  • Ambroise
    Ambroise Member
    Options

    Agreed, I haven't encountered the downside of Object type yet, I use them heavily for everything that must be strongly typed, and not for anything else.

    Beside the damn bug mentioned above, it's been a great ride with them so far.