Question
Why Pega use BLOB?
Hi all,
Why Pega use BLOB data type?
What are the advantages & disadvantages of it?
and how can access the BLOB data externally?
***Updated by moderator: Lochan to update Categories***
Hi Chinmai,
Can i know more about why pega use BLOB instead of other data types?
except these 2 points.
1.They are compressed by PRPC for low storage overhead.
2.They can hold any amount of information since there are no physical limit constraints, such as maximum column lengths or page sizes.
There are a few ways to access the BLOB column of an object other than putting that object onto the clipboard:
- The BIX tool can be used to extract data from a Pega database, and put it either in a prepared target table, or into a flat file.
- The UDFs that are part of the installation (pr_read_from_stream) can be leveraged in a report definition. However, this creates performance overhead at the database level.
Hi Sahan,
For understanding of BLOB please check the below link:
https://pdn.pega.com/understanding-pzpvstream-blob-database-column
Please check the below link for understanding how to access the BLOB data externally:
https://pdn.pega.com/community/product-support/question/read-data-blob-column-external-db
Hope this helps.
- Chinmai Sravanthi.