Yes, I have read that article first because it was supposed to be
exactly what I was looking for
but it was written for linux users focusing on how to build Virtuoso
with php etc. so
I had to improvise a little bit since I'm using windows.
After installing Virtuoso (that obviously comes with php dll) I've
uncommented few lines in virtuoso.ini to load php and it seems
to be working because I had php installed before with PATH variable
already set.
What's weird is that when I run phpInfo() inside Virtuoso web server,
php.ini path is empty/unknown, there is no MySQL section etc.
When I run that script in Apache web server everything is there?
So I'm not really sure whether I should have separate php installations
or just copy php installation
folder into Virtuoso hosting/php/ folder and then change php.ini or
there's a Virtuoso config file where I can
change the path to php.ini?
As I understood there are no RDF views and external data sources in open
source version of Virtuoso.
ODBC MySQL driver is what I'm looking for in the case of open source
version too?
This way Virtuoso will be a web server hosting php and connecting to
external MySQL?
When I say external I want to say a MySQL that is not a part of Virtuoso
like a plugin (or something integrated by default)?
Thank you for you time guys, especially you Hugh,
Luka
On 9.12.2010. 12:56, Hugh Williams wrote:
Hi Luka,
Have you read the following document on hosting PHP / LAMP
applications in Virtuoso:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoPHP
We also have migrated popular LAMP applications like phpBB,
WordPress, MediaWIki & Drupal to be completed hosted in Virtuoso as
detailed at:
http://ods.openlinksw.com/wiki/ODS/#Third-Party%20Platform%20Integration
In fact our phpBB3 support forum
(http://boards.openlinksw.com/support) is hosted entirely in Virtuoso
in the cloud ...
As you say the open source product does not support the creation of
RDF Views to remote relational data stores, so you essentially will
have to duplicate the MySQL data in Virtuoso either as pure RDF
triples or SQL data that is the mapped to RDF Views of the now local
SQL Data if you are to use it as a triple store for querying the data.
So you may as well host everything in Virtuoso if there is no physical
restriction on using MySQL and other LAMP components ( other then you
are a FAN :)), there will be a learning curve to get up speed with
Virtuoso but it will be worth it in the end as you have an all in one
solution making deployment ( and re-deployment) a simple process (just
copy binary, config & db file to new location) ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 9 Dec 2010, at 10:59, Luka wrote:
Hello everyone,
I am working on a web application that would try to leverage the use
of RDF data.
Since, I am PhP/MySQL fan I have some questions regarding the
organization of system.
I'm using the open source version of Virtuoso.
So, my application will be a CMS for a specific domain and I thought
that the part
of application that has to do with users login, ACL, static pages,
blog components etc.
should be stored the good old relational way in MySQL.
Since this CMS will have a component that will enable visitors
to browse a tree/list of products sold by a specific shop, I thought to
keep some relationships between products, producers, sellers,
shippers etc. in RDF format. I would
try to create a simple ontology for this domain.
My question is: how would you organize your project?
I thought of Installing
1. Apache with PHP,
2. MySQL and
3. Virtuoso
instead of hosting PHP directly in Virtuoso . [I am more comfortable
with Apache :)]
...I would build my CMS on PHP/MySQL stack and as for that specific
part where RDF
data would be used I thought I could map existing MySQL tables that
hold this information?
I read about RDF views but I'm not so sure that open source version
can import data from
external DBMS?
Do you think I should use RDF views (if even possible in o.s.
version) or I should
create a RDF quad store that would be a duplicate of what would
already exist in MySQL tables?
If you have any suggestions for reading (tutorials, manuals) please
do share it with me...
I am new to Virtuoso so please excuse me if I made a few mistakes in
terminology :)
Thank you very much.
Luka
------------------------------------------------------------------------------
This SF Dev2Dev email is sponsored by:
WikiLeaks The End of the Free Internet
http://p.sf.net/sfu/therealnews-com_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
