Other database objects in MariaDB projects

Diagrams can also contain graphical representatives of various database objects. The following objects can be added to MariaDB diagrams:

  • Views
  • Stored procedures
  • Functions
  • Triggers
  • Other objects (Events, Table check constraints, User/Role definitions)

Each object has its default color that can be changed. Objects can be repositioned, aligned, enlarged, etc.

mariadb procedure and function

Usage:

To add a new object, click Other on the toolbar or right-click the diagram area and choose the desired object type, for example, Function.… Read the rest

Visualization of existing MariaDB databases

All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MariaDB and enter the connection details.

When you are finished, click the Save Connection button.

Database connection

Your new MariaDB connection will appear in the list of all database connections.… Read the rest

MySQL database design

Quick-start guide for MySQL DB database design

  1. New project
  2. Tables and columns
  3. JSON datatypes
  4. Relations and foreign keys
  5. Code generation

1. New project for MySQL

To create a new project, click the New icon on the main toolbar and select the MySQL project type.

2. Adding tables and columns to the project and diagram

New database tables can be added into projects by clicking Table on the toolbar and then by clicking the main diagram area.… Read the rest

MariaDB database modeling

In Moon Modeler you can easily draw MariaDB structures.

Database tables

Database tables are displayed as graphical boxes with all column fields.

JSON

One of the main advantages of Moon Modeler is the possibility to visually display nested structures.
The structures are displayed inside tables and also as separate graphical objects.… Read the rest

About Moon Modeler – a data modeling tool for relational and noSQL databases

Moon Modeler is a data modeling tool for MongoDB, PostgreSQL, MariaDB, MySQL, SQLite, Mongoose and GraphQL. It can also be used for solutions like Cosmos DB or Heroku Postgres and others. The software belongs to the data modeling and schema design tools category and can be used to model hierarchical database structures.… Read the rest

MariaDB database design

Quick start guide for MariaDB database design in Moon Modeler.

  1. New project
  2. Tables and columns
  3. JSON datatypes
  4. Relations and foreign keys
  5. Code generation

1. New project

To create a new project, click New on the toolbar and select the MariaDB project type.

2. Database tables and columns

New database tables can be inserted into projects by clicking Table on the toolbar and then by clicking the main diagram area.… Read the rest

Quick links

Free Trial Buy Now!

Blog categories