Hi Trent,



How realistic would it be to see SF support for MySQL?



I like MS-SQLExpress but being realistic it is by far much harder to support, install and maintain on customer's computers.



For big clients this may no be an issue, but for small clients and small projects it could be a real pain to automate the install of MS-SQL2008 Express, no to mention the hardware requirements for MS-SQL versus MySQL.



I have an application running on Visual FoxPro which I have been wanting to port to SF, but the customers using this application have very low end hardware, some of them with just 256 MB RAM and being honest the application does not requires more than that, but I have not make the final decision to port this application because SF (DDT/BOM/RBS) does not support MySQL which would be the best database for this project.



I understand that fully supporting MySQL would required some changes and a lot of test, but I also believe that if you market SF support for MySQL you would get more customers.

Edhy Rijo

Not yet...there is such little demand a number of other items are higher up on the list (i.e. DDT enhancements, new BO Mapper and BO Mapper enhancments, etc.).  We will still more than likely create one but to be honest, there are fewer and fewer demands (which were small to begin with) for MySQL.  I think that many developers have moved over to SQL Server Express.  However, we know that there are still developers who want to use MySQL and still have this on our list.

hi,

Any update on mySQL datasourceitem?



Thank you

This is not a quick answer really.  You would need to create a DataSourceItem that inherits from the DbDataSourceItem class.  The best thing would be to copy over the SqlDataSourceItem and start from there.  That would be the closest data source to MySQL.  Then you will just have to start tweaking it until it is ready for MySQL.

No.  You would have to connect using the OLEDB provider for the time being, which by the way, is also a way to talk to MySQL right now without creating a custom data source item.

Adding the native implementation into the BO Mapper like the DDT, SQL Server, Oracle, and DB2 will require a change by us to make this work. 

Like I said before, I think that it is likely that we will create a MySql data source item, but I cannot give you an exact date of when this will happen.

Hi Trent

I would like to convert one of our projects using MySql over to StrataFrame.  What file would I need to modify.  Also the next question is. Will the StrataFrame Business Mapper work the same way as for the MS SQL.  Just as a note the Core MySQL .net control works extremly well, and fast.   As you said for web, mysql is cheaper with the host providers.

At present we do not have a MySQL provider out of the box...however, this is actually a provider that we have been considering adding to the framework.  Ironically there is very little demand for MySQL since SQL Server 2005 Express was released.  Though this is still on our slate of potential providers to add to the framework out of the box.  Most developers going with SQL Server since it is generally a bit more stable and has better overall performance...but I know that there are still some web people out there that like to use MySQL. 

I was wondering if anybody has used CoreLabs MySql control with StrataFrame.

Mike