Query Builder Data Protection #73

New issue

Open

opened 2025-02-16 12:57:27 +00:00 by jkeffects · 0 comments

jkeffects commented

2025-02-16 12:57:27 +00:00

Owner

Execute Queries from the Query Builder on a copy Database to prevent Data loss.

Use for Example an In-Memory Database

spin up shadow database
run query
clear shadow database
prevent mutal exclusion or cross influence of parallel requests

Approach:
Use Class to manage the database
The Class exposes the datasource to enable requests.
Free Memory after request has been made

this.inMemoryDb = await open({
  filename: ':memory:',
  driver: sqlite3.Database
});

const memoryManager = new InMemoryDatabaseManager(dataSource);

try {
  await memoryManager.initialize();
  return await memoryManager.request();
  await memoryManager.cleanup();
} catch (error) {
  await memoryManager.cleanup();
  throw new Exception(error)
}

Execute Queries from the Query Builder on a copy Database to prevent Data loss. Use for Example an In-Memory Database - [ ] spin up shadow database - [ ] run query - [ ] clear shadow database - [ ] prevent mutal exclusion or cross influence of parallel requests Approach: Use Class to manage the database The Class exposes the datasource to enable requests. Free Memory after request has been made ```ts this.inMemoryDb = await open({ filename: ':memory:', driver: sqlite3.Database }); ``` ```ts const memoryManager = new InMemoryDatabaseManager(dataSource); try { await memoryManager.initialize(); return await memoryManager.request(); await memoryManager.cleanup(); } catch (error) { await memoryManager.cleanup(); throw new Exception(error) } ```