25. Client-Side Embedded Database

The Problem

Some business applications need local relational storage for temporary, offline, cached, or working data.

The Angular Difficulty

Angular has no embedded SQL database API; an additional browser database solution must be selected, wrapped, and integrated.

Angular Approach

// Angular does not provide an embedded SQL database API.
// An installed browser database package must be integrated as a service.
const rows = await this.localDb.query("SELECT * FROM Items WHERE Id = ?", [10]);

MS Approach

ManySet provides a direct runtime-oriented approach for this recurring business-application task.

await ms.db.exec(`
    CREATE TABLE IF NOT EXISTS Items (
        Id INTEGER,
        Name TEXT
    )
`);

const rows = await ms.db.query(
    "SELECT * FROM Items WHERE Id = ?", [10]
);

Why this way is useful in business applications :

The comparison is intended to show where ManySet supplies a business-application abstraction around a recurring task, while keeping HTML and JavaScript visible and directly usable.

Key Point :

ManySet reduces the amount of framework-specific composition required for this particular task, without requiring the React/Angular mechanism to be represented as inherently wrong or incapable.