MongoDB ER diagram graphics

Settings for MongoDB ER diagram graphics can be defined on two levels in Moon Modeler. On a project level and on a selected object level.

Project graphics

Click the MongoDB ER diagram area to make sure no object is selected. Then change the colors in section Graphics. Alternatively, edit Project properties and specify settings on tab Graphics of the modal form.… Read the rest

NoSQL data modeling

Data modeling is the process of visually creating a graphical representation of a system or database. In the case of relational databases, we can mention the creation of entity-relational diagrams in which entities, attributes and relationships between entities are displayed. (Read more information about ER diagrams).

Advantages of data modeling

  • Fewer design and development errors
  • Easy and fast design, especially in the early stages of development
  • Better communication between team members
  • Time saving
  • Lower development costs
  • and many others

MongoDB schema design and noSQL database modeling

But what is the advantage of data modeling when we talk about noSQL databases?… Read the rest

Forward engineering

When it comes to forward engineering in Moon Modeler, it’s about generating the resulting script for the selected target platform.

In the case of relational databases such as PostgreSQL, MariaDB, MySQL or SQLite, it is the resulting SQL script. For MongoDB it is possible to generate a schema validation script and for platforms like Mongoose or GraphQL it is schema definition scripts.… Read the rest

Projects in Moon Modeler

You can save your database structures and schema designs in Moon Modeler into projects.

On the project overview page, you can search projects by name or platform, quickly find the platform for which the project was created, and also view examples on a separate tab.

Projects created in Moon Modeler.

What does the Project contain?

  • List of all objects that exist in the structure
  • Main diagram, in which certain objects can be shown or hidden
  • Additional subdiagrams that are used to visualize a specific group of objects

Creating projects

  • You can create a completely new project and start creating a database design or schema design from scratch
  • It is also possible to load an existing project from a file or from a URL.
Read the rest

Free ER diagram tool?

Looking for a free ER diagram tool? There are many on the market and Moon Modeler is one of them.
This free ER diagram tool can be used to visually define smaller database structures for relational database systems such as MariaDB, MySQL, PostgreSQL, SQLite, and NoSQL databases such as MongoDB, or object-document mappers such as Mongoose.… Read the rest

Script generation for GraphQL

To generate scripts from your GraphQL project click the Script icon on the main toolbar. New modal opens. Click Save Script and select a location where the file should be stored. Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.

Generated script for GraphQL

#

Line modes in GraphQL schema diagram

Moon modeler offers two possibilities how to display lines between referenced objects. By default, the display mode where parent object is linked to a specific field in child object is active.

Default line mode:

GraphSQL schema diagram - default line mode

You can easily change that mode to Simple line mode. In this mode, lines are referenced from one object to another, in practice it means that can be anchored to bottom or to top of a graphical representative.… Read the rest