# Retrieving Image from DB and inserting into perspective table

**URL:** <https://forum.inductiveautomation.com/t/retrieving-image-from-db-and-inserting-into-perspective-table/55409>\
**Category:** Ignition\
**Tags:** ignition80, perspective, scripting\
**Created:** [January 26, 2022, 4:19pm UTC](https://forum.inductiveautomation.com/t/retrieving-image-from-db-and-inserting-into-perspective-table/55409 "2022-01-26T16:19:44Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [January 27, 2022, 10:46am UTC](https://forum.inductiveautomation.com/t/retrieving-image-from-db-and-inserting-into-perspective-table/55409/2 "2022-01-27T10:46:57Z")

</div>

> [@View Images from Database](https://forum.inductiveautomation.com/t/view-images-from-database/22626/5):
>
> convert it to base64 in the query with TO\_BASE64(ImageData).

are you also doing this? (tho it might be a different funciton in mssql)

How many images are you planning to store here and show in a table. How often will the user change said image?  
As it might be easier to store them in a file instead of a db. Which will also up the performace of the image loading

---

_[View the full topic](https://forum.inductiveautomation.com/t/retrieving-image-from-db-and-inserting-into-perspective-table/55409)._