Question on XML/XSL/PHP/MySQL

Hypothetically say that I have MySQL with petabytes of data. I want to
use XSL as my template language. But in order to use XSL, I need to make
XML filled with petabytes of data. This does not sound elaborate way to
use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
this so that I can use XSL instead of Smarty?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Question on XML/XSL/PHP/MySQL

--=-X7h87XVqZQjQr3mT4nLJ
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Wed, 2010-01-27 at 03:31 -0800, Ryan Park wrote:

> Hypothetically say that I have MySQL with petabytes of data. I want to
> use XSL as my template language. But in order to use XSL, I need to make
> XML filled with petabytes of data. This does not sound elaborate way to
> use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
> this so that I can use XSL instead of Smarty?
>


I'm not really sure what you want to achieve here, as all of those
languages do quite different things! And I wouldn't ever recommend
having a single XML file with petabytes of data, that's just asking for
trouble!

Thanks,
Ash
http://www.ashleysheridan.co.uk



--=-X7h87XVqZQjQr3mT4nLJ--

Re: Question on XML/XSL/PHP/MySQL

--------------080607000302090406040109
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

My only reason doing this because I could use XSL as my templating
engine; achieve the separation of content, design, and code. But in
order to use XSL I need to use XML. XML needs to big if I want to use
the data from the huge MySQL database.

On 1/27/2010 3:32 AM, Ashley Sheridan wrote:
> On Wed, 2010-01-27 at 03:31 -0800, Ryan Park wrote:
>> Hypothetically say that I have MySQL with petabytes of data. I want to
>> use XSL as my template language. But in order to use XSL, I need to make
>> XML filled with petabytes of data. This does not sound elaborate way to
>> use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
>> this so that I can use XSL instead of Smarty?
>>
>>
>
> I'm not really sure what you want to achieve here, as all of those
> languages do quite different things! And I wouldn't ever recommend
> having a single XML file with petabytes of data, that's just asking
> for trouble!
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>

--------------080607000302090406040109--

Re: Question on XML/XSL/PHP/MySQL

--=-wgd1Vk1I0LRXD8jiCTxO
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Wed, 2010-01-27 at 03:39 -0800, Ryan Park wrote:

> My only reason doing this because I could use XSL as my templating
> engine; achieve the separation of content, design, and code. But in
> order to use XSL I need to use XML. XML needs to big if I want to use
> the data from the huge MySQL database.
>
> On 1/27/2010 3:32 AM, Ashley Sheridan wrote:
> > On Wed, 2010-01-27 at 03:31 -0800, Ryan Park wrote:
> >> Hypothetically say that I have MySQL with petabytes of data. I want to
> >> use XSL as my template language. But in order to use XSL, I need to make
> >> XML filled with petabytes of data. This does not sound elaborate way to
> >> use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
> >> this so that I can use XSL instead of Smarty?
> >>
> >>
> >
> > I'm not really sure what you want to achieve here, as all of those
> > languages do quite different things! And I wouldn't ever recommend
> > having a single XML file with petabytes of data, that's just asking
> > for trouble!
> >
> > Thanks,
> > Ash
> > http://www.ashleysheridan.co.uk
> >
> >


The XML need only be as big as the final output that your XSL creates.
What I would do is use PHP to do any of the server-side operations, like
connect to MySQL and arrange the data, and then have PHP output the XML.
You could then use XSL to output the XML into something else, such as
HTML, pdf, etc.

Thanks,
Ash
http://www.ashleysheridan.co.uk



--=-wgd1Vk1I0LRXD8jiCTxO--

Re: Question on XML/XSL/PHP/MySQL

Ryan Park wrote:
> Hypothetically say that I have MySQL with petabytes of data. I want to
> use XSL as my template language. But in order to use XSL, I need to
> make XML filled with petabytes of data. This does not sound elaborate
> way to use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a
> way around this so that I can use XSL instead of Smarty?
>
I doubt that the generated page depends on a petabyte of data but a
subset of that and thus you don't need to transform petabytes. Even if
you got the hardware for it any other coworker with a clue would kick
your ass, drag you out to the parking lot and change locks.
So if you got all this data in the DB you query for what you need and
then transform that into your XML-data and then transform that via XSLT.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Question on XML/XSL/PHP/MySQL

At 3:39 AM -0800 1/27/10, Ryan Park wrote:
>My only reason doing this because I could use XSL as my templating
>engine; achieve the separation of content, design, and code. But in
>order to use XSL I need to use XML. XML needs to big if I want to
>use the data from the huge MySQL database.
>
>On 1/27/2010 3:32 AM, Ashley Sheridan wrote:
>>On Wed, 2010-01-27 at 03:31 -0800, Ryan Park wrote:
>>>Hypothetically say that I have MySQL with petabytes of data. I want to
>>>use XSL as my template language. But in order to use XSL, I need to make
>>>XML filled with petabytes of data. This does not sound elaborate way to
>>>use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
>>>this so that I can use XSL instead of Smarty?
>>>
>>>
>>
>>I'm not really sure what you want to achieve here, as all of those
>>languages do quite different things! And I wouldn't ever recommend
>>having a single XML file with petabytes of data, that's just asking
>>for trouble!


I may be off the mark, but if you want to style data then use css. It
doesn't require your data to be in XML format.

Cheers,

tedd

--
-------
http://sperling.com http://ancientstones.com http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Question on XML/XSL/PHP/MySQL

Ryan Park wrote:
> Hypothetically say that I have MySQL with petabytes of data. I want to
> use XSL as my template language. But in order to use XSL, I need to make
> XML filled with petabytes of data. This does not sound elaborate way to
> use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around
> this so that I can use XSL instead of Smarty?

have you tried rdf serialized as xml and displayed w/ xslt?

you could also do it on the clientside (with xslt) obviously and palm
off the presentation to the client; or ecmascript over json encoded data.

still unsure why you'd want to display petabytes of data in one page
though; normally we'd use paging for this - at which point you take that
out of the equation and decision should be down to whether you want to
publish your (petabytes of) data as human readable data or as both human
and machine readable data. If the decision is both then look into rdf as
xml w/ xslt or as XHTML+RDFa for the smarty approach.

regards!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php