DMarlon Studio

Chapter 6

Databases

Connections, tables, SQL queries and CSV export.

Connections

+ adds a SQLite, PostgreSQL, MySQL / MariaDB or MongoDB connection, with server, port, database, user, password and Encrypted connection (SSL) depending on the type. Test connection checks it can be reached.

The connections saved here are the ones the Designer's windows can use through the Data connection component.

Database manager
A SQLite database with its tables and the query editor.

Tables and queries

  • The table list can be narrowed with Filter tables; each table opens a sample query.
  • Run executes the query in the editor and shows the result in a grid.
  • Anything that changes data asks for confirmation first.
  • CSV saves the full result to a file.