Tag: collation

Feed: Planet PostgreSQL. This idea came to me today from swills: stupid question, would it be possible to make the urls on freshports case insensitive? so that like https://www.freshports.org/x11/libx11 would go to https://www.freshports.org/x11/libX11 After confirming this was for manually typed URLs (as opposed to generated links), I started looking into it. This is what I found. In this post, we’re going to look at some old PHP database code and the PostgreSQL stored procedures behind them. I’ll show you the multi-line stored procedure now in use and how a single query will now do the same thing. This change isn’t ... Read More

Feed: Planet PostgreSQL. Unicode equivalenceUnicode is a complicated beast. One of its numerous peculiar features is that different sequences of codepoints can be equal. This is not the case in legacy encodings. In LATIN1, for instance, the only thing that is equal to ‘a’ is ‘a’ and the only thing that is equal to ‘ä’ is ‘ä’. In Unicode, however, characters with diacritic marks can often (depending on the particular character) be encoded in different ways: either as a precomposed character, as was done in legacy encodings such as LATIN1, or decomposed, consisting of the base character ‘a’ followed by ... Read More

Feed: Matillion. Author: Ashley Lozito; At Matillion, we design purpose-built ETL products for each cloud data warehouse we support. Our method provides users with a seamless experience, allowing them to utilize cloud data warehouse functionality from within Matillion ETL. For this reason, we are always updating our products to reflect the advancements made in cloud data warehouse technology. In Matillion ETL for Snowflake version 1.47, we have introduced a number of improvements and enhancements for our Snowflake users.   What’s new and improved in Matillion ETL for Snowflake? File pattern matching for external tables The CREATE [OR REPLACE] EXTERNAL TABLE statement ... Read More

Feed: Matillion. Author: Julie Polito; Check out our release video by Ed Thompson, CTO, for a guided tour of Matillion version 1.47. Want the very best Matillion ETL experience? Each new version of Matillion ETL is better than the last. Make sure you are on the latest version to take advantage of the new features, new components, and improvements. In this blog, find out about the new components, features, and improvements introduced in Matillion ETL v1.47.  New and Updated Data Source Components  Create Your Own Connector (New) We understand that your business has a growing number of data sources that ... Read More

Feed: Clustrix Blog. Author: Max Mether. MariaDB Enterprise Server is the key component of MariaDB Platform. The newest major release of MariaDB Enterprise Server 10.5 delivers increased performance and expanded capabilities including distributed SQL, improved analytics integration and management, and additional security features.Distributed SQL with Xpand The addition of the Xpand smart engine to MariaDB Platform makes it easy to elastically scale out with distributed SQL. Xpand tables are fully distributed and highly available. Distribute a single table or the entire database. Xpand tables can be joined with tables using other engines (e.g. ColumnStore) giving customers extreme flexibility. Xpand is ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.21 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.21 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.21 Release Notes. Here are the highlights. Enjoy! InnoDB Add config option to disable redo log globally (WL#13795) This work by Debarun Banerjee adds support for ... Read More

Feed: Planet PostgreSQL. SQL and especially PostgreSQL provide a nice set of general purpose data types you can use to model your data. However, what if you want to store fewer generic data? What if you want to have more advanced server side check constraints? The way to do that in SQL and in PostgreSQL in particular is to use CREATE DOMAIN.This blog will show you how to create useful new data types which are commonly needed in many applications.CREATE DOMAIN: color codesThe first example is about color codes. As you can see not every string is a valid color ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Can Case Comparison Be Controlled? Friday, June 26, 2020 Computer tasks are one of the most precise activities we do on a daily basis. Driving, cooking, walking, and reading are fairly imprecise compared to computer interaction. Computers represent symbols like "a" and "A" precisely and require external facilities to define relationships between them. This email thread makes a convincing argument that you usually want case-preserving, but less-precise case-insensitive behavior. Let's go ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Can Case Comparison Be Controlled? Friday, June 26, 2020 Computer tasks are one of the most precise activities we do on a daily basis. Driving, cooking, walking, and reading are fairly imprecise compared to computer interaction. Computers represent symbols like "a" and "A" precisely and require external facilities to define relationships between them. This email thread makes a convincing argument that you usually want case-preserving, but less-precise case-insensitive behavior. Let's go ... Read More

Feed: Planet PostgreSQL. This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity. Can Case Comparison Be Controlled? Friday, June 26, 2020 Computer tasks are one of the most precise activities we do on a daily basis. Driving, cooking, walking, and reading are fairly imprecise compared to computer interaction. Computers represent symbols like "a" and "A" precisely and require external facilities to define relationships between them. This email thread makes a convincing argument that you usually want case-preserving, but less-precise case-insensitive behavior. Let's go ... Read More