Markdown Plus is probably the markdown editor with the MOST features. Besides CommonMark, GitHub flavored markdown, it also supports toc, superscript, footnote, task list, emoji, Font Awesome, Ionicons. Download free trial version.
![]()
Dear MySQL users,The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.8. This is a maintenance release for 1.3.x. It can be used for production environments.MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It’s been some time since I wrote and shared some of our updates with you.
My intention back then was to give you an update with every release — if only all my plans worked out! However we’ve now had 3 releases since last I shared an update with you so it’s time that I updated everyone on what we’ve been working on.All of our connectors (well except for ODBC) implement our new X DevAPI and so I’ll briefly go over these features and then break out some of the major connector specific features included. X DevAPIHandling of default schemaWe had some inconsistencies regarding how a default schema given on a connection string was handled by some of our connectors.
If a user gives a schema on the connection string — such as this – it was expected that myschema would be the default schema set on the session. This would mean that any SQL issued against that session would work against that schema. Not all connectors were handling this the correct way. Var session = mysqlx.getSession('mysqlx://localhost/myschema') Various API standardization effortsWith many of our releases we’ll included various API standardizing efforts. We are always comparing our connectors and trying to make sure that the “core” API is essentially the same among all of them.
When we see differences we schedule updates to correct those. Our goal is that if you understand the X DevAPI in one language then you can understand it in all the languages.
Prepared Statement supportWith 8.0.16 we released prepared statement support when working with our X DevAPI/Document Store connectors. The first thing you may notice is that there isn’t any specific API for accessing prepared statements. This fits in with our general philosophy of letting the connectors “do the right thing” for the user rather than force the user to always write code. In this case the connector will notice that you are executing a “preparable” query more than once and will automatically make use of prepared statements for you. As of right now there is no way to configure or adjust this behavior. You should see a significant performance improvement from 8.0.15 to 8.0.16 when doing something like a loop of inserts or updates.
Connection Pooling EnhancementsAn enhancement was included in 8.0.16 to improve our connection pooling by speeding how our connectors could “reset” the internal connection to the server. This is entirely an internal improvement. Developers will see this as a faster connection pool. Connection AttributesConnection attributes are a feature where you can pass in key value pairs when a connection is made.
These values will be stored in the server performance schema and can be queried later as a way of “profiling” your application. Think of it simply as “tagging” your connections. These values can be given when the pool is created or when old style sessions are opened.
![]()
Here is an example code snippet giving some connection attributes when opening an old-style session: var session = mysqlx.getSession('mysqlx://localhost/schema?connection-attributes=key1=value1,key2=value2') Connector specific FeaturesNow I’d like to make a quick list of some of the larger changes we made to our connectors that are.not. connected to the X DevAPI. These are not all of the changes in our connectors.
Each connector puts out a release announcement giving the entire change list with each release. Connector/CPP.
Support for MSVC 2017. Improved internal string handling. Improved our CMaked-based build system.
Connector/Python. Removed support for Django versions less then 1.11.
Connector/Net. Can now use SSL certificates in the PEM file formatAs always, we really appreciate your willingness to work with our products and look forward to your feedback.Posted in Tagged. It’s been a year since MySQL 8.0 became GA. A good time to look at what happened with MySQL Connector/Python over the last few years. Pypi presenceWhen we created our connector we knew hat providing it via PyPI was important and we used PyPI as distribution channel. Later was published, which changed how packages are hosted and we introduced the C Extension, which required re-working the packaging.
Dear MySQL users,MySQL Connector/ODBC 5.3.13, a new version of the ODBC driver for theMySQL database management system, has been released.The available downloads include both a Unicode driver and an ANSIdriver based on the same modern codebase. Please select the drivertype you need based on the type of your application – Unicode or ANSI.Server-side prepared statements are enabled by default. It is suitablefor use with any MySQL version from 5.6.This is the sixth release of the MySQL ODBC driver conforming to theODBC 3.8 specification. Dear MySQL users,MySQL Connector/J Version 8.0.16 is the GA release of the 8.0branch of MySQL Connector/J. It is suitable for use with MySQL Serverversions 8.0, 5.7 and 5.6. Dear MySQL users,MySQL Connector/ODBC 8.0.16 is a new version in the MySQL Connector/ODBC 8.0 series,the ODBC driver for the MySQL Server.The available downloads include both a Unicode driver and an ANSI driver based on thesame modern codebase. Please select the driver type you need based on the type of yourapplication – Unicode or ANSI.
Dear MySQL users,MySQL Connector/NET 8.0.16 is the fourth version to supportEntity Framework Core 2.1 and the sixth general availability releaseof MySQL Connector/NET to add support for the new X DevAPI, whichenables application developers to write code that combines thestrengths of the relational and document models using a modern,NoSQL-like syntax that does not assume previous experience writing traditional SQL.To learn more about how to write applications using the X DevAPI, see. For moreinformation about how the X DevAPI is implemented in Connector/NET, see.
NuGet packages provide functionality at a project level. To get thefull set of features available in Connector/NET such as availabilityin the GAC, integration with Visual Studio’s Entity Framework Designerand integration with MySQL for Visual Studio, installation throughthe MySQL Installer or the stand-alone MSI is required.Please note that the X DevAPI requires at least MySQL Server version8.0 or higher with the X Plugin enabled.
For general documentationabout how to get started using MySQL as a document store, see.To download MySQL Connector/NET 8.0.16, seeInstallation instructions can be found atChanges in MySQL Connector/NET 8.0.16 ( 2019-04-25, General Availability ). Functionality Added or Changed. Bugs FixedFunctionality Added or Changed. Document Store: Support was added for the - operator tobe used with JSON document paths in relationalstatements. For example:table.Select.Where('additionalinfo-$.hobbies = 'Reading');(Bug #29347028). Document Store: The performance for statements that areexecuted repeatedly (two or more times) is improved byusing server-side prepared statements for the second andsubsequent executions. This happens internally;applications need take no action and API behavior shouldbe the same as previously.
For statements that change,repreparation occurs as needed. Providing different datavalues or different OFFSET or LIMIT clause values doesnot count as a change. Instead, the new values are passedto a new invocation of the previously prepared statement. Document Store: Connector/NET now supports the ability tosend connection attributes (key-value pairs thatapplication programs can pass to the server at connecttime). Connector/NET defines a default set of attributes,which can be disabled or enabled. In addition,applications can specify attributes to be passed togetherwith the default attributes. The default behavior is tosend the default attribute set.The aggregate size of connection attribute data sent by aclient is limited by the value of theperformanceschemasessionconnectattrssize servervariable.
The total size of the data package should beless than the value of the server variable. For X DevAPIapplications, specify connection attributes as aconnection-attributes parameter in a connection string.For usage information, see Options for X Protocol Only.For general information about connection attributes, seePerformance Schema Connection Attribute Tables. Document Store: Connector/NET now has improved supportfor resetting sessions in connection pools.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |