What’s new in Moon Modeler version 3.5

The latest version of Moon Modeler is available in two editions, Basic and Professional. Both editions contain a number of enhancements to increase productivity and improve usability. Thank you to all customers and users for sending us feedback and suggestions for useful improvements.

Free upgrade to the Professional edition

We are happy to announce to all Moon Modeler users that they automatically get the Professional edition upgrade for FREE!Read the rest

How to set schema validation rules for fields in a project for MongoDB

In Moon Modeler, you can easily design MongoDB database structures and generate scripts for schema validation. Many schema validation rules are accessible directly in the user interface, and additional rules can be defined textually.

Let’s see how to set the validation to the minimum and maximum value, for example. As an example, let’s use the “students” collection, in which we have defined the fields “name“, “year” and “major“.… Read the rest

What’s new in Moon Modeler version 3.0

The latest version includes the following new features and improvements:

1. Support for multiple diagrams

In previous versions, it was possible to create a project and visualize all data objects in only one diagram. Version 3 brings significant improvements.

  • Now you can manage all objects on the Main diagram.
  • You can also create additional diagrams (sub-diagrams) and focus on a selected part of the data model.
Read the rest

MongoDB vs PostgreSQL

Making a comparison of document-based database systems like MongoDB and traditional relational databases like PostgreSQL is not a simple task. In fact, it is impossible to recommend one database platform, because everything depends on your requirements and the goals you wish to achieve. For some use cases, MongoDB can be the preferred solution, for many other use cases PostgreSQL can be the better option.… Read the rest

Primary key vs unique key

What is the difference between primary and unique keys?

What primary keys are and what they are used for is explained in the article describing the difference between primary and foreign keys.

A short summary: Primary keys serve as the identifier of a unique record, it can be unique information, such as a driver’s license number, telephone number including area code, car VIN number, etc.Read the rest

How to submit an error log?

We test each new version of Moon Modeler before release, both manually and with automatic tests. The use of Docker and modern testing frameworks have proved to be very successful. However, an application error might occur (once in a decade). In this case, the following page should be displayed.

Error log

Here you can write more information about what last steps you took in the application.… Read the rest

Primary key vs foreign key

What is the difference between primary and foreign keys in relational databases?

Primary keys serve as the identifier of a unique record in a database table. It can be unique information, such as a driver’s license number, telephone number including area code, car VIN number, etc.

 

Primary key - driving license
CREATE TABLE `ecommerce`.`customer` ( 
   `driving_license` VARCHAR(100),
   `name` VARCHAR(150) NOT NULL,
   `surname` VARCHAR(150) NOT NULL,
   `email` VARCHAR(150),
   `phone` VARCHAR(200),
    PRIMARY KEY `Primary key`(
   `driving_license`
    )
)
 ENGINE = InnoDB;

Multi-column primary keys

A primary key can contain one or more columns.Read the rest

What’s new in Moon Modeler version 2.9

A key feature of this release is MySQL database design support. Version 2.9 adds data modeling features, reverse engineering of existing MySQL database structures, SQL/DDL script generation, and other useful features such as export to PDF. In this release, you will find various UI improvements, comments generation, and better troubleshooting options related to reverse engineering.… Read the rest