DPSQLStudio — Image BLOBs & Charts

When the data is a picture — or wants to be a chart

Two DPSQLStudio tools deal with data you’d rather see than read: the Image Viewer renders images stored in the database as BLOBs, and Chart turns a numeric result column into a bar chart. Both are in the Data menu and the results grid’s context menu. Screenshots are from the live app (v0.1.0 Beta) on Oracle as ADMIN@dpsqltest_high.

1. Viewing image BLOBs

The IMAGE_GALLERY table stores pictures in a PICTURE column. In the grid those cells just read [BLOB n bytes] — not much use on their own:

Double-click a BLOB cell (or use the column menu) and DPSQLStudio decodes and renders it in an Image Viewer window — sized to the image, with options to Save it to disk or Replace it from a file or the clipboard (which writes the new bytes straight back to the row).

This makes a database with image columns actually browsable — you can confirm what’s stored, export it, or update it without writing PL/SQL or a separate tool.

2. Charting a result column

For numbers, Data ▸ Chart plots a value column against a label column. Here it charts AMOUNT by PRODUCT_ID straight from the sales result — each bar is a product, instantly showing which ones dominate.

Because the chart renders to an image, it shares the same viewer plumbing as BLOBs — so you can Save it out, or even round-trip it back into an image column. It’s a fast way to eyeball a distribution without leaving the query.

Coming up

Next: working with JSON and XML columns, and the Generate INSERT tool that turns any result back into runnable SQL.

DPSQLStudio v0.1.0 (Beta) — a free Oracle SQL client for Windows. Screenshots are from the live app; demo data is fictional.

Comments (0)