I've done lots of research on the topic but I'm drawing a blank. Are their any database engines that can return rendered images in the query response?

For example:

Select images from fruit where type = "apple";

Would return rows of the apple type as rendered images, png, jpg, etc.

  • Not quite sure what you’re asking. If you store a binary picture in a binary field in a row, you’ll be able to retrieve it. I think you’re wondering if something cleverer could happen? That’s a no – Philᵀᴹ May 18 '19 at 23:19
  • Databases can't display anything. It is up to the Application on the Display Tier to render the Binary Larg OBject ( BLOB ) into an image. Oh, most apps like to have the MIME Type sent to them also. – Michael Kutz May 18 '19 at 23:28
  • Just looking for a way to skip the app layer but still write SQL. Something like what you can do with airtable.com/product but in a native SQL ide. Kind of an edge case request. – Matt D May 18 '19 at 23:34
  • You do realize what you linked is....an application – Michael Kutz May 19 '19 at 0:34
  • 2
    (I ment to edit that post) IDEs are applications too. It is up to the app/IDE to know to display a BLOB as an image. I believe "list of software" requests are "offtopic" but it is possible. thatjeffsmith.com/archive/2012/01/… – Michael Kutz May 19 '19 at 0:44

It is not up to the database engine to render an image or provide any visualisations - that work is performed by the client application receiving the data returned by the database engine.

What you want to look for is an IDE or query tool that has in-built visualisation capabilities. SSMS does not do this natively for SQL Server, but there are plug-ins and alternative tools that can do this (see this question).

For Oracle, SQL Developer is apparently capable of rendering BLOBs in the IDE. For other RDBMS you will need to research.

| improve this answer | |
  • Mini Sql query might be my best bet. Ultimately I think this will work for a prototype to see if it is worth doing a full app. – Matt D May 20 '19 at 10:08

Not the answer you're looking for? Browse other questions tagged or ask your own question.