Import & Visualization of existing SQLite databases

Connection to a SQLite can be created easily. Navigate to page Connections and click the Create new connection button. Select the SQLite project type and specify name and path to the database file.

new connection

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

Import file - selection

Then click the Connect and load database structure button.… Read the rest

SQLite database design

Quick start guide for SQLite database design.

  1. New project
  2. Tables and columns
  3. Relationships and foreign keys
  4. Code generation
  5. Report generation
  6. Visualization of existing databases

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!