Is there anyway to preview image on database view?
Answered
## current situation
User Table
- pictures column
- image url is saved in pictures column
## what I want to do
is there any way to show image preview?
I know Ctrl + Q shows some additional information... but...
Please sign in to leave a comment.
There is no such functionality, but you can create a feature request on our tracker.
I would also love to have it
If image is loaded to db one can see them (make sure Database | Data Editor and Viewer | Maximum number of bytes loaded per value is enough to cover image size).
But we still can't show preview for links, so follow the issue https://youtrack.jetbrains.com/issue/DBE-14767
I'm failed to preview image in db in value editor, do you have any hint?
Hi Chenshengkai
Can you please elaborate on your issue? What is the current behavior when you click on an image cell in the data viewer? Please provide a screenshot.
there was nothing changed in value window when I right click image cell and select "view image" item in data editor. I suspect the image should be previewed in value window, right?
Chenshengkai could you specify you RDBMS, DataGrip version and provide sample DDL and DML to reproduce the issue?
DBMS: PostgreSQL (ver. 12.6)
Case sensitivity: plain=lower, delimited=exact
Driver: PostgreSQL JDBC Driver (ver. 42.5.0, JDBC4.2)
Datagrip2022.3.3
create table t_image
(
id integer not null
constraint t_image_pk
primary key
constraint t_image_fk
references t_service,
pic_data bytea,
uuid varchar,
save_time information_schema.time_stamp,
download_time information_schema.time_stamp,
download_times integer default 0 not null
);
Chenshengkai, I managed to reproduce the issue. We'll try to fix it in the nearest major release.
The issue is fixed and working version is available from DataGrip 2023.1 EAP 2 or in coming 2023.1 release