English
| Previous 30 Newer Entries | Showing entries 31 to 60 of 196 | Next 30 Older Entries |
-0
Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.
I expect to see nothing but continued strength for Linux and
[Read more...]As you probably know, there were some problems using our connector in medium-trust level scenarios. Most hosting services provide MySQL access. Most of these hosting providers run their .NET web apps using medium trust. Prior to 6.5, our connector required the hosting provider to either run the application in full trust or to enable broad privileges like SocketPermission globally. Many hosting providers are unwilling to do that. So fully enabling our provider to run in a partial trust scenario was a strongly requested feature. The request was a very simple task: enable Connector/Net to work correctly in a medium-trust level environment when the library is installed in the GAC.
The implementation consisted of including the necessary security imperative asserts so the CLR allows our code to perform the operations where it needs
[Read more...]We have a new feature as part of the 6.5 release. There is a new class that you can use to restrict access to specific connection strings that you want to use in all the connections in applications that use MySQL databases.
The following example shows how you can use the MySQLClientPermission class to restrict access to a specific server name and a database, while allowing any value for the User Id and Password within the connection string:
[Read more...]MySqlClientPermission permission = new MySqlClientPermission(PermissionState.None);
permission.Add("server=localhost;database=test;", " user id=; password=;",
KeyRestrictionBehavior.AllowOnly);
permission.PermitOnly();
MySqlConnection myconn = new MySqlConnection();
myconn.ConnectionString =
+0
-0
Intellisense Support in Visual Studio
One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.
As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.
Let’s explore the set of features currently implemented as part of Intellisense support.
Note: For completion intellisense features to work a database connection must be properly configured, see images below
+0
-0
One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.
As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.
Since the release of the 5.6 Community MySQL Server there is support for the milliseconds value in Time, TimeStamp and DateTime types. You can find more information on this new feature at (http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html). Starting with version 6.5, Connector/Net fully supports milliseconds. This support does not affect compatibility with older versions of MySQL and it gives you the ability to use fractional seconds when combining Connector/Net 6.5 with MySQL Server 5.6 or later. Let's see how we should use it.
You can do this either using Connector/Net or using any MySQL client with a valid connection to your database.
For this case we're going to
[Read more...]
+3
-0
When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database. It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies. I know because I run one of those teams!
I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.
Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5. He's done work on developing a new parser for our product. [Read more...]
+0
-0
When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database. It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies. I know because I run one of those teams!
I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.
Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5. He's done work on developing a new parser for our [Read more...]
If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.
Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.
The session discusses:
[Read more...]MySQL Workbench 5.2.36 has been released. This release is part of an ongoing effort committed to improving the day to day usability of the product based on accumulated experience from tools such as MySQL Query Browser and input from user feedback.
This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are:
We have lately been talking about some upcoming features that we feel are important to MariaDB users, because the corresponding ones that will be provided with MySQL will be incompatible with MariaDB and closed source.
We’re happy to announce the following:
Stay tuned for more information
[Read more...]Not a big deal, but I just added a “Table of Contents” page to my blog to make finding older articles much easier.
I noticed most of my posts are quite lengthy, and it can take a bit of searching/clicking to find an older entry. So unless you happen to recall the ‘month/year’ it was published, which I don’t even remember that, then hopefully this will help.
Really simple, and looks just like this:
In the latest release of MySQL Workbench (5.2.35), we received a number of reports that some people upgrading over a previous installation ended up in not being able to launch MySQL Workbench afterwards, instead receiving an error such as Access to the path ‘C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc’ is denied. The cause for that seems to be a problem with access privileges on files that are created when Workbench is run. If you run into that problem, a possible workaround should be to start Workbench with elevated privileges one time. To do this, right-click the Workbench application icon in your startmenu and select “Run as administrator”. Please leave a comment whether this workaround solves the reported problem for you.
UPDATE: A new 5.2.35.1 msi package has been uploaded, which resolves this issue. You can download it from the
[Read more...]Microsoft: “more than half your Android devices are belong to us”. And more
# Microsoft claimed that more than half of the world’s ODM industry for Android and Chrome devices is now under license to Microsoft’s patent portfolio following its agreement with Compal Electronics.
# Hadapt expanded its board of directors and confirmed its $9.5m series A funding round.
# Appcelerator entered into an
[Read more...]This article is just a how-to for setting up Perl on Windows in order to use the perl scripts provided with MySQL, such as mysqldumpslow.pl or mysql_explain_log.pl.
Now, you might say there is a section on this topic in the MySQL manual, to which I’d agree. But, this was for ActiveState Perl 5.6. The latest ActiveState Perl is 5.12, so thoese instructions are a bit out-of-date. Also, there are some helpful “User Comments” on that same page, but again, those are slightly out-of-date in the ActiveState 5.12. So, I thought I’d just post the steps I took in order to set this up.
First, download and install ActivePerl. Click the “Download ActivePerl 5.12.4 for Windows” button (choose either 32-bit or 64-bit). You’ll be
[Read more...]This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.
Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...
And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!
This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.
Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...
And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!
The MySQL Developer Tools team is proud to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.35. This is the next maintenance release containing 29 bug fixes as well as new feature additions. We also updated the supported platforms to include most recent editions of Fedora and Ubuntu Linux.
MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method – available in the commercial MySQL server product – and the creation of user accounts utilizing this new authentication method.
For the PHP developers out there, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts.
A big “Thank You” again to everyone for the large amount of feedback and ideas we have received on how to further improve and extend MySQL Workbench. We are continuously working on improving the
[Read more...]| Previous 30 Newer Entries | Showing entries 31 to 60 of 196 | Next 30 Older Entries |
