Software Engineering Code & Art

Database store

Data Store Module

Persistent key-value storage for workflow automation and cross-module synchronization.

Persistent Data Management

The **Data Store Module** functions as a high-performance internal database within the EPMS ecosystem. Unlike temporary session data, the Data Store provides a permanent home for variables, logs, and configuration states that need to be shared across different modules or automated scenarios. Leveraging the vx_ database prefix, it ensures that your system data is structured, indexed, and secure.

Operational Capabilities

Record Management (CRUD)

Seamlessly Add, Update, Get, or Delete records from specific data stores. This allows modules to maintain a "memory" of previous actions, such as tracking the last processed ID in a government budget migration.

Advanced Record Retrieval

Utilize complex filtering to "Search Records" within the store. The system supports multi-parameter queries to find specific entries based on custom keys or timestamps without manual SQL overhead.

Automated Housekeeping

Integrated "Delete All" and "Clear Store" functions allow for the scheduled purging of temporary logs or cache data, ensuring the vx_ tables remain lean and optimized for speed.

Cross-Scenario Sync

Share data between separate automation flows. If a form is submitted in the *Dynamic Form Builder*, relevant identifiers can be stored here for the *Approval Module* to reference later.

Data Structure Import

Define custom columns and data types for your stores. This allows the system to validate incoming data against expected formats, preventing database corruption and ensuring type-safety.


  •