MongoDB provides a User Management Interface for performing a wide variety of user-related tasks. In addition to adding new users, the User Management Interface also allows database administrators (DBAs) to update existing users, such as to change password and grant or revoke roles. In today's blog, we'll explore how to create a new user using Navicat for MongoDB's User & Role Management facilities.
Sorting a list of English words is simple enough because they rely on alphabetical ordering. Sorting a set of German, or French words, with all of their accents, or Chinese with their different characters is a lot harder. Sorting rules are specified through locales, which determine how accents are sorted, in which order the characters are in, and how to do case-insensitive sorting.
In this series on Collation support in MongoDB, we've been learning how to specify collation in MongoDB using the Navicat for MongoDB GUI administration and development tool. Part I provided a brief introduction to the concept of collation, covered the fields that govern collation in MongoDB, as well as got into some of the specifics of the first three fields, namely Locale, Case Level, and Case First. Today's blog will describe the rest of the fields.
Collation involves a set of language-specific rules for string comparison, such as those for lettercase and accent marks. Your run of the mill sorting is fine for simple entries made up of alphanumeric characters, but once you include special characters, such as @, #, $, % (etc) and è, é, ê, ö (etc, etc), it becomes imperative that you specify your own collation.
In relational databases, a view is a searchable data subset that is defined by a query. Views are sometimes referred to as "virtual tables" because they don't store data, but can be queried just like tables. MongoDB recently introduced views in version 3.4. In today's blog, we'll learn how to create a view in MongoDB using Navicat for MongoDB GUI administration and development tool.
- 2019 (1)
- 2018 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- An Introduction to Database Events (Part 1)
- Manage MySQL Users in Navicat Premium - Part 4: The Privilege Manager tool (2)
- Manage MySQL Users in Navicat Premium - Part 4: The Privilege Manager tool
- Manage MySQL Users in Navicat Premium - Part 3: Configuring User Privileges
- Manage MySQL Users in Navicat Premium - Part 2: Creating a New User
- May (1)
- April (1)
- March (1)
- February (1)
- January (1)
- 2017 (1)
-
About Us
