What’s new in
Luna Modeler version 8
This page was updated on April 24th
Custom Templates, Custom Properties,
Endless Possibilities
Imagine defining a template that generates not only SQL scripts but also parts of your application code.
Luna Modeler bridges the gap between databases and development.
Easily create custom output, SQL scripts, HTML reports, CSV files or
even UI components – it can all be done with custom templates!
Version 8.5
Customizations & Custom Properties
Custom Properties
You can easily add your own custom properties to Luna Modeler projects, display them directly on the diagram, edit values in the right side panel, embed them in HTML reports and use them to generate your own scripts or other outputs.
Customizations
Custom properties are part of the so-called Customizations, which extend the capabilities of Luna Modeler. You can create your own customizations choose which element in the UI will be available for editing values etc. Of course, you can conveniently define customizations and custom properties directly in Luna Modeler.
Rapid Application Development
In combination with templates, you can generate custom output. Whether it is a piece of back-end code, forms for the front-end or HTML output with a list of objects where sensitive data is stored, etc.
Version 8
Scripts & Templates
Script and Templates
On the SQL Script form you can find the Script and Templates tab where template-based output is available. Here you can find several predefined templates, such as the SQL code template for outputting SELECT statements or DROP statements for tables. It also shows the possibility of generating the output to a CSV file or part of application code written in javascript.
Templates Toolbar
On the Script and Templates tab you will find a toolbar with a diagram selection, a template selection and also the following buttons:
- Syntax highlighting – especially useful for javascript or json code
- Open folder with templates
- Reload templates – if you add a custom template
- Documentation – link to documentation
Collapsible Sections and Easy Copying
In terms of a user-friendly interface, you now have the option to collapse or expand the generated script for individual objects and to insert the script for selected object into the clipboard easily.
Modal Forms & Custom Template Based Scripts
The generated script for the selected object can be viewed also on the object Detail modal form. Navigate to the SQL Script tab where you will find everything you need, including:
- Generation settings
- Before and after scripts
- Custom code
- Script and Templates with custom template based output.
The combination of all options and possibilities provides exceptional flexibility!
Side Panel & Template Based Output
In your templates you can write a code that will be generated only for the currently selected object. Thus, it is not necessary to generate the output for the whole project and then search for the file with the generated code. Just select a table, relationship or other object in the diagram and view your own template based script in the sidebar.
Templates Structure
When you open the templates folder, you will see a simple structure. To create a custom template, just create one simple json file describing the template and one hbs file containing the template written in Handlebars. You then only need to write a few lines of code to output the SELECT statement of the tables. Writing templates is easy and based on a well-known templating system. There is no need to reinvent the wheel!
Comfortable Development
In rare cases, you may make a mistake when creating a template. In this case, the Handlebars templating system will display an error instead of the generated content. This way you can immediately see where to look and there is no need to restart Luna Modeler at all.
Our goal is to make your work comfortable and pleasant even if some modification of the templates is required.
The latest improvements
Improvements & Fixes
- Improvements in reverse engineering from Microsoft SQL Server, PostgreSQL, MySQL and MariaDB databases.
- Synchronization of PK and Not Null settings.
- Better naming for MySQL and MariaDB primary keys
- Update of components
- Bug fixes in SQL Server HTML reports
Download
Luna Modeler
Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.
Purchase
Luna Modeler
You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.