Forum:Argh. MediaWiki on MS Sequel Server?

From Uncyclopedia, the content-free encyclopedia

Jump to: navigation, search
Forums: Index > Village Dump > Argh. MediaWiki on MS Sequel Server?
Note: This topic has been unedited for 1632 days. It is considered archived - the discussion is over. Do not add to unless it really needs a response.

OK, sorry to be serious. I'd like to try MediaWiki as the software for a project I'm working on (you thing you do so you can buy beer.) However, my dear and sweet and clenched-buttocks ISD people only want to allow MS Sequel Server. (Yes, I know MySQL is free, efficient, stable, unthreatening, free, free, and smells like spring violets. Don't talk to ME about it! MS Sequel is in the ISD comfort zone and I am not a network admin.)

So. Can I use a MS Sequel Server database instead of MySQL to set up a MediaWiki installation? I could find nothing relevant in a quick Google. I can go deeper, but I figured some you people are smarter than anyone else and can probably tell me. How about it? ----OEJ 20:03, 6 March 2008 (UTC)

AFAIK, it supports MySQL and PostgreSQL, but not MS SQL. You will either have to code one or find some sort of kludge or something that will allow you to do it. I don't think anyone has done it, simply because it's inconvenient and costs money, something that long bearded freelance programmers aren't going to normally do. ~ Tophatsig 6/03/2008 @ 21:17
This guy seems to have come quite far in his efforts to make it work with MSSQL. I dunno how well it works, but he seems to have got it running anyway. I believe the extra code you need is on here, along with the other changes required here. Another post there mentions you might want to run a PHP accelerator/optimiser too. Spang talk 21:46, 06 Mar 2008
Remember that the alignment of the dilithium crystals is critical. If they vary by more than .09 Spocktrons, you'll kill us all. Or, get stuffed in your locker. Sir Modusoperandi Boinc! 22:13, 6 March 2008 (UTC)
Best you can do is compare Wiki software to see which one supports MS-SQL Server. It may not be MediaWiki, but it may be some other Wiki software that supports MS-SQL Server. Twiki is one that uses flat file formats, so it doesn't need a database back end as it stores data to flat files. PHPWiki seems to support MS-SQL Server and other database formats. Good luck on your choice. --Lt. Sir Orion Blastar (talk) 00:54, 7 March 2008 (UTC)
...Wikis are thingies where I can change the words with my computer. It's great fun! Does that answer your question? - P.M., WotM, & GUN, Sir Led Balloon Baloon(Tick Tock) (Contribs) 01:01, Mar 7
/me tries to sound knowledgeable... They are not both ODBC? Guess not... MrN Icons-flag-gb HalIcon.png WhoreMrn.png Fork you! 01:04, Mar 7
Yeah and the Internet is where you push little buttons and things to get more information, and on the Internet are Wikis that you can change words with your computer. Most people just use a Word processor to change words, but Wikis allow your words to be shared with anyone on the Internet who can see it by pushing little buttons and things. --Lt. Sir Orion Blastar (talk) 03:18, 7 March 2008 (UTC)
Many thanks, Jocke Pirat. That blog was just what I needed. Orion Blastar, I had looked into some of these...I really like the features of the MediaWiki package. I didn't notice PHPWiki, have to look into that. Twiki looked like at first blush like it is shorter features than MediaWiki. Thanks for the ideas. Modus, the implementation will be on an endonet supplied with box-thrusters and oatmeal RAID arrays, so the warp drive will use musk-ox pr0n instead of dilithium. Musk-ox pr0n is even more warped than a drug-crazed Lt. Sulu. It may blow up the Earth, but Uncyclopedia will be unharmed. ----OEJ 01:14, 7 March 2008 (UTC) (ps: MrN9000, I think the rubby bit is where the PHP frontend tries to find database drivers and create the backend database -- it's not the data connectivity that kills, it's the automated DB setup and configuration in PHP.
Obviously. Sir Modusoperandi Boinc! 01:12, 7 March 2008 (UTC)
I didn't help really help. Spang gave you the link. I'll just say don't use PHPWiki. Unless you're running a terribly small operation that requires a flashback to the 90s, don't use it. The only three wiki systems in my experience even worth considering are MediaWiki, and if unable to install that, DokuWiki or TikiWiki. ~ Tophatsig 7/03/2008 @ 17:55
Isn't TikiWiki the one that Falwell thought was gay? Sir Modusoperandi Boinc! 05:24, 8 March 2008 (UTC)
YES, thank you Spang. After reading a bit further, I'm pretty sure neither I nor the IT people are going to jump around happily at the prospect of rewriting PHP and installing optimizers as described. I'm looking at PM Wiki now. It avoids the issue by using flat files, and has most of the features I am most interested in: strong page history, fine-grained access control, formatting for printed page, left-side menu bar. It seems to be missing a discussion page for each article though. My aim is a user-created operation-and-maintenance manual for a medium-sized industrial site. We may end up with contributors just creating documents in several different forms -- html, pdf, plain-text, Autocad drawings, whatever -- and creating a database to handle links and menu creation for the document pool. That keeps future options open because the content is stand-alone and can be later incorporated into another structure if desired. I think most Wiki systems would require a dump-to-html of some sort before that would be possible. (Granted, that is not exactly hard, especially with a flat-file system like Doku or PM Wiki.) Anyway. It is just as I suspected. Uncyclopedians are smarter than everyone else. Thanks again. ----OEJ 18:22, 7 March 2008 (UTC)
That's right. We is smartfulwiser than everywon else. -~~`~
If you want the ability to create html, pdf, plain text, RTF Word documents out of data in a database consider JasperReports it is a Java based open source alternative to Crystal Reports. It supports JDBC so basically it can use any database that has a JDBC wrapper. You can use the Java based iReport to create reports and the Jasper Reports server to serve reports on your IIS or Apache web server. --Lt. Sir Orion Blastar (talk) 02:38, 8 March 2008 (UTC)
Personal tools