Hi Pierce,
I was my fault. I was not understanding properly the way of materialize
back the png/jpeg images. With Max's help in the Slack chat channel it
was clearer. Now is working properly and I have updated the database
query messages accordingly.
This combination of Fuel + SQLite seems very promising. For the moment
I'm using mostly Fuel with the same efficiency of SQLite for external
storage: 27 Mb both, the sqlite file and the fuel one, and almost the
same reading time and without the impedance of object object-relational
mapping. I imagine that the more we start to query the data, the more
we're going to rely on SQLite bindings.
Cheers,
Offray
On 04/07/16 22:51, Pierce Ng wrote:
On Sat, Jul 02, 2016 at 10:01:14PM -0500, Offray Vladimir Luna Cárdenas wrote:
I can read the blobs from SQLite. The problem is that they're stored
as FUEL inside SQLite and I don't know how to read them back to
recover the png/jpeg image that was serialized that way.
UDBCSQLite uses Fuel to serialize/materialize objects that aren't integers,
real numbers and strings. Sounds like you've hit a bug, whereby your png/jpg
files are serialized but aren't being materialized when read back, so you're
getting back raw byte arrays.
Can you provide simple schema and code fragment to reproduce the problem
please.
Pierce