[Mediawiki-l] direct SQL Queries example

Wed May 18 00:59:22 UTC 2005

Pablo,

I'm doing this against our MySQL and MS SQL servers via custom php
extensions.  It works well & is easily incorporated within the MediaWiki
interface so none of my users is the wiser.

Regarding your specific request - the comment at the top of the
specialasksql.php code suggests that it would only work for queries against
the cur table.
" * If enabled through $wgAllowSysopQueries = true, this class
 * let users with sysop right the possibility to make sql queries
 * against the cur table.
 * Heavy queries could slow down the database specially for the
 * biggest wikis."

Al.
-----Original Message-----
From: Pablo Chamorro C. [mailto:pchamorro at ingeominas.gov.co] 
Sent: Wednesday, 18 May 2005 12:44 p.m.
To: mediawiki-l at wikimedia.org
Subject: [Mediawiki-l] direct SQL Queries example

Could somebody please give me some details of how to do a direct SQL query?
I mean, can I use Media Wiki as a frontend for my MySQL databases? 
That would be great!  My wiki is on my intranet and for me a read only
access is ok.  If not, how could it be managed?

thanks,

Pablo Chamorro C.

---

"Direct SQL Queries

To allow SQL queries through the wiki's Special:Asksql page, you can enable
direct SQL queries via the web interface. ..."

--
Tel: +57 (2) 7314752/3222/2595 - Fax: +57 (2) 7310514 Carrera 31 #18-07
Parque Infantil - PO Box 1795 - Pasto
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l