Database Discussion - Has anyone tryed to port WWF to MySQL?

Print Page | Close Window

Has anyone tryed to port WWF to MySQL?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7730
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Has anyone tryed to port WWF to MySQL?

Posted By: theSCIENTIST
Subject: Has anyone tryed to port WWF to MySQL?
Date Posted: 30 November 2003 at 6:53am

I would like to run WWF but with MySQL backend instead of my current Access DB, I know there are little differences in the SQL btw Access and MySQL, my questions are:

If I create the MySQL database with all tables and fields will it run? What problems am I expecting by doing so?

If the problems are too many, then it might be worth to rewrite the whole code from scratch with MySQL, that would result in a new forum project altogether.

Thx for any advice.

Replies:

Posted By: Gullanian
Date Posted: 30 November 2003 at 7:30am

You would need to re write a vast majority of the forum code, as the database it uses is a relational one, and mySQL doesnt support relational tables yet, but I hear it will soon

Posted By: WebWiz-Bruce
Date Posted: 30 November 2003 at 8:45am

You will need to re-write almost every file as many files use ADO recordset updates to update the database which help with security with SQL injections.

Many of the SQL quries will also need to be re-writen to support mySQL.

mySQL also doesn't support recordset paging so all files using this will also need to be re-writen.

You will have to write extra security code as well to prevent SQL injections.

I spent some 30 hours on this and gave up as I didn't even scratch the serface.

If you go ahead be prepared to spend a good month or so working on it (full-time), to get it working correctly.

As the license for web wiz forums dosn't allow the code to be redistiributed or re-engineered then you will be better starting from scratch with a completly different code base as this forum would not be able to be used as a code base for such a project.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: pmormr
Date Posted: 30 November 2003 at 9:37am

ouch... i think it would be easier just to buy SQL server

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: theSCIENTIST
Date Posted: 01 December 2003 at 1:16am

Thanks to everyone, specially to boRg (resistance is futile...) great stuff.

Yeah I though as much, my preliminary analizes revealed that indeed MySQL doesn't support recordsert paging, so I had to come with a complete new DB paging routine, fully working now, and that the ammount of work involved to change the code to be MySQL connectable is too much, not to mention the WWF licence issues.

I will indeed start from scratch a new forum project with MySQL backend and I'm considering not adding all features avail in WWF at the beggining it will be an application that will mature with time, but at least people will have a forum system with a reliable, fast and free backend.

MSSQL is way too expenssive and not avail on all hosts, not sure if WWF will work with MSDE 2000.

I'm still busy with other projects at the moment, but will inform you all on the progress of this new MySQL forums.

Thanks.

Posted By: WebWiz-Bruce
Date Posted: 01 December 2003 at 3:43am

Web Wiz Forums will work with MSDE 2000

The cost of MS SQL server is comming down in price and many hosts now offer MS SQL server with hosting packages that cost under $5 a month.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: The WizeGuy
Date Posted: 29 December 2003 at 12:38pm

MySQL does support RecordsetPaging but don�t support all Recordset (ADO) Features .... like .AddNew, or .AddNew you can use, but not update an existing post with .Update. It seems that myODBC lock the record for updates.

cya,

/PatrikB