NoSQL – Page 48

2 Ways to Delete a Collection in MongoDB

December 23, 2020 by Ian

If you no longer need a collection in MongoDB, you can delete it.

Actually, the term for deleting a collection is to drop the collection.

Either way, here are two ways to delete/drop a collection when using the mongo shell.

4 Ways to List the Collections in a MongoDB Database

December 23, 2020 by Ian

When using MongoDB, there’s more than one way to list the collections in a database.

Here are four ways to get a list of collections in a MongoDB database:

The show collections Command
The listCollections Command
The db.getCollectionNames() Method
The db.getCollectionInfos() Method

MongoDB Upsert Explained

December 22, 2020 by Ian

Many update operations in MongoDB have the potential to be upserts. An upsert is a combination of an insert and an update.

It works like this: You perform an update operation based on filter criteria, and if there are any matches, only the matched documents are updated, but if there are no matches, then a new document is inserted.

Create a Collection in MongoDB

December 22, 2020 by Ian

When you create a database in MongoDB, your database is basically an empty container for which you can add one or more collections to.

A collection is analogous to a table in relational databases.

In relational databases, you can use CREATE TABLE to create each table that you want in the database.

But MongoDB is not a relational database, and it stores its data as documents. Each document is stored in a collection.

This article shows you how to create a collection in MongoDB.

Create a Database in MongoDB

December 22, 2020 by Ian

MongoDB doesn’t have a CREATE DATABASE statement like SQL does.

In MongoDB, you create a database simply by switching to a non-existent database, then inserting data.

Install MongoDB on Windows

December 21, 2020 by Ian

MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.

MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.

You can use MongoDB as a cloud deployment, or as an on-premise installation.

In this tutorial, I install it as an on-premise installation using the MongoDB Community Edition on Windows.

Install MongoDB on a Mac

December 21, 2020 by Ian

MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.

MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.

This tutorial shows you how to install MongoDB on a Mac via Homebrew.

NoSQL Database Types

June 24, 2016 by Ian

NoSQL databases are often categorised under four main types. Some databases are a mix between different types, but in general, they fit under the following main categories.

What is a Column Store Database?

February 14, 2023June 23, 2016 by Ian

A column store database is a type of database that stores data using a column oriented model.

A column store database can also be referred to as a:

Column database
Column family database
Column oriented database
Wide column store database
Wide column store
Columnar database
Columnar store

What is a Document Store Database?

January 1, 2026June 22, 2016 by Ian

A document store database (also known as a document-oriented database, aggregate database, or simply document store or document database) is a database that uses a document-oriented model to store data.

Document store databases store each record and its associated data within a single document. Each document contains semi-structured data that can be queried against using various query and analytics tools of the DBMS.