[jifty-devel] question about binary encoding

Bart Bunting bart at bunting.net.au
Thu Mar 16 18:29:37 EST 2006


Hi,

I'm not sure how to get sqlite to show me the size of the binary blob.  What
I can tell you:

Initial file 648k
file retrieved before applying the |n escape suppression 1252
after |n 1196

Hope this gives you some ideas.

Bart


> -----Original Message-----
> From: jifty-devel-bounces at lists.jifty.org
> [mailto:jifty-devel-bounces at lists.jifty.org]On Behalf Of Jesse Vincent
> Sent: Friday, March 17, 2006 10:23 AM
> To: Nifty apps in a Jiffy
> Subject: Re: [jifty-devel] question about binary encoding
>
>
>
>
>
> On Fri, Mar 17, 2006 at 10:20:28AM +1100, Bart Bunting wrote:
> > Thanks!
> >
> > That helps a bit :).
> >
> > It has reduced the output size of the file but I'm still
> thinking that there
> > must be something happening on the upload side as the output
> file is almost
> > twice as big still.
>
> How big is it in the database?
>
>
> > Is it safe to simply shove binary data into the database
> (sqlite) in this
> > case?
>
> It _should_ be. But we're not doing it in our application and I have a
> scary feeling we might be doing a UTF8 transform.
>
> > Sorry for all the silly questions :).
>
> They're not at all silly. And I'm sorry for the software that's not yet
> magic enough.  ;)
>
> > Bart
> >
> > > -----Original Message-----
> > > From: jifty-devel-bounces at lists.jifty.org
> > > [mailto:jifty-devel-bounces at lists.jifty.org]On Behalf Of Alex Vandiver
> > > Sent: Friday, March 17, 2006 10:05 AM
> > > To: Nifty apps in a Jiffy
> > > Subject: Re: [jifty-devel] question about binary encoding
> > >
> > >
> > > On Fri, 2006-03-17 at 09:35 +1100, Bart Bunting wrote:
> > > > <% $record->image %> to display it.
> > > >
> > > > I'm guessing that this is being escaped as it goes through mason or
> > > > something?
> > >
> > > Mason html-escapes all stuff output through <% %> blocks by default.
> > > You can keep it from doing this by writing it as:
> > > <% $record->image |n %>
> > >
> > > See http://www.masonhq.com/docs/manual/Devel.html#escaping_expressions
> > > for more on Mason's escaping.
> > >  - Alex
> > > _______________________________________________
> > > jifty-devel mailing list
> > > jifty-devel at lists.jifty.org
> > > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
> > >
> >
> > _______________________________________________
> > jifty-devel mailing list
> > jifty-devel at lists.jifty.org
> > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
> >
>
> --
> _______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
>



More information about the jifty-devel mailing list