Regarding Strata Frame and CoreLab MySQL


Author
Message
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.
Chan
Chan
Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)Advanced StrataFrame User (965 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
hi,

Any update on mySQL datasourceitem?



Thank you
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
What file would I need to modify.

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.

Will the StrataFrame Business Mapper work the same way as for the MS SQL. 

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.

Mike Rogers
Mike Rogers
StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)
Group: Forum Members
Posts: 23, Visits: 723
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.

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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. 
Mike Rogers
Mike Rogers
StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)StrataFrame Beginner (47 reputation)
Group: Forum Members
Posts: 23, Visits: 723
I was wondering if anybody has used CoreLabs MySql control with StrataFrame.

Mike

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search