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...

2
10 comments

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

 


1
Avatar
Yuriy Vinogradov

There is no such functionality, but you can create a feature request on our tracker.

0

I would also love to have it

0

I'm failed to preview image in db in value editor,  do you have any hint?

 

0

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.

0

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?


0

Chenshengkai could you specify you RDBMS, DataGrip version and provide sample DDL and DML to reproduce the issue?

0

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
);
​​​

0

Chenshengkai, I managed to reproduce the issue. We'll try to fix it in the nearest major release.

0

The issue is fixed and working version is available from DataGrip 2023.1 EAP 2 or in coming 2023.1 release

0

Please sign in to leave a comment.