How victornavarreteduran/gestor_sqlite works
Gestor SQLite PIME is a browser-based small-business manager: an operator opens or creates a local SQLite file, works in dashboard sections, then downloads or directly saves changes. The main flow runs from the home screen through the shared sql.js engine into domain repositories and back to the UI. Distinct capabilities include sales/POS, inventory and stock movements, clients, dashboard analytics, and finance reporting. Express serves static application resources; the README states database queries and persistence remain in the browser. Several repository and module implementations were not excerpted, so their links follow the SOURCE INDEX import references.
Main entry points: dashboard.js Dashboard bootstrap · engine.js SQLite engine · formatters.js Display formatters · app.js Database home
Components 22
Entry and navigation
- Database home
public/app.js - Dashboard bootstrap
public/js/dashboard.js - Template loader
public/js/components/template-loader.js - Navigation and session
public/js/components/navbar.js - Static server
src/server.js
Local database runtime
- SQLite engine
public/js/db/engine.js - Schema and triggers
public/js/db/schema.js - Local SQLite file
Business operations
- Inventory browser
public/js/modules/inventario.js - Inventory queries
public/js/db/repositories/inventory.repo.js - Stock movements
public/js/modules/kardex.js - Stock repository
public/js/db/repositories/stock.repo.js - Sales POS
public/js/modules/pos.js - Sales repository
public/js/db/repositories/sales.repo.js - Clients and suppliers
public/js/modules/clientes.js - Client repository
public/js/db/repositories/clients.repo.js - Display formatters
public/js/utils/formatters.js
Reporting and analytics
- Home dashboard
public/js/modules/inicio.js - Dashboard queries
public/js/db/repositories/dashboard.repo.js - Finance reports
public/js/modules/finanzas.js - Finance queries
public/js/db/repositories/finance.repo.js
Other components
- Operator
Connections 33
- Operator → Database home: opens database
README.md - Database home → SQLite engine: loads or creates
public/app.js - SQLite engine → Local SQLite file: reads and saves
README.md - Database home → Dashboard bootstrap: opens panel
README.md - Dashboard bootstrap → Template loader: loads templates
public/js/dashboard.js - Dashboard bootstrap → Navigation and session: initializes
public/js/dashboard.js - Dashboard bootstrap → Home dashboard: initializes
public/js/dashboard.js - Dashboard bootstrap → Inventory browser: initializes
public/js/dashboard.js - Dashboard bootstrap → Stock movements: initializes
public/js/dashboard.js - Dashboard bootstrap → Sales POS: initializes
public/js/dashboard.js - Dashboard bootstrap → Clients and suppliers: initializes
public/js/dashboard.js - Dashboard bootstrap → Finance reports: initializes
public/js/dashboard.js - Navigation and session → SQLite engine: closes session
public/js/components/navbar.js - SQLite engine → Schema and triggers: applies indexes
public/js/db/engine.js - Home dashboard → Dashboard queries: requests metrics
public/js/modules/inicio.js - Finance reports → Finance queries: requests reports
public/js/modules/finanzas.js - Inventory browser → Inventory queries: requests products
public/js/modules/inventario.js - Stock movements → Stock repository: records movements
public/js/modules/kardex.js - Sales POS → Sales repository: records sales
public/js/modules/pos.js - Clients and suppliers → Client repository: manages records
public/js/modules/clientes.js - Dashboard queries → SQLite engine: queries database
public/js/db/repositories/dashboard.repo.js - Finance queries → SQLite engine: queries database
public/js/db/repositories/finance.repo.js - Inventory queries → SQLite engine: queries database
public/js/db/repositories/inventory.repo.js - Stock repository → SQLite engine: writes movements
public/js/db/repositories/stock.repo.js - Sales repository → SQLite engine: writes sales
public/js/db/repositories/sales.repo.js - Client repository → SQLite engine: reads and writes
public/js/db/repositories/clients.repo.js - Static server → Operator: serves app assets
README.md - Home dashboard → Display formatters: formats display
public/js/modules/inicio.js - Finance reports → Display formatters: formats display
public/js/modules/finanzas.js - Inventory browser → Display formatters: formats display
public/js/modules/inventario.js - Stock movements → Display formatters: formats display
public/js/modules/kardex.js - Sales POS → Display formatters: formats display
public/js/modules/pos.js - Clients and suppliers → Display formatters: formats display
public/js/modules/clientes.js