Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add CRUD support for SQL array and JSON columns #202

Closed
aeberhart opened this issue Aug 4, 2022 · 0 comments
Closed

Add CRUD support for SQL array and JSON columns #202

aeberhart opened this issue Aug 4, 2022 · 0 comments
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@aeberhart
Copy link
Contributor

Postgres example:

CREATE TABLE sal_emp (
    name            text primary key,
    pay_by_quarter  integer[],
    schedule        text[][],
    json                jsonb
);

The UI works fine but we cannot edit the values.

ERROR: column "json" is of type jsonb but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 63

For arrays, we might be able to get the type info from JDBC and generate the JSON schema.
For JSONb, we could either "sense" the data or provide the schema

@aeberhart aeberhart self-assigned this Aug 16, 2022
@aeberhart aeberhart added the enhancement New feature or request label Aug 16, 2022
@aeberhart aeberhart added this to the 3.0 milestone Aug 16, 2022
@aeberhart aeberhart removed this from the 3.0 milestone Oct 13, 2022
@aeberhart aeberhart added this to the 4.0 milestone Jan 17, 2023
@aeberhart aeberhart removed this from the 4.0 milestone May 8, 2023
@aeberhart aeberhart added this to the 5.2 milestone May 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant