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***
Pegasystems Inc.
IN
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.
virtusa
LK
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.
Pegasystems Inc.
US
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.