Offray, could you post a snippet of the code to serialize and materialize an object and insert it into the sqlite database, please? just what's needed in order to get the idea
thanks; On Wed, Jul 6, 2016 at 3:00 PM, Offray Vladimir Luna Cárdenas < offray.l...@mutabit.com> wrote: > 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 > > > > > -- Bernardo E.C. Sent from a cheap desktop computer in South America.
