Skip to main content

How to View MongoDB Collections as Diagrams

MongoDB doesn’t need a big introduction. It’s one of the fastest-growing databases in the market, and for a good reason. MongoDB has a unique approach to working with data by focusing on flexibility.

Offering Flexibility

Compared to a relational database like MySQL that uses well-defined tables to store data, MongoDB offers more flexibility by storing the data in JSON-like objects. The objects are then stored in collections. Two objects from the same collection can have different data-fields. For example, we can have the next two objects in the same collection:

SQL


1
{
2
id: “1”
3
name: ”John”
4
age: “43”
5
department: “Sales”
6
}
7
8
{
9
id: “12”
10
name: “Susan”
11
email: “susan@example.com”
12
Status: “A”
13
}


As we can see, even though the objects are in the same collection, they can contain different data fields. This is the flexibility that MongoDB offers when working with data. 
The Schema Problem
This type of storing the data comes at the cost of not having a schema. MongoDB is focusing more on storing everything in documents instead of tables making it easier to scale the database. 
Even so, it is possible to visualize your MongoDB collections and objects as a schema. The solution comes from DbSchema.
Deducing a Virtual Schema
DbSchema can connect to MongoDB, look in the sample collection records, and deduce a virtual diagram from there. 
All you have to do is to connect to MongoDB and the tool will deduce the schema automatically. 
DbSchema
Once the diagram is deduced, the possibilities are endless. The diagram is interactive so you can modify the objects without having to write any query. 
You can split the database in multiple layouts, each focused on a specific part of the database. For example, you can create a layout for the “quiz” collection and another one for the “user” collection. 
Working Offline and Synchronizing
DbSchema stores the schema information in local project files. This enables you to work on the “schema” without database connection and synchronize it later.
It is also possible to compare and synchronize two different versions of the same project file, thus making it easy to work on the same project in a team. 
Working offline
Documenting the Schema
Yes! You can also export the schema as an HTML5 or PDF documentation with comments and callouts.

Query & Data Tools
DbSchema offers a set of awesome tools that you can use on MongoDB such as Relational Data Browse, Visual Query Builder, Random Data Generator, and more. 

Conclusion
Using DbSchema you can still visualize the objects and collections of your MongoDB as a diagram & interact with them. 







































Comments











Post a Comment































Popular posts from this blog



















4 Ways to Communicate Across Browser Tabs in Realtime




























1. Local Storage Events You might have already used LocalStorage, which is accessible across Tabs within the same application origin. But do you know that it also supports events? You can use this feature to communicate across Browser Tabs, where other Tabs will receive the event once the storage is updated. For example, let’s say in one Tab, we execute the following JavaScript code. window.localStorage.setItem("loggedIn", "true"); The other Tabs which listen to the event will receive it, as shown below. window.addEventListener('storage', (event) => {  if (event.storageArea != localStorage) return;  if (event.key === 'loggedIn') {    // Do something with event.newValue  } }); 2. Broadcast Channel API The Broadcast Channel API allows communication between Tabs, Windows, Frames, Iframes, and  Web Workers . One Tab can create and post to a channel as follows. const channel = new BroadcastChannel('app-data'); channel.postMessage(data); And oth...




















Post a Comment









Read more




























Certbot SSL configuration in ubuntu




























  Introduction Let’s Encrypt is a Certificate Authority (CA) that provides an easy way to obtain and install free  TLS/SSL certificates , thereby enabling encrypted HTTPS on web servers. It simplifies the process by providing a software client, Certbot, that attempts to automate most (if not all) of the required steps. Currently, the entire process of obtaining and installing a certificate is fully automated on both Apache and Nginx. In this tutorial, you will use Certbot to obtain a free SSL certificate for Apache on Ubuntu 18.04 and set up your certificate to renew automatically. This tutorial will use a separate Apache virtual host file instead of the default configuration file.  We recommend  creating new Apache virtual host files for each domain because it helps to avoid common mistakes and maintains the default files as a fallback configuration. Prerequisites To follow this tutorial, you will need: One Ubuntu 18.04 server set up by following this  initial ...




















Post a Comment









Read more




























Working with Node.js streams




























  Introduction Streams are one of the major features that most Node.js applications rely on, especially when handling HTTP requests, reading/writing files, and making socket communications. Streams are very predictable since we can always expect data, error, and end events when using streams. This article will teach Node developers how to use streams to efficiently handle large amounts of data. This is a typical real-world challenge faced by Node developers when they have to deal with a large data source, and it may not be feasible to process this data all at once. This article will cover the following topics: Types of streams When to adopt Node.js streams Batching Composing streams in Node.js Transforming data with transform streams Piping streams Error handling Node.js streams Types of streams The following are four main types of streams in Node.js: Readable streams: The readable stream is responsible for reading data from a source file Writable streams: The writable stream is re...




















Post a Comment









Read more