How vaghasiyasujal106/tally-live-dashboard works
Project Type and Purpose
• This is a lightweight full-stack dashboard application.
• Purpose: connect to Tally ERP via its ODBC interface, pull accounting/transactional data in real time, process it with Python (pandas), and render it to end users through a simple web frontend (HTML templates).
File Structure Analysis
• Top level:
• app.py – main Python application, acts as the web server (Flask or similar).
• requirements – lists Python dependencies (e.g., Flask, pandas, pyodbc).
• templates/ – holds HTML templates (views) used by the backend to render pages.
• No persistent database; Tally ERP (external system) is the primary data source via ODBC.
README Insights
• Describes integration with Tally’s ODBC, use of pandas for data processing, and rendering via HTML/CSS.
• No additional microservices or third-party APIs beyond Tally and standard Python libs.
a. Main Components
1. User’s Browser (UI)
2. Web Server / Backend (app.py)
– HTTP server (Flask)
– Controller/Router layer
– Service layer for data processing
3. Data Access Layer
– ODBC Connector to Tally ERP
4. External System: Tally ERP
5. Presentation Layer
– HTML templates in templates/
– (Optional) Static assets: CSS/JS
b. Relationships & Interactions
• User → HTTP request → Web Server
• Web Server Controller calls Service Layer
• Service Layer:
• Fetch raw data → pandas DataFrame
• Transform/filter data
• Processed data passed back to Controller → view renderer
• HTML generated from templates → HTTP response → User’s Browser
c. Architectural Patterns & Principles
• MVC-style separation:
• Models: DataFrame objects in memory (no persistent DB)
• Views: Jinja2 (or equivalent) HTML templates
• Controllers: Flask routes in app.py
• Single-process, synchronous request handling (unless you add async/WSGI).
• Layered design: Presentation → Application → Data Access → External System
d. Key Technologies & Frameworks
• Python 3
• Flask (or minimal WSGI framework)
• pandas (data processing)
• pyodbc or pypyodbc (ODBC connectivity)
• Jinja2 templates (built-in with Flask)
• HTML/CSS (and optional JS) for frontend