Retrieving Base64 Images from SQL Databases

Consider just storing the bytes directly in your DB ("blob" aka "binary large object" or "byte array" column types). Most databases support this, your database will consume 25% less space, and you won't burn CPU cycles encoding and decoding base64 at every turn.

You can also dramatically improve Perspective performance in tables or repeating views containing images by not including data URLs in your tables/queries, but defer to a WebDev or a my free Blob Server module to supply src to image components. Those data URLs of yours are horribly inefficient.

Not an accident. There's was no clear information because it is not a good approach.

1 Like