Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (167)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Category: DBMS

Database Management Systems

MongoDB $bsonSize

Posted on February 3, 2021February 3, 2021 by Ian

From MongoDB 4.4, you can use the $bsonSize aggregation pipeline operator to return the size of a given document in bytes.

$bsonSize accepts any valid expression as long as it resolves to either an object or null. 

Continue reading →
MongoDB aggregation, operators, what is

MongoDB Object.bsonSize()

Posted on February 3, 2021February 3, 2021 by Ian

In MongoDB, you can use the Object.bsonSize() method to return the size of a document in bytes.

Continue reading →
MongoDB methods, what is

MongoDB $binarySize

Posted on February 3, 2021February 3, 2021 by Ian

From MongoDB 4.4, you can use the $binarySize aggregation pipeline operator to return the size of a given string or binary data value’s content in bytes.

It accepts any valid expression as long as it resolves to either a string or binary data value. The argument can also be null, in which case, $binarySize returns null.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $type Query Operator

Posted on February 2, 2021February 2, 2021 by Ian

In MongoDB, you can use the $type element query operator to filter a collection of documents based on BSON type. It returns just those documents that have a particular BSON type in a specific field.

You provide the field and the BSON type, and $type will return all documents that match.

Continue reading →
MongoDB data types, operators, what is

MongoDB $type Aggregation Pipeline Operator

Posted on February 2, 2021February 5, 2021 by Ian

In MongoDB, the $type aggregation pipeline operator returns the BSON type of its argument.

You can use it to find out the type of a given field.

Continue reading →
MongoDB aggregation, data types, operators, what is

MongoDB $toObjectId

Posted on February 2, 2021February 2, 2021 by Ian

From MongoDB 4.0, you can use the $toObjectId aggregation pipeline operator to convert a string to an ObjectId.

The string must be a hexadecimal string of length 24.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $rtrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $rtrim aggregation pipeline operator removes whitespace from the end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all periods (.), exclamation marks (!), etc from the end of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $ltrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $ltrim aggregation pipeline operator removes whitespace from the beginning of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) from the beginning of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $trim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $trim aggregation pipeline operator removes whitespace from the beginning and end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) or periods (.) or all s characters, etc.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB Whitespace Characters

Posted on January 31, 2021January 31, 2021 by Ian

The following table contains a list of whitespace characters that MongoDB removes by default when using the $trim, $ltrim, and $rtrim aggregation pipeline operators.

Continue reading →
MongoDB aggregation, reference
  • «
  • 1
  • …
  • 236
  • 237
  • 238
  • 239
  • 240
  • …
  • 371
  • »

About Database.Guide | Privacy Policy