Enhance Database Operation Resilience with Fallback Mechanisms

[ramoncibas]

The current implementation of database operations lacks a robust error-handling strategy, resulting in potential issues and limited resilience to unforeseen errors. The absence of fallback mechanisms and detailed error logging hinders effective debugging and error diagnosis.

// No fallback if the operation breaks down,
public run(sql: string, params: any[]): Promise<RunResult> {
  return new Promise<RunResult>((resolve, reject) => {
    this.db.run(sql, params, function (err) {
      if (err) {
        console.error('Error executing query:', err.message);
        reject(err);
      } else {
        resolve(this);
      }
    });
  });
}

[ramoncibas]

Adjusted in PR (#11) where a transaction mechanism is introduced for critical database operations, ensuring data consistency. PR includes methods for initiating, committing, and rolling back transactions, increasing the reliability of database interactions. You can use the transaction function to encapsulate operations in a single recoverable transaction block.