# Using Paintable Canvas to get Blob image from MySQL

**URL:** <https://forum.inductiveautomation.com/t/using-paintable-canvas-to-get-blob-image-from-mysql/79354>\
**Category:** Ignition\
**Tags:** vision, ignition81, scripting\
**Created:** [September 19, 2023, 4:56pm UTC](https://forum.inductiveautomation.com/t/using-paintable-canvas-to-get-blob-image-from-mysql/79354 "2023-09-19T16:56:59Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 19, 2023, 6:12pm UTC](https://forum.inductiveautomation.com/t/using-paintable-canvas-to-get-blob-image-from-mysql/79354/6 "2023-09-19T18:12:13Z")

</div>

Pssst! Don't run a query inside a repaint event! Run the query as a named query binding on a custom property. Then the repaint event can just read the bytes. (And draw nothing when no bytes are present.)

---

_[View the full topic](https://forum.inductiveautomation.com/t/using-paintable-canvas-to-get-blob-image-from-mysql/79354)._
