Content of item and context

[pfranck]

I would like to know if I can have the description of what I can get from item and from context so I can create the part around pgSQL adapter.

[denisgmurphy]

I too was looking for a way to see blob data in TablePlus (an open issue regarding displaying various mime encoded images in the TablePlus repo) when I found the Dump Table extension.

Can we get an option to dump data? I'm looking for something that matches WorkBench Data Export functionality so that I can see the data containing in blob fields. For example:

Here's the 'Copy Creation' from TablePlus:

CREATE TABLE demo(idvarchar(100) NOT NULL,file_namevarchar(255) NOT NULL,mime_typevarchar(255) NOT NULL,file_sizeint(11) NOT NULL,heightint(11) DEFAULT NULL,widthint(11) DEFAULT NULL,file_data mediumblob NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1

And here's MySQL WorkBench's Data Export of one record (with blob data truncated):

INSERT INTO demo VALUES ('demo','demo.png','image/png',5993,107,500,'�PNG\r\n\Z\n\0\0\0\rIHDR\0\0�\0\0\0k\0\0\0��p�\0\0\0tEXtSoftware\0Adobe ImageReadyq\\ ... truncated example data ... IEND�B�');`

[Abhiram98]

I'm trying to build my own table plus plugin and this would be really useful to me as well!