Tag: collation

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the XDevAPI. This release, v8.0.17, is a maintenance release of theMySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combinesthe strengths of the relational and document models using a modern,NoSQL-like syntax that does not assume previous experience writingtraditional SQL. MySQL Connector/Node.js can be downloaded through npm (seehttps://www.npmjs.com/package/@mysql/xdevapi for details) or fromhttps://dev.mysql.com/downloads/connector/nodejs/. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/.For more information about how the X DevAPI is implemented in MySQLConnector/Node.js, and its ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/NET 8.0.17 is the fifth version to support Entity Framework Core 2.1 and the sixth general availability release of MySQL Connector/NET to add support for the new X DevAPI, which enables application developers to write code that combines the strengths 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 http://dev.mysql.com/doc/x-devapi-userguide/en/index.html. For more information about how the X DevAPI is implemented in Connector/NET, see http://dev.mysql.com/doc/dev/connector-net. NuGet packages provide ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/C++ 8.0.17 is a new release version of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both C++ and plain C applications using X DevAPI and X DevAPI for C. It also supports the legacy API of Connector/C++ 1.1 based on JDBC4. To learn more about how to write applications using X DevAPI, see “X DevAPI User Guide” at https://dev.mysql.com/doc/x-devapi-userguide/en/See also “X DevAPI Reference” at https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.htmland “X DevAPI for C Reference” at ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 8.0.17 is the latest GA release version of the MySQL Connector Python 8.0 series. The X DevAPI enables application developers to write code that combines the strengths 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 http://dev.mysql.com/doc/x-devapi-userguide/en/For more information about how the X DevAPI is implemented in MySQL Connector/Python, and its usage, see http://dev.mysql.com/doc/dev/connector-pythonPlease note that the X DevAPI requires at least MySQL Server version 8.0 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/J 8.0.17 is the latest General Availability release of the MySQL Connector/J 8.0 series.  It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes the following new features and changes, also described in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-17.htmlAs always, we recommend that you check the “CHANGES” file in the download archive to be aware of changes in behavior that might affect your application. To download MySQL Connector/J 8.0.17 GA, see the “Generally ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.17 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.17 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.17 Release Notes. Here are the highlights. Enjoy! Provisioning by Cloning We have implemented native provisioning in the server. For example, a newly created, thus empty ... Read More

Feed: Planet PostgreSQL. Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection.In this article, we’re going to tackle the referential integrity improvement first. This will provide some sample data to use later for the other explanations. And the feature is just amazingly cool, so it goes first anyway. This example builds on the example given for the Generated columns in PostgreSQL 12 article, where we built a ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2019As announced by the glibc mailing list and discussed by Daniel Vérité, version 2.28 of the GNU C library will ship with many changes to the collations.PostgreSQL uses the operating system’s collations by default. When this version hits your Linux operating system as part of a routine bugfix upgrade, and you don’t use the “C” or “POSIX” collation, you stand a good chance that some indexes on strings will become corrupted.Since version 10, PostgreSQL does not only support “libc collations” but also “ICU collations” which are not affected by this particular problem. This article ... Read More

Feed: Planet PostgreSQL. The data warehousing community will be happy to know that PostgreSQL now has a feature to generate columns based on data in other columns.This feature is known in various other DBMS as “calculated columns”, “virtual columns”, or “generated columns”. PostgreSQL picked the moniker “generated”. We’ll go with that for now, and discuss later why that may not have been the most future-proof naming. This feature allows PostgreSQL to calculate columns based on given input columns. In the current implementation, the values are generated at INSERT/UPDATE time, and stored physically with the rest of the table data. A ... Read More

Feed: Microsoft Azure Blog. Author: Tim Sander. This blog was co-authored by Shweta Mishra, Senior Solutions Architect, CitiusTech and Vinil Menon, Chief Technology Officer, CitiusTech CitiusTech is a specialist provider of healthcare technology services which helps its customers to accelerate innovation in healthcare. CitiusTech used Azure Cosmos DB to simplify the real-time collection and movement of healthcare data from variety of sources in a secured manner. With the proliferation of patient information from established and current sources, accompanied with scrupulous regulations, healthcare systems today are gradually shifting towards near real-time data integration. To realize such performance, healthcare systems not only ... Read More