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

Asking about capabilities of the DBeaver integration #206

Open
amotl opened this issue Dec 10, 2024 · 3 comments
Open

Asking about capabilities of the DBeaver integration #206

amotl opened this issue Dec 10, 2024 · 3 comments
Labels
question Further information is requested

Comments

@amotl
Copy link
Member

amotl commented Dec 10, 2024

Hi.

that #112 has been resolved is excellent news, thank you very much.

In this case, all what is left is to wrap up this patch for the documentation, demonstrating DBeaver with CrateDB >= 5.9.1 works well when using the vanilla pgJDBC driver? Wonderful!

May I ask if data I/O using all CrateDB special data types has been validated, or does this integration only provide basic support?

With kind regards,
Andreas.

/cc @hlcianfagna, @proddata

@amotl amotl added the question Further information is requested label Dec 10, 2024
@hlcianfagna
Copy link
Contributor

hlcianfagna commented Dec 11, 2024

May I ask if data I/O using all CrateDB special data types has been validated

Arrays --> recognised as such in reads, also work for inserts through the GUI (need to use curly brackets syntax {1,2} instead of [1,2])
Objects --> seen as string, ok to insert via GUI
geo_shape --> seen as string, ok to insert via GUI
geo_point --> seen as string, for insert through GUI need to use parentheses
float_vector --> seen as array on read, can be inserted through GUI with same considerations as arrays

@amotl
Copy link
Member Author

amotl commented Dec 12, 2024

That's excellent feedback, thanks. I think it will be good to document those details on the new page educating about DBeaver (crate/cratedb-guide#157), because it can help people to get started much easier.

NB: If you also know about such a list of caveats with DataGrip (crate/cratedb-guide#155), please let us know, for example by suggesting an improvement using the widget on the corresponding documentation page.

@amotl
Copy link
Member Author

amotl commented Dec 13, 2024

The proposal for the new page has been updated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants