Softpedia >Windows >Internet >Servers >Database Utils >Moon Modeler >  Changelog

Moon Modeler Changelog

What's new in Moon Modeler 7.4.2

Oct 4, 2023
  • Better support for MongoDB and Mongoose.

New in Moon Modeler 6.3.0 (Apr 19, 2023)

  • New diagram layout:
  • We have modified the layout of objects in the diagram to make it clearer and to make working with objects in the diagram more comfortable.
  • The diagram now displays the collection in a group with other graphic objects representing fields of the Object data type (object details/documents).
  • These graphic objects are automatically positioned and therefore do not need to be manipulated manually in any way.
  • Easier definition of hierarchical structures:
  • To add additional fields to an existing document/object, just click on the object name in the diagram (2). After this action, the object will be highlighted in orange and the Children tab (3) will be activated in the right sidebar. Here you can conveniently add additional fields.
  • Advanced visualization on sub-diagrams:
  • Hierarchical structures can be quite extensive. In Moon Modeler, you can now choose whether or not you want to display the detail of a particular object/field.
  • In addition, you can set the visualization in a different way on each of the sub-diagrams. The displayed and hidden items will be preserved when you save the project.
  • Keyboard navigation:
  • We have added the ability to navigate by items in a group of objects. Use the up and down arrows to easily move to the previous or next field.
  • Use the right or left arrows to move to/from the object detail.
  • And if you want to show or hide the detail, just press the CTRL key in combination with the right or left arrow key.
  • Updated layout features:
  • We have modified the way features used to modify graphic elements or their positions in the diagram work. In the new version, you can hide some object details and then use one of the autolayouts for automatic arrangement. The width of the whole group of objects, i.e. collection and visible object details, is now taken into account.

New in Moon Modeler 5.1.0 (Oct 24, 2022)

  • You can now compare your project to the structure that is in the database and easily update your project. See what objects no longer exist in the database, what objects have been added to the database, and what objects are different.
  • In case you created the project manually, you can still compare your project with the database. Just create a database connection on the Connections page. Then navigate to your project and click on the Update button and choose Select connection.
  • We have changed the user interface for the ability to import SQLite databases. Previously the import was available from the Projects page. However, since version 5.1 includes the Project update feature, we have added the ability to save the database connection/path among other “connections”. This makes it easy to find the original database. Additionally, you can use the option to use this “connection” for Project update.

New in Moon Modeler 5.0.0 (Oct 5, 2022)

  • Adding referenced objects to sub-diagrams:
  • This feature is designed to make it easier to work with larger projects and is available in Professional editions. How does it work? For example, if you add one table to a new sub-diagram, you will usually want what other tables have a link to the current one. So in version 5, you can right-click on a table and select one of the following from the context menu:
  • Add referenced parents
  • Add referenced children
  • Add referenced objects
  • Example:
  • Adding selected object to another diagram in the Professional edition
  • A new modal form will open, define the diagram name and confirm the changes. Then right-click on the object and select the desired item from the context menu.
  • The context menu is of course available from the left sidebar, where you can easily search etc.
  • In this way you get a quick overview of the referenced objects. Of course, you can repeat this procedure for other parent or child objects or for multiple selected objects.
  • . Modeling of hierarchies in Moon Modeler:
  • We have greatly simplified the work with modeling hierarchical structures for MongoDB and Mongoose. Now you can define hierarchies in an even simpler way. So now you can just select “object” as the data type of your field, select that field in the diagram, and define additional properties for that field on the Field detail and children tabs. Here you can easily add more fields, and of course also use another “object”. This makes creating a hierarchical structure much faster and easier. And as a bonus, another advantage is better application performance.
  • How it works:
  • Choose the standard “object” data type for your field.
  • Change properties in side panel
  • That’s all. We believe you will like the simplified way of modeling hierarchies.
  • Additional settings and functionalities:
  • You can also use the left sidebar to select the fields themselves. Just turn on the fields display:
  • Then you can search for a field by name, select it and edit properties in the right panel.
  • Tip: To avoid having to move the mouse cursor from left to right, you can change the layout settings of the application in the Settings section.
  • Note: As far as possible modeling hierarchies in relational database projects is concerned, we have not decided to add such functionality to Luna Modeler, especially considering our plan to focus on advanced functionalities such as synchronization, model update and generation of change scripts.
  • . Text notes:
  • We have added the ability to define text notes. This is a graphic element used to place a caption or heading anywhere in the diagram. The advantage is that it is an element with a predefined style. If you don’t change the text or background color, it will remain in a state where switching the theme from dark to light will affect the text color and this caption will still be visible.
  • For existing notebooks, you can then change the colour and background to “transparent”, so you can use a similar method for existing notebooks. Once you have set these options for older text objects, you can use the Copy format and Apply format options to apply the format to other selected objects really easily.
  • copy and apply format
  • Note: This feature is available in all products.
  • . Product line changes:
  • Let’s start by going back in time. Moon Modeler was a tool for one platform. Over time we added more and more supported platforms and Moon Modeler became a tool for modeling structures that were not so related. This could have led to an unnecessarily complex UI and a less than ideal UX.
  • That’s why, we’re coming out with products targeted at specific applications and platforms, which will help us better focus on the features and functionality that are most in demand. Our new portfolio includes:
  • Moon Modeler for MongoDB and Mongoose ODM
  • Luna Modeler for relational databases like PostgreSQL, MariaDB, MySQL and SQLite – our goal is to focus more on relational databases and especially advanced features like synchronization and also generating alter scripts. These features cannot be easily applied to other types of previously supported platforms (MongoDB, GraphQL…). Very soon you will see the first of the features being developed, namely Project Update – where each of your projects will have database connection information and it will be possible to easily update your diagram.
  • Galaxy Modeler for modeling GraphQL diagrams. Here we want to focus on better support for Queries and Mutations both in terms of modeling and importing from file.
  • Meteor Modeler for modeling Sequelize structures and possibly other ORM frameworks.
  • This change will help us to focus on better UI/UX and prepare for you exactly the functionalities that you ask for the most. These include e.g. synchronization features, alter script generation for relational databases or adding support for SQL Server.

New in Moon Modeler 4.6.6 (Aug 12, 2022)

  • Improved connection properties for MongoDB / DocumentDB. Options Direct connection, TLS Allow invalid hostnames and Retry writes added to the user interface. Now you can setup connection to AWS DocumentDB more comfortably.
  • Bug fix for adding new objects to existing diagrams.
  • Bug fix for copying tables or collections.

New in Moon Modeler 4.6.5 (Aug 4, 2022)

  • Improved import from GraphQL
  • Bug fix for column selection in left side panel.

New in Moon Modeler 4.6.4 (Jul 29, 2022)

  • Logical Entity-Relationship Diagram:
  • Logical ERD
  • We’ve added the ability to create a project where you can easily design an ERD with entities, attributes, one-to-one, one-to-many and many-to-many relationships. This is a type of project in which you can simply describe business objects without having to specify the target database platform or data types.
  • Many-to-many relationship in logical entity-relationship diagram
  • Since it is a logical ER diagram, SQL generation is not available. However, you can generate a PDF or interactive HTML reports.
  • Copy and apply format:
  • A new feature that is available for all projects (be it relational or noSQL database designs, or schema design for Mongoose or GraphQL), is the ability to select the format of a graphical object and apply it to other selected objects. The workflow is very simple.
  • Select the object, open the context menu, and select Copy format.
  • The copied format can be used multiple times and
  • The copied format can be applied to different types of objects, such as collection, document, enum, table, json, etc. and also note.
  • Notifications with links:
  • After saving a report, generated script or PDF document, notifications now show the option to open the file or target folder.
  • Notifications with links
  • Conversion of a MongoDB document to a MongoDB collection:
  • In MongoDB projects it was already possible to change the object type from collection to document type. This version introduces the possibility of converting in the opposite way, i.e. from document to collection.
  • Support for Enums in Mongoose projects:
  • One of the new features in support for Mongoose is the ability to create Enum objects that can be used in multiple schemas.
  • Enum - mongoose
  • The generated script for the schema in which the Enum is used then contains the individual entries.
  • Enum in Mongoose schema script
  • The advantage is of course the ability to change the Enum definition in one place and the change will automatically be reflected in all other objects.
  • Proxy settings:
  • For users who use proxies, we have added the ability to configure proxy settings. This setting will be used to activate the license key for Moon Modeler.
  • Other useful improvements and bug fixes:
  • Context menu with sub-menu items

New in Moon Modeler 4.6.3 (Jul 28, 2022)

  • Comments for PostgreSQL table columns and indexes are generated correctly
  • Bug fix for PostgreSQL and MariaDB projects, sections Before script and After script.

New in Moon Modeler 4.6.2 (Jul 27, 2022)

  • Improved reverse engineering from MongoDB (import from schema definitions)
  • Single quotes used in Descriptions are escaped in MongoDB projects

New in Moon Modeler 4.6.0 (May 10, 2022)

  • If the order of the columns in the primary key is changed, the order of the foreign keys in the child table will be adjusted accordingly.
  • The scroll position remains in the same place after inserting a copy of the objects, so there is no position shift in the project.
  • Fixed bug when changing primary key to alternate key.
  • Fixed an error that could occur when deleting an alternate key.
  • Modification of reverse engineering for MongoDB. If the parent collection is not found, a message is displayed.
  • Correction in reverse engineering for PostgreSQL. If no key is found, a message is shown.
  • Fix in loading MariaDB and MySQL structures (aggregations).
  • New notification in case you try to load a SQLite file that does not contain a SQLite database.
  • Fix for incorrect rendering of anchor points in the generated HTML report.
  • Fixed object dimensions when adding tables to a new sub-diagram.
  • Fix Lock dimensions functionality for Note objects.
  • Other minor improvements and bug fixes.

New in Moon Modeler 4.5.1 (Mar 18, 2022)

  • Fixed an error caused by deleting a column.
  • Improved loading of backup files.
  • Added shorter interval for saving backups – 5 seconds.
  • Fixed automatic resizing of objects when resizing another object.
  • Fixed object resize.
  • Fixed import from SQLite.
  • Improved reverse engineering from PostgreSQL (empty schema).
  • Fixed restrictions for modeling GraphQL structures.
  • Modification of styles in modal forms.
  • Improved Lock dimensions functionality.

New in Moon Modeler 4.5 (Mar 17, 2022)

  • We have redesigned the sidebar with objects. Now you can quickly search even in large models, scrolling is smooth and overall user experience is better.
  • We have optimized the diagram rendering. You can move objects using drag and move, without noticeable freezing.
  • We’ve redesigned UNDO/REDO. Even complex operations are handled differently and reverting to the previous state is faster.
  • In GraphQL projects, the dashed line (implements) is replaced with a solid line, which affects the speed of drawing the diagram.
  • You can only display certain object types
  • You can now add display for columns, indexes, etc.
  • Search is now available for child objects (columns, fields, etc.).
  • Display of the number of occurrences found has been added
  • Another improvement is the ability to view column detail directly from the diagram. Just click on the column name and the detail will be displayed in the right panel.

New in Moon Modeler 4.4 (Jan 17, 2022)

  • Logical Entity-Relationship Diagram:
  • We’ve added the ability to create a project where you can easily design an ERD with entities, attributes, one-to-one, one-to-many and many-to-many relationships. This is a type of project in which you can simply describe business objects without having to specify the target database platform or data types.
  • Since it is a logical ER diagram, SQL generation is not available. However, you can generate a PDF or interactive HTML reports.
  • Copy and apply format:
  • A new feature that is available for all projects (be it relational or noSQL database designs, or schema design for Mongoose or GraphQL), is the ability to select the format of a graphical object and apply it to other selected objects.
  • Notifications with links:
  • After saving a report, generated script or PDF document, notifications now show the option to open the file or target folder.
  • Conversion of a MongoDB document to a MongoDB collection:
  • In MongoDB projects it was already possible to change the object type from collection to document type. This version introduces the possibility of converting in the opposite way, i.e. from document to collection.
  • Support for Enums in Mongoose projects:
  • One of the new features in support for Mongoose is the ability to create Enum objects that can be used in multiple schemas.
  • The generated script for the schema in which the Enum is used then contains the individual entries.
  • The advantage is of course the ability to change the Enum definition in one place and the change will automatically be reflected in all other objects.
  • Proxy settings:
  • For users who use proxies, we have added the ability to configure proxy settings. This setting will be used to activate the license key for Moon Modeler.
  • Other useful improvements and bug fixes:
  • Context menu with sub-menu items
  • Bug fix: copy and past on macOS
  • Text shadows removed from exported PDF (for default PDF viewer on macOS)

New in Moon Modeler 4.0.0 (Sep 17, 2021)

  • Generation of HTML reports, settings for SQL code generation and more.

New in Moon Modeler 3.0.2 (Apr 26, 2021)

  • Support for multi ER diagrams, new features for PostgreSQL and MongoDB.