Print Page | Close Window

Support for MySQL; want you ?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Suggestions
Forum Description: Do you have any ideas for applications or content on Web Wiz? Then leave your suggestions here.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14332
Printed Date: 29 March 2026 at 9:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Support for MySQL; want you ?
Posted By: RAVALON
Subject: Support for MySQL; want you ?
Date Posted: 20 March 2005 at 9:00am
Because of a big community and a low cost of MySQL...i think is a very good think if Web Wiz Forum run on MySQL DB....
 
I know it ask a conversion beacuse of a different func. and command for SQL statement....but i ask to all people that want a support for MySQL to vote here...
 
WE WOULD THIS FORUM ON MYSQL ? Yes or No ?
 
P.S. thanks thanks thanks thanks alwais to distribute Web Wiz Forum ...i know your efforts are big....so thanks from me however !



Replies:
Posted By: huwnet
Date Posted: 21 March 2005 at 8:06am
I have suggested this on the features for v.8 thread. However maybe a database abstratcion layer as this will make it easier.

The poll would have been better if it was just yes or no Wink


Posted By: dj air
Date Posted: 21 March 2005 at 8:32am
this has been talked over and over.

but with the ammount of time, differences, its not worth it, as there are plently more abd better PHP forums that run on My SQL.


with the time it would take to get a mySQL version up to the current and V8 standards, it would be at least a year or more and thats without developement on existing applications.


Posted By: RAVALON
Date Posted: 21 March 2005 at 9:35am

i understand you made more for us....

But...i repeat...i think this forum is a beatiful forum...and also if exist many others forum in the world which support MySQL, it could be a big thing to convert web wiz forum in MySQL...
 
Thank you...
 
 


Posted By: WebWiz-Bruce
Date Posted: 21 March 2005 at 12:56pm
There will not be a mySQL server version, unless a myODBC driver is released that fully supports ADO.

At the moment the myOBDC driver lacks so may of the features of ADO that nearly every file would have to be re-written to support mySQL which would also mean the forum engine wouldn't performance as fast and wouldn't be as secure.


-------------
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: RAVALON
Date Posted: 21 March 2005 at 2:15pm

i'm sorry....is not only SELECT and query to insert-modify-delete record to be changed for support mysql ?

maybe is my bad english...but i don't understand....if a person want to modify this forum into a MySQL version, what have to change sostantially ?
 
I would convert Access version in MySQL version...


Posted By: michael
Date Posted: 21 March 2005 at 3:24pm
The Access ODBC driver supports ADO so you can use recordset.update or recordset.delete. myODBC does not or not fully. So if you were to change the current access version to mySQL you would have to update just about every update query and every delete query that wwf uses. That would be quite a few.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 21 March 2005 at 3:35pm
is this the only change i have to make ? Michael...could you confirm this to me ?
 
If is only this i think i'll convert myself...so i will not give annoyance to you...
 
thank you for your answer....thank you to all..for now..Wink


Posted By: michael
Date Posted: 21 March 2005 at 5:42pm
I don't know if this is the only thing that needs changing, this is just the part of ADO. There is a possibility that other things need to be changed as well. Give it a try and see what errors it throws you when you made those changes. Should only be a couple hundred or so, so not too much work...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: michael
Date Posted: 21 March 2005 at 5:48pm
oh another thing you need to consider is dates in mySQL where it sucks big time. Maybe they changed it since but it used to screw up dates that have been inserted totally.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 22 March 2005 at 2:27pm
i know data format for MySQL...is not a problem....
Michael....thank you very much for your answers.....
 
I will try to convert myself...i find a tool to convert immediately Access DB into a MySQL DB...it works very good !
 
I develop a little test script to test performance, and as i read in some 3rd part publications, MySql have straordinary velocity performance
 
Thak you to all.....for answer and for patience..! Wink


Posted By: WebWiz-Bruce
Date Posted: 22 March 2005 at 2:42pm
Every page that uses ADO to update the database (about 40%) need to be changed to use SQL update queries, you will also need to add in security to prevent SQL injections etc. on these pages as ADO usually handles this.

All pages that use recordset paging will also need to be changed and completely re-written to use arrays, etc. instead. This would be quite a few of the forums main pages (about 30% of files).

Anything else that is not supported by mySQL and myODBC will also need updating.

Queries that use sub queries may also need updating, but later versions of mySQL may support this now.

