Data Guide
Comprehensive guide for data governance and management in Holistika ERP
Important
This guide is intended for data engineers, data scientists, and database administrators working with the Holistika ERP system.
Data Architecture Overview
High-level overview of the Holistika ERP data architecture
Architecture Diagram
PostgreSQL Database
API Layer (Next.js)
Client Applications
Data Flow
Client → API (with validation) → Database → API (with transformation) → Client
Key Components
- Database Layer: PostgreSQL for persistent storage with optimized schemas
- ORM Layer: Prisma for type-safe database access
- Validation Layer: Zod for schema validation and type inference
- API Layer: Next.js API routes with TypeScript
- Data Processing: Python with FastAPI for complex data processing tasks
- Caching Layer: Redis for performance optimization