Category : blob

Assume I want to store via sqlite3 a simple list of strings: my_list = [‘a’,’b’,’c’] or a python object with properties and methods. What I tried so far is to serialize (pickle) my_list, and the returned byte representation is b’x80x03]qx00(Xx01x00x00x00aqx01Xx01x00x00x00bqx02Xx01x00x00x00cqx03e.’. However, cannot be stored within a BLOB variable. Should I use a string variable instead, ..

Read more

I have a large XML file output from database with Blob fields for attached zip files. Example (sorry for long text output, I’ve selected the shortest one): <Attach><FileName>Protocols.zip</FileName><Type>zip</Type><Blob>UEsDBBQAAAAIAAEXolL0xX1/dggAAEEZAAA2AAAAj+Cu4q6qrqsgrqEgrq/gpaSlq6WtqKgg4+eg 4eKtqKquoiDiruCjrqIg/CA3MTA3MzguZG9j1Vlrb9vWGf4cA/4PZwU2t0ZIkbTkJLRlNHGaoUBr dHCGfaYkyuJCiRpF2fWKAbHdy4pmy5B2xVD0sluBAgMKx6lbxY4boL/g8C/sl+x530NSFEXfhn7Y kFjmeXnOe33ey5GXO1HXX5mdmZ1Z7rhOC0/LXTdyRCeK+pr7m6G3WV8NepHbi7S7231XNNWi/kLk vhlV6PCSaHaccOBG9WHU1q6/kLHoOV23/nO354ZOFITjk697zTAYBO1I/CoIW8I0xYttz4/c0G29 xKcjL/LdlR/+Jf8h/y4fyT/Lv8qP5UfyT/LrH46XK+ottg2ibfXwE02bnRGVeXEHyonbbtvreZEX 9AZivoIXL7dB1tpO052dufJWsuh6/rZ91+kEXWcJ5L7TCwauZtoW6bMoqmJB1PBZFZaoLv1OsV8n gdP8+/rrg2AtCLuOf1X4Xn7V8jbHS5LedcINr2cbzS5JVSutEURR0LV1wzDMfkQvyLma43sbPfvX w0HktbeJWplnutdrIQL2wqJ+vYbtZOMVtmrg/da1TUs3FJPKfImt8xUyhlW+S44cK6VFQT93OtEt 9DY6Ubm+C6mgZKvvtrOdOQOaUNYNM6sK2kO+7/VcreOyIMswfqriseFqjdB17mlOG8dtZzPwWvQm Z+n1VIHymDJ1S/FtBH6Lw8iWv+YNojec0NkInX4njdkEMecWNsvMZOVDoCnyXEGvLAIX16tj/j8H YvGMQMDpHatgnFUtQOcMlI3xnIeZqScpVJ4pZXlyUVRlup2ePwyiW0Fr+y7yMcXPeJ1kfUrIGV9m 5ylpk8v7U6zJ541ZU3lTVgdKUIigTNjwKpeUoiUptWCPIv+vWhU5Dd8lj7E1uRVZkS0vUYsv41Lm T310LFytMuG0/PGFp5EvVLsrlHv6G2EQBc3A53r/VtpdkjosjDST0tZUklnjEj52hoWDqs/k8XUz 9BwfRM56fS2IvKZ7EfnQNOmGtlJITHbBRAOi5uKRpiqksefJuFOyllXiTZk/aPeW14o69g2VPGcd TQ+/FkQDEbUEHW5gfHFDDa71nf7AtTHiqCdipl7awuy/KQaB77VEw3ea91Rza7W83gYstZpdBKDw SVs23RCuc/xkCBDozcqr0KOVWbA27DbcMAupGhionqi9uZ23nWgcerWPa9HUxlUv2iaGGRpqpCKr mTwV5pMMG6xcX8/6ap6LGndOzaQ8bM+Kg5qLEuSazJQrWSaT6vHF5E5zOnXoKp2iWHIK8HSUSMXn mQvSk3CbG/0I7VMwzhCfs6+QBeOewGb/YuhiNgx6Bas15ZlSd/8oZvf11aDb9aLIZUxNzrTnN+Qz 1DsrA3NS13CzuFiYL8hwHQnhRMPQTTlfYp5OMJi5JONFGl6KT3of4IkARaE4M1NgkyKA1pZG/8yi pxSYzC9OVDBYD/whwee8qnkFcH2ZBnKx7jbpAM+qE1nhdd0BaZtAweRaQWVNPeGmAGsgl9pgnglx tVMCbdA0utBV0qsdPSfXUjw2MHEJ3+lt1F9Z0365jv7eu1dv+ENXbGaP6ioLOaLpO4NBPWWu6P2E mt5+BJfCuqphgqXW56bvLsVJa25lubGyPMClMT0zdSuZPiK/iO/L7+Nd+b08ws+xwMdj+ngO+qH8 Bj/H+DmRIzkS8V78ntyPd7CdCHTgYHaGDmPzE1oJeAkKrCxXoEqlP2nfXPGSM7di6j/rNQb9pfyn /Jy57bOM7yCP+YuCmALvHi5i8BffwMkD44CQV+RXyg5WndSUf8OCpBzKpwJ3+BMlRh7HD0A6kKP4 PTJhabkRwg42iaJ+vkFWmUF/kSfx2+ykZ5DzLrg/hIvHFu3H7wi4FxpSJA7Hclbgi115FN+PP4h3 4w/k4fgMth+IjOuhAOM97ARzmAFzdCH/mYoUaTTZ/n3Yl8SU9EgDDeHy2yTU8AnUe5dXYE1aJUpA zEOdvDI7gy8/4DCcYSzYgvz8KUijeAcH4cWClx/RtiSKiEHq44TZZzj5jIKSumGfOZqMJCXvM6g+ ..

Read more