Allot of other queries will need to also be changed as the database used is a relational database and mySQL is not a Relational Database Management System.

You may also find allot of other inconsistencies.

I did look at making an mySQL version once before but gave up after about 30 to 40 hours as it required a completely different code base which would be to costly to support along side the Access/SQL server version.

I estamemted to do it probably would take around 150 hours to complete, not including testing and debugging, and would require almost a total re-write of the forum engine file by file with almost every file needing to be re-written.


-------------
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: WebWiz-Bruce
Date Posted: 22 March 2005 at 2:48pm
Also if you did undertake this, you would only be able to use the code yourself as the Web Wiz Forums license agreement doesn't allow you to redistribute the code, even if it is modified.

Web Wiz Forums is NOT a GPL license and is not open source free software.

There are no planes to additionally support a mySQL version due to the complexities of having support and update 2 different code bases.


-------------
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: RAVALON
Date Posted: 22 March 2005 at 2:59pm
i understand....thank you for your explanation...
 
So you've abandoned this idea definitively ?


Posted By: RAVALON
Date Posted: 22 March 2005 at 4:04pm
ah....only a correction....MySQL is a relational database....maybe you're not documented in last version of this powerful db.Wink


Posted By: RAVALON
Date Posted: 22 March 2005 at 4:07pm
stay happy...i would translate this forum for support Mysql....but if i cannot redistribute, i don't redistribute....


Posted By: WebWiz-Bruce
Date Posted: 23 March 2005 at 5:44am
I've just checked the latest version of mySQL and it doesn't support relationships between tables so isn't a Relational Database Management System (RDMS), but is does now support sub queries.

Also it looks like the latest myODBC driver does support ADO updates, or to some extent. If so it should make using mySQL with Web Wiz Forums much simpler, so I may look again into making a mySQL version if the problems of the past have been overcome.


-------------
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: RAVALON
Date Posted: 23 March 2005 at 9:36am
good.....if you try to convert this forum to Mysql i will be very happy....
 
For relationship....i confirm again that Mysql support relationship....maybe i just created 3 tables relationed...using DB Tool manager you can simply add relation....control if you want...
 
i link a big italian site that expose a little description of Mysql where is wrote MySQL is a relational DB...
 
http://corsi.html.it/iCorsi/Scheda.aspx?tipo=A&idcorso=41 - http://corsi.html.it/iCorsi/Scheda.aspx?tipo=A&idcorso=41
 
or in egnlish for you....here
http://acs.ucsd.edu/info/mysql.php - http://acs.ucsd.edu/info/mysql.php
 
or here
http://onsol.com/mysql.html - http://onsol.com/mysql.html
 
...if you try a search with google...all link report MySQL is a relational DB
 
However...i like to remain in contact with you for know if in next future you will try to make this conversion....is it possible ?


Posted By: michael
Date Posted: 23 March 2005 at 12:33pm
I don't know if I'd call mySQL fully relational. You basically just fake out FK's by referncing foreign columns. Their way of saying it: "It works just fine" does not sound very confident to have robust relationship management, thus I guess it's still better then access.....

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 23 March 2005 at 2:22pm
the most interesting thing is mysql performance and capability for very low price on commercial server...
 
World community which develop MySQL add day after day new features
 
Some becnhmark developed by third part speack about mysql as the second DB in terms of speed...
look at this
http://www.mysql.com/it-resources/benchmarks/eweek.html - http://www.mysql.com/it-resources/benchmarks/eweek.html
 
in this graphic you can see how much better then SQL server is MySQL...SQL server is at last position...(i know is a good db but if this benchmark say true......beh...)
 
For this and for many others thing that i don't say because of no annoyance someone, i think is good thing make support for this forum
 
Ah...today i try to use ADO metod for add record....it run perfectly...and also subquery...i can confirm this...Wink


Posted By: RAVALON
Date Posted: 23 March 2005 at 2:26pm
for michael....it could be you are right to think this...i'm studing MySQL from 1 month ... i have not yet a perfect acquaintance of all MySQL world....


