Re: [Sedna-discussion] .png file

Tue, 13 Nov 2012 21:28:31 -0800 

> Thanks, Aris, I got answer from Konstantin.  It happens I have data in both 
> xml and png file.  I would like to use a single database.

> and insert the following XML fragment into sedna document:
> <image_base64>$data</image_base64> (for example)

You can use single database with this way, but since you don't about
the performance effect, you shouldn't use this way.

In your way, you treat image as an ordinary xml element. Sedna engine
will save this image along with another xml element data in the same
DISK block/sector, and this can affect the performance of
xquery/xpath, since all image must be load at the same time with
another xml element.

You should know, that MySQL blob datatype live in the different DISK
partition, not in the same location with another mysql datatype. So we
can save any big thing there.

On 11/14/12, Tak-po Li <[email protected]> wrote:
> Thanks, Aris, I got answer from Konstantin.  It happens I have data in both
> xml and png file.  I would like to use a single database.
>
> Tak
>
>
>
> ---------- Forwarded message ----------
> From: Konstantin Abakumov <[email protected]>
> Date: Tue, Nov 13, 2012 at 10:40 AM
> Subject: Re: [Sedna-discussion] .png file
> To: Tak-po Li <[email protected]>
>
>
> Hi!
>
> You can't do this straightforward, but you can use some tricks.
>
> For example, you can obtain base64 representation of the image file using
> built-in functions:
> http://php.net/manual/en/function.base64-encode.php
> http://php.net/manual/en/function.base64-decode.php
>
> like this:
> $data = base64_encode($image_file_contents);
>
> and insert the following XML fragment into sedna document:
> <image_base64>$data</image_base64> (for example)
>
> Hope this will help you!
>
> 2012/11/13 Tak-po Li <[email protected]>
>
>>
>> I am a new user of Sedna.  Could I store .png file into Sedna?  I use
>> php.
>>
>> Thanks,
>>
>> Tak
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor your physical, virtual and cloud infrastructure from a single
>> web console. Get in-depth insight into apps, servers, databases, vmware,
>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>> Pricing starts from $795 for 25 servers or applications!
>> http://p.sf.net/sfu/zoho_dev2dev_nov
>> _______________________________________________
>> Sedna-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>>
>
>
> --
> Best regards,
> Konstantin Abakumov,
> Sedna team
>

------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to