Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
While poking around WikiApiary, I came across links to WikiHiero that were highlighted with a warning, that when I moused over it that said the URIs of the form //www.mediawiki.org/wiki/Extension:WikiHiero are not allowed. One question: Why not? Also, I'm curious who the warning is intended for. The phrase not allowed seems prescriptive and I'm wondering where the prescriptions come from and who they're intended for. Mark. -- http://hexmode.com/ Imagination does not breed insanity. Exactly what does breed insanity is reason. Poets do not go mad; but chess-players do. -- G.K. Chesterson -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
That is Semantic MediaWiki throwing an error when setting the Has URL property [1] and failing validation to the URL data type. Protocol relative URL's are fine for links, but it's not a valid URL. I'll add some code to catch these and make them fully qualified. I'll have to guess so I'll just put http on them. Thanks for letting me know Mark! [1]: http://wikiapiary.com/wiki/Property:Has_URL Jamie Thingelstad ja...@thingelstad.com mobile: 612-810-3699 find me on AIM Twitter Facebook LinkedIn On May 10, 2013, at 9:22 AM, Mark A. Hershberger m...@everybody.org wrote: While poking around WikiApiary, I came across links to WikiHiero that were highlighted with a warning, that when I moused over it that said the URIs of the form //www.mediawiki.org/wiki/Extension:WikiHiero are not allowed. One question: Why not? Also, I'm curious who the warning is intended for. The phrase not allowed seems prescriptive and I'm wondering where the prescriptions come from and who they're intended for. Mark. -- http://hexmode.com/ Imagination does not breed insanity. Exactly what does breed insanity is reason. Poets do not go mad; but chess-players do. -- G.K. Chesterson -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
[SMW-devel] Switching database from mysql to Oracle or MsSQL
I sent this same question to wikitec...@lists.wikimedia.orgmailto:wikitec...@lists.wikimedia.org and got a positive response about core code. We have to switch our database from mysql to Oracle or msSql. We notice that there is a DatabaseOracle.php and DatabaseMssql.php in the db folder. Is Oracle or MsSQL supported well with the smw extensions? Below are our current versions: MediaWiki - 1.15.3 PHP 5.2.8 (cgi-fcgi) MySQL - 5.5.19 These are the main smw extensions that we use: Semantic Compound Queries 0.3.1 Semenatic Forms 2.3.2 Semenatic Internal Objects 0.6.7 Semantic Maps and Maps 0.7.7 Semantic Results Formats 1.5.3 We know we are not current with our version. We will be switching to whichever versions that works the best with Oracle or MsSQL. Could you also point me to documentation on the databases? Which would any of you recommend? MsSQL or Oracle. We have a little experience with both. Both should be available for us. Thanks, Mary Beebe Battelle - Charlottesville, VA Office: 434- 951-2149 **Confidentiality Notice** This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and/or otherwise exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, any disclosure, dissemination, distribution, copying or other use of this communication or its substance is prohibited. If you have received this communication in error, please return to the sender and delete from your computer system. -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
Hey, SMW currently does not support the mentioned databases, and I do not see this happen in the nearby future unless someone throws serious dev effort at it. Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. -- -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
Mary, It sounds like you don't have much of a choice about this decision, but… For fun, I did a quick graph of wikis that are NOT using mysql in WikiApiary. You can see it here. http://wikiapiary.com/wiki/Statistics/Database_types 31 out of 5,370 wikis use something other than MySQL, and 25 of those are Postgres. (Perhaps this is information that you could use to change this direction?) Bitnje Wiki is the only one that shows as using Oracle. http://wikiapiary.com/wiki/BitnjeWiki Just sharing as maybe you could reach out to them and see how their experience is. Jamie Thingelstad ja...@thingelstad.com mobile: 612-810-3699 find me on AIM Twitter Facebook LinkedIn On May 9, 2013, at 11:17 AM, Beebe, Mary J bee...@battelle.org wrote: I sent this same question to wikitec...@lists.wikimedia.org and got a positive response about core code. We have to switch our database from mysql to Oracle or msSql. We notice that there is a DatabaseOracle.php and DatabaseMssql.php in the db folder. Is Oracle or MsSQL supported well with the smw extensions? Below are our current versions: MediaWiki - 1.15.3 PHP 5.2.8 (cgi-fcgi) MySQL - 5.5.19 These are the main smw extensions that we use: Semantic Compound Queries 0.3.1 Semenatic Forms 2.3.2 Semenatic Internal Objects 0.6.7 Semantic Maps and Maps 0.7.7 Semantic Results Formats 1.5.3 We know we are not current with our version. We will be switching to whichever versions that works the best with Oracle or MsSQL. Could you also point me to documentation on the databases? Which would any of you recommend? MsSQL or Oracle. We have a little experience with both. Both should be available for us. Thanks, Mary Beebe Battelle - Charlottesville, VA Office: 434- 951-2149 **Confidentiality Notice** This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and/or otherwise exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, any disclosure, dissemination, distribution, copying or other use of this communication or its substance is prohibited. If you have received this communication in error, please return to the sender and delete from your computer system. -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
On Thu 09 May 2013 09:12:26 PM EDT, Jamie Thingelstad wrote: 31 out of 5,370 wikis use something other than MySQL, and 25 of those are Postgres. And one of those uses None. That would be interesting. -- http://hexmode.com/ Imagination does not breed insanity. Exactly what does breed insanity is reason. Poets do not go mad; but chess-players do. -- G.K. Chesterson -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] Switching database from mysql to Oracle or MsSQL
That made me curious too Mark. :-) Had to check. http://wikiapiary.com/wiki/DGBC_Wiki Reports none. And just to make sure I don't have a bug http://www.wiki.dgbc.nl/api.php?action=querymeta=siteinfosiprop=generalformat=json Reports null. I should probably catch null and just not report anything. (The None is Python's interpretation of the null). Funny though, since the version is still reported and gives away that it's MySQL. :-) Jamie Thingelstad ja...@thingelstad.com mobile: 612-810-3699 find me on AIM Twitter Facebook LinkedIn On May 9, 2013, at 8:19 PM, Mark A. Hershberger m...@everybody.org wrote: On Thu 09 May 2013 09:12:26 PM EDT, Jamie Thingelstad wrote: 31 out of 5,370 wikis use something other than MySQL, and 25 of those are Postgres. And one of those uses None. That would be interesting. -- http://hexmode.com/ Imagination does not breed insanity. Exactly what does breed insanity is reason. Poets do not go mad; but chess-players do. -- G.K. Chesterson -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
