YAFLogo

suipor
  • suipor
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
Hi there, I'm new to Yaf. I wonder how to setup yaf so that it works with MySQL database. Unfortunately, we don't use MS SQL server here.

I couldn't find any info in the documentation. Appreciate if someone can help or point me to the right document.

Thanks!

Sponsor

squirrel
8 years ago
Unfortunately, MySQL is not supported. ASP.NET relies heavily on features of MS SQL Server (as they are designed to work hand in hand), and YAF has been tuned to meet those features. Without exploring your own data provider there may not be much option. MySQL does not offer some features that YAF uses and where those features are implemented, it would require an entire re-write of the data providers.

You may work with bbobb. He has written custom data providers in the past, and depending on your project needs and budget, he may be able to assist you in that aspect. I personally do not work with MySQL since I graduated from php land...


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
8 years ago
squirrel, you don't quite right in some details.

1. MySql really fits to YAF it can offer all features required. But there'are multiple problems. In some cases perfomance sucks because of complex queries, MySql is really a very primitive database, in some I use really tricky technics. It's unbelievable, but even Firebird fits fine with YAF:evil: .

2. Everyone who wants to use MySQL with a YAF legacy version can find

YAF v.5337 Simply find the changeset here

http://yafnet.codeplex.com/SourceControl/list/changesets 

and fit it together. But I will not support it or will make it for money. Unfortunatelly it cannot not be cheap.

3. I will not support MySql for newer YAF versions by various reasons. The most important is that it requires some special technics to get perfomance for large forums. By all the reasons there's a fork now called VZF on github. It will be supported by me in future.

4. YAF has ORMLight to access data in 2.0 RTW, everyone has option to write his own scripts.

http://www.nearforums.com/  is a MVC3 forum that supports MySql (at least it's declared).

It could be an option for small forums. But it's much more slow then YAF with mysql when it comes to scalability.

squirrel
8 years ago
Originally Posted by: bbobb 

squirrel, you don't quite right in some details.

1. MySql really fits to YAF it can offer all features required. But there'are multiple problems. In some cases perfomance sucks because of complex queries, MySql is really a very primitive database, in some I use really tricky technics. It's unbelievable, but even Firebird fits fine with YAF:evil: .

2. Everyone who wants to use MySQL with a YAF legacy version can find

YAF v.5337 Simply find the changeset here

http://yafnet.codeplex.com/SourceControl/list/changesets 

and fit it together. But I will not support it or will make it for money. Unfortunatelly it cannot not be cheap.

3. I will not support MySql for newer YAF versions by various reasons. The most important is that it requires some special technics to get perfomance for large forums. By all the reasons there's a fork now called VZF on github. It will be supported by me in future.

4. YAF has ORMLight to access data in 2.0 RTW, everyone has option to write his own scripts.

http://www.nearforums.com/  is a MVC3 forum that supports MySql (at least it's declared).

It could be an option for small forums. But it's much more slow then YAF with mysql when it comes to scalability.

Thank you for clarification! I knew if I pointed you out, I'd get the full details on it!


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
suipor
  • suipor
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
Thanks squirrel and bbobb! You both have provided me some valuable information here.

I'll go back and analyze the scoop of my project and will pick a solution that works best for us.

Thanks once again!