Posted By: michael
Date Posted: 23 March 2005 at 6:00pm
I think you are comparing apples with oranges. Sure under certain circumstances, mySQL can perform better. The advatage though of systems like MS SQL, Oracle and DB2 is that they are actually scalable. Frankly for a little forum DB, mySQL is generally fine.
I do not put any weight into benchmark test from e-week, who I think are just a bunch of laid off Admins, results I trust are i.e. tpc.org, oh wait mySQL does not participate, but yet they provide their own results.
To put this to an end, I am sure mySQL would be a good db for a forum in general and it may even outperform msSQL. Thus for me personally there are some downfalls to be using it for my application development, mostly because of the mySQL Dialect being inferior to T-SQL.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 23 March 2005 at 6:17pm
the benchmark is from third part....so....
maybe a compare apple with oranges...but surely you are downgrading MySQL capacity....
 
 


Posted By: michael
Date Posted: 23 March 2005 at 9:57pm
Well I am a third party so am I right no matter what? And like I said the benchmark was done by e-week who stinks.
 
Anyway. I am not "downgrading" it, it has it's place just not for me at this point.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: Mart
Date Posted: 24 March 2005 at 3:03am
If you look at how much 'slimmer' MySQL is compared to MSSQL feature wise there's no wonder it beat it in those benchmarks, but people at MySQL were saying themselves that when they add stored procedures MySQL will be quite a bit slower.


Posted By: WebWiz-Bruce
Date Posted: 24 March 2005 at 5:56am
Lets put it another way.
If my bank stores, and probably does, account details on a SQL Server, Oracle, or DB2 database I would be happy.

If they stored account details on a mySQL database, in the unlikely event it did manage to cope, I would be changing banks very fast.
mySQL is fine for small projects and beats Access hands down (Access does suck), but still has a long way to go to take on the big boys in the database world.

mySQL being a much smaller lightweight system, with allot of the features of the bigger database systems missing, can for smaller projects out perform the bigger databases systems.

I'm not saying never use mySQL as it does have it's place, and in the PHP world it is in common use as they work well together. However, when using ASP or ASP.NET most people tend to use MS SQL Server as they tend to work better together than using mySQL.

If web wiz forums was written in PHP then I would have mySQL as the primary database system.


-------------
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: WebWiz-Bruce
Date Posted: 24 March 2005 at 6:09am
In the eWeek tests that are mentioned I see that they only tested the databases with 1 application.

This isn't a very good way of testing, they should have used a much wider range of applications and then taken the average.

The Nile application they used may have been optimised for mySQL.

The test they done could be like testing an Athlon and against a Pentium but only test with video encoding. We all know that Athlons out perform Pentiums, but not when it comes to video encoding where the Pentium would out perform the Athlon.

A more fair test, and more accurate, would be to run the tests against a wider range of applications, and taking the average.


-------------
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: RAVALON
Date Posted: 24 March 2005 at 9:58am
thank borg for your answers...
 
I never say MySQL is best than SQL server....but only Mysql are becaming a good DB....
 
So...i wan't to offend noone of forum user...
 
I just report some data that i found in internet....
My interest is know if you think to make a support to MySQL to web wiz forum...all here...
 
I make excuses myself if someone has interpreted my speech like one critical


Posted By: WebWiz-Bruce
Date Posted: 24 March 2005 at 12:01pm
At the moment there won't be an mySQL version, but once I finsh writting the performance improvments for the forum engine, I will look at mySQL and if things have moved on eenough with mySQL that I can make mySQL work with web wiz forums without altering the code to much I will put in support for mySQL.

-------------
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: RAVALON
Date Posted: 24 March 2005 at 12:05pm
ok..i'll stay here waiting for...


Posted By: terrorkalle
Date Posted: 02 April 2005 at 11:05am
it cut be very very nice ... i need MySQL to run WebWiz ... My webservers runs: PHP, ASP, Apache & MySQL ... no Access or MSSQL ... so it cut be very nice to have MySQL


Posted By: WebWiz-Bruce
Date Posted: 02 April 2005 at 11:37am
Web Wiz Forums won't run on Apache web servers anyway.

It requires a Windows OS and IIS web server.

If you have a windows web server then you usually have support for Access and/or SQL Server.


-------------
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: Mart
Date Posted: 02 April 2005 at 12:27pm
I got web wiz forums to run on abyss web server (http://www.aprelium.com/) and that runs on Mac OSX, linux, windows and FreeBSD. I only tried it with the windows flavour but in theory it should work


Posted By: RAVALON
Date Posted: 02 April 2005 at 1:39pm
i hope Borg will look for a MySQL conversion....
 
 


Posted By: The WizeGuy
Date Posted: 16 April 2005 at 7:03am
I already have converted this WWF v7.9 to MySQL Big smile
 
It took me about 8 hrs to do, testing included in those hrs
 
cya,
/Patrik


Posted By: WebWiz-Bruce
Date Posted: 16 April 2005 at 9:07am
Could you then please tell me if the myODBC driver new supports things like updating using ADO?

What I am asking is, what are the main things that course incompatibility problems?

I know that the myODBC driver does support more parts of ADO since I last looked at it about 18 months ago. If it is now at a stage where web wiz forums can now support mySQL without to many changes to the main code base then it is something that I will look into adding support for.


-------------
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: 16 April 2005 at 11:02am
In some cases, ado-recordsets updates are supported ... but, I have changed almost every insert/update to real SQL-queries instead of using ado-recordset updates.
 
I'm not that "found of" ado-recordset updates, and have never been. I think the SQL-query updates/inserts is a much bettar approach ... ok, it is more open for SQL-injections than a recordset update.
 
Even ... it is not that much work to change Your code inteo "straight sql-inserts/updates". It has taken me about 8 hrs or soo ... not that much work as I thought it would take from the beginning (I had set a 50 hr limit)
 
/PatrikB
a.k.a MrWize


Posted By: WebWiz-Bruce
Date Posted: 16 April 2005 at 11:58am
mySQL not being able to handle ADO updates is where the problem lies with making Web Wiz Forums support mySQL.

It's not just the added security for things like SQL injections that ADO updates are used, but also for stability reasons.

Because Web Wiz Forums is used on may different servers in many different locales I find that by using SQL updates instead of ADO that you run into compatibility problems with dates and times. ADO updates are also used so that ID numbers and requires can be done to get any updated data.

Because of these reasons, as ADO updates are still NOT fully supported for mySQL, I will not be looking at making a version for mySQL. The biggest reason being that I can make the forum more stable using ADO thus saving me 1000's of hours of support.

Thnaks for looking into it for me.


-------------
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: 16 April 2005 at 12:30pm
I use almost ALL of Your recordsets to get "new" updated data .... I just don't use the .Update method of the recordset, instead I have created new queries and uses the adoCon.Execute queryName,,128 and then, You use the .Requery wich I also make use of to get the updated data Tongue
 
An example of how it can looks like:
 
'If this is a poll then clean read in the poll details
If strMode = "poll" AND blnPollCreate Then
 '********************************************
 '***      Save poll question    ***
 '********************************************
 If strDatabaseType = "MySQL" Then
  'Initalise the SQL string with a query to get the poll details
  strSQL = "SELECT " & strDbTable & "Poll.* FROM " & strDbTable & "Poll ORDER BY " & strDbTable & "Poll.Poll_ID DESC LIMIT 0,1;"
 Else
  'Initalise the SQL string with a query to get the poll details
  strSQL = "SELECT TOP 1 " & strDbTable & "Poll.* FROM " & strDbTable & "Poll ORDER BY " & strDbTable & "Poll.Poll_ID DESC;"
 End If
 With rsCommon
  .CursorLocation = 3
  
  'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
  .CursorType = 2
  'Set the Lock Type for the records so that the record set is only locked when it is updated
  .LockType = 3
  'Open the author table
  .Open strSQL, adoCon
  'Insert the new poll question in the recordset
  '.AddNew
  'Update recordset
  '.Fields("Poll_question") = strPollQuestion
  '.Fields("Multiple_votes") = blnMultipleVotes
  '.Fields("Reply") = blnPollReply
  'Update the database with the new poll question
  '.Update
  strSQLCreatePoll = "INSERT INTO " & strDbTable & "Poll(Poll_question, Multiple_votes, Reply) VALUES(" & _
   "'" & formatSQLInput(strPollQuestion) & "'," & IIF(CBool(blnMultipleVotes), 1, 0) & "," & _
   IIF(CBool(blnPollReply), 1, 0) & ")"
  
  adoCon.Execute strSQLCreatePoll,,128
  
  'Re-run the Query once the database has been updated
  .Requery
  'Read in the new topic's ID number
  lngPollID = CLng(rsCommon("Poll_ID"))
  'Clean up
  .Close
 End With
Hope You get som ideas
 
/Patrik


Posted By: RAVALON
Date Posted: 16 April 2005 at 1:52pm
i try to use UPDATE method in MySQL and RUN perfectly.....are you sure cannot be use ?


Posted By: The WizeGuy
Date Posted: 16 April 2005 at 7:38pm
Sometimes it does, sometimes it don't.
 
It depends ON how You are using the created recordset.
In this forum, the recordset is usally used several times before the actual .Update recordset function is run.
 
When I (my testers) are done and we have released the forum to the public, on our site, I will post a link to the actual forum. Unfortunatelly it is in Swedish and will be runned on a forum with approx 3 - 4000 unique IP-numbers per day Big smile, approx >200 posts per day (today, the active forums database is holding about 110 000 posts).
 
Several bugs have been found today and fixed ... many functions to go through.
 
Keep You updated on the progress Wink
 
cya,
/PatrikB


Posted By: RAVALON
Date Posted: 17 April 2005 at 5:47am
SO.....
you say the conversion take about 8 Hrs.....
 
technically which are the changes that we need to bring ? We have only to change SQL select string ?


Posted By: The WizeGuy
Date Posted: 17 April 2005 at 8:09am
it took me about 8 hrs to add sql-inserts/updates and execute them through the connection-object instead. And, to get the Paging to work You have to add the recordset-property: .CursorLocation = 3 to every recordset that is Using paging or .Recordcount ...
MySQL Drivers NEED! to have a Client Side Cursor (.CursorLocation = 3) 
I have now put in a couple of more hrs due to a couple of bugs that my testers has found .... but, now it seems to be pretty stable with MySQL. As soon it is stable for atleast a weeks testing and no new bugs are found under that period I will tune it to perform better.
 
Actually, it performs pretty good on my home-server and with a database that contains about 100k of threads, about 50 meg in size .... no Indexes, except Primary keys, are added to the database.
To add new indexes I think I can get the forum to perform about 2 - 400% better Big smile
 
cya,
/PatrikB


Posted By: RAVALON
Date Posted: 17 April 2005 at 10:00am
ok....so we have to change sql-inserts/updates query only.... and change CursorLocation to value 3 for use paging property....
 
Which tool used for covnersion of table? I use DBManager Pro ....wonderful tool ...
 
maybe all this information could be useful for to make MySQL official conversion...
 
if it take no more of a week i think BORG could make an official conversion of this forum...so all people can use it without copyright problem...
 
Another thing TheWizeGuy....You say you think to add new indexes....what about ? You want to say add new indexes or you have to adjust indexes already exsisting ?


Posted By: The WizeGuy
Date Posted: 17 April 2005 at 5:19pm
I used MS Access to export all tabels with ODBC and the MySQL ODBC 3.51 Driver.
 
Another thing to change is all TOP 1 to LIMIT 0,1 ... MySQL don't understand the SQL-command TOP ...
 
I don't have any existing indexes in the database except for PrimaryKeys....so to get best performence from ANY database adding "relevant" indexes that matches the queries is a MUST! ... if there are any "performence issues" LOL
 
About the "official conversion" ... thats up to -boRg- ... I have My version already in production very, very soon Embarrassed....
 
Will work in Netherlands this next coming week and then in Finland the week after that .... so, in 2 weeks it should be up and running at http://www.vasterviksbk.nu - http://www.vasterviksbk.nu . One of Swedens largest sites about dogs (#2). We have had about 40k users the last 8 days ....
 
cya,
/PatrikB


Posted By: RAVALON
Date Posted: 17 April 2005 at 5:31pm
ok..tks for now ..... when your version will be stable, if you would contact me ....tks-.-.Embarrassed
 
i'll wait for BORG answer.....i would know his think.....


Posted By: The WizeGuy
Date Posted: 24 April 2005 at 9:09am

Hi,

Now the forum is up and running at http://www.kvallistan.nu/forumwwf/default.asp?menuindex=2 - Hundforumet
 
We "restarted" the forum because we have changed our rules/guidlines in the forum.
 
It is, as said before, a swedish dogforum, and one of the largest dog-communities in Sweden, actually #2 ...
 
cya,
/PatrikB
 
PS .. just need to re-design the complete site to the new look as shown in the forum .. DS


-------------
-- second place is the first looser --


Posted By: JohnKn
Date Posted: 24 April 2005 at 10:12am
Congratulations getting Web Wiz running against mySQL! I've love to see a performance comparison of it vs MS SQL


Posted By: RAVALON
Date Posted: 24 April 2005 at 10:37am
yeah....i think is a good think, also if is not the official conversion, is a first convertion in MySQL....
Do you think to distribute ?


Posted By: michael
Date Posted: 24 April 2005 at 10:43am
He would not be allowed to redistribute it, as Borg said.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 24 April 2005 at 12:59pm
ok....so we'll wait for official conversion...


Posted By: JohnKn
Date Posted: 24 April 2005 at 1:07pm
Maybe after he has a chance to review the code borg will make it available as an unsupported beta for people to try out if he doesn't want another code fork to keep track of.


Posted By: The WizeGuy
Date Posted: 24 April 2005 at 4:25pm
Well, the only thing I have to do is buy a Developer license instead of the commercial one my partner bought Big smile ... but, then I have to sell it for at least the fee -boRg- charge for his licenses
 
I'll wait and see how it will go ... but, I already have my copy LOL
 
cya,
/PatrikB


-------------
-- second place is the first looser --


Posted By: RAVALON
Date Posted: 24 April 2005 at 4:40pm

BORG what do you think ? Do you startde to study the convertion ?



Posted By: WebWiz-Bruce
Date Posted: 25 April 2005 at 4:06am
I will look into building a mySQL version when I have finshed re-writing the core of the code for version 8 and as long as the base code doesn't have to be changed to much to accomadate for mySQL I will make a version of web wiz forums for mySQL.

Sorry The Wizeguy, even with a Developer license you would not be permitted under the license agreement to redistribute a mySQL version of Web Wiz Forums.


-------------
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: RAVALON
Date Posted: 25 April 2005 at 5:12am
ok Borg....how much time do you think to need approximately ?


Posted By: The WizeGuy
Date Posted: 25 April 2005 at 5:36am
Ok BORG,
 
But ... if I "shadow it" into a portal-application, I can ... from the terms:
 
Quote When using the ‘Developer License’: -
You may not resell Web Wiz Guide programs for less than the listed ‘Commercial License’ per unit price on http://www.webwiz.net - http://www.webwiz.net for each copy, services excluded.
 
You may not use a domain, product or service name looking and/or sounding like ‘Web Wiz Guide’ and ‘Web Wiz’, or containing the wording, ‘Web Wiz’ or ‘Web Whiz’.
Your product may not be in direct competition with Web Wiz Guide programs or services.
 
A copy of this license must be supplied with any programs or works that derive whether in whole or part from this program.
 
If I do a portal app, wich I will do around this forum, I surely could "redist" my app with the converted forum ... or can't I?
 
cya,
/PatrikB


-------------
-- second place is the first looser --


Posted By: Mart
Date Posted: 25 April 2005 at 11:24am
Would he be allowed to 'donate' the MySQL changes to you under the forums license or even post it as a MOD?


Posted By: RAVALON
Date Posted: 08 May 2005 at 2:28pm
Borg...sorry,.....how much time do yuo think to need starting from today to develop MySQL version? I mean approximately...


Posted By: michael
Date Posted: 08 May 2005 at 4:00pm
Why do you keep asking Ravlon, he does not even have a time frame for V8 at this point as he said he will finish first. So after that it may take some time to rewrite the queries so you may be looking at
"Don't know yet" + 3 weeks = "Still don't know yet"
If its so freaking important, get a book and do it yourself.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 08 May 2005 at 4:20pm
michael...if i ask is only for know how much time wait and consider if develop myself is the best way....
 
 I am in a position to developing it alone also, if draft to only change the query but I did not want to go against the licence of the forum... so I have asked....
 
first you say we cannot develop and use different version of forum.....after you say i have to develop myself.....you have to decide.....and finally i think is not your problem if i ask something to antoherone.....


Posted By: michael
Date Posted: 08 May 2005 at 10:15pm
Noone ever said you cannot develop it for yourself. You just could not re-distribute it.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: RAVALON
Date Posted: 09 May 2005 at 9:39am
ok michael....if this is the only condition ok....i'll develop myself....thank you Wink


Posted By: velkymx
Date Posted: 25 May 2005 at 11:22am
What about MySQL 5? It is much closer in fuctionality to MSSQL.


Posted By: RAVALON
Date Posted: 25 May 2005 at 11:32am
mysql became every day more powerful.....BORG said he will look for a conversion not first end of the year..... so i think he could take in consideration the last version of MySQL
 
We have to wait or develop ourself for personal use....
i start from a week to develop a MySQL conversion...is not difficult....the problem is make compatible tabels in MySQL....and import data from Access...



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net