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

Mike

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. 

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.

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,

Any update on mySQL datasourceitem?



Thank you

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 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

Forgot to mention, would you be willing to do a Poll to see how many current SF users would like to see support for MySQL?

Edhy Rijo

I wonder if another possible solution might be to create a plug-in architecture for the BO mapper, so users could add support for other databases/data sources. We can already add DataSourceItems, why not the same concept for the code that generates the designer files, either via an interface or a base class?



Just an idea....

I am very interested and in need of MySQL support too.

I agree with what Edhy said about SQL Express too.

If possible, I would VERY much like to use VistaDB (www.VistaDB.net) for the types of Visual FoxPro applications that Edhy is talking about.  I have over 350 VFP laptop users that I want/really need to convert to Strataframe and an SQL database but I don't really want to use SQL Express for all the same reasons Edhy mentioned.  I keep them in VFP for now but I have to bite the bullet and get them off VFP this year for sure.  I will use SQL Express though if necessary.

I am seriously considering using VistaDB because I think it is the ideal replacement for low-end clients like Edhy mentioned and extremely easy to install and maintain - much easier than a VFP client for that matter and it is pretty easy.  If not VistaDB than some other embedded SQL database.

VistaDB is really growing and improving all the time and is 100% MS SQL server compatible.  It is also very inexpensive and recommended by Les Pinter, etc.

Please put my vote in for MySQL Server and VistaDB.  I think others should check out VistaDB and let me know what they think too.

I have some big corporate clients this year who I will use SQL Express for but I hate the huge download size (300MB or more) and the complexities versus using VistaDB or VFP, etc.  I will make it work but and embedded SQL database engine like VistaDB is even better than VFP or SQL Server Express I think.

I would already be using VistaDB if I wasn't so extremely busy and under pressure to meet deadlines and just trying to survice as a startup with limited resources.

Thanks for your consideration.  I really love Strataframe and want to use it for 100% of everything I do.

Russ Brown (Using C#2010/SQL Server 2008)