1. Create a workspace

info

Workspaces are environments(tables, views, indexes and statistics) where you do query optimizations. A workspace consists of at least a set of tables, and optionally view definition, index definition and the statistics on them. You can browse those objects in workspace page after a workspace is defined.

User can create a workspace in the following ways:

1. By database connection information
   • MySQL,
   • PostgreSQL,
   • Opengauss,
   • Oracle
   • and MariaDB.
2. By uploading a DDL file
3. By manually inputting DDL text.

📄️ MySQL Connection

Create a PawSQL Workspace from a MySQL connection.

📄️ openGauss Connection

Create a PawSQL Workspace from a OpenGauss connection.

📄️ Oracle Connection

Create a PawSQL Workspace from a Oracle connection.

📄️ PostgreSQL Connection

Create a PawSQL Workspace from a PostgreSQL connection.

📄️ DDL File

Create a PawSQL Workspace from a DDL file.

📄️ DDL Text

Create a PawSQL Workspace from text input by user. Workspaces are environments(tables, views and indexes) where you do the query optimization.

tip

For each method of creating a workspace, PawSQL provides online guides to help you set up your workspace on the right half.