Managing databases

Quickwork's database is an integrated data management system within the platform that organizes, stores, and manages data across collections (commonly called tables), allowing for efficient data retrieval, modification, and management.

These collections are designed to accommodate up to 10000 rows per collection with the flexibility to define up to 10 columns. The structured approach is essential for organizing data efficiently, making it easily retrievable, modifiable, and manageable through create, read, update, and delete (CRUD) operations.

There are two primary ways to manipulate data in these collections:

Using the Databases tool: This GUI on the Quickwork allows you to interact directly with the data through a user-friendly interface. It provides functionalities for adding new records, editing existing ones, or deleting them as needed. You can visually manage your data, making it particularly useful for those who prefer a more hands-on approach without the need to build the journey. This database can be integrated into any journey, providing a flexible and robust alternative for data manipulation via Databases by Quickwork app similar to external databases like Google Sheets or MySQL.
Using the Databases by Quickwork app: This method leverages the app within Quickwork platform to perform CRUD operations using automated journeys. It’s ideal for situations where database interactions must be part of automated sequences, such as updating records based on trigger events or querying data as part of conditional logic within a journey.

When to use:

Use Quickwork’s database as a temporary storage solution for data that needs to be shared or processed across a journey or a set of interconnected journeys.
For example, a journey is triggered when a new email is received via Gmail. The workflow retrieves specific keywords stored in a Databases by Quickwork collection, checks the email’s subject and attachments against this data using conditional logic, and then performs further automated processing based on the results.

This integrated nature of Quickwork's database simplifies the setup process, reducing the overhead typically associated with connecting and securing external databases. It ensures that data handling is seamless and secure within the Quickwork environment, enhancing overall efficiency and reliability in managing data-driven journeys.

✏️ Tips and recommendations

Use Databases in Quickwork for a lightweight database solution in your journey.
Ensure your use case requires fewer than 10000 rows.
Collections in the database do not have unique key or primary key constraints, so handle duplicates within the journey.

📚 Additional resources

Using the Databases tool
Using the Databases by Quickwork app