Import & Visualization of existing SQLite databases

Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.

Import file - SQLite

Select the database file. In this example, we will load the chinook.db… Read the rest

SQLite database design

Quick start guide for SQLite 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