Simka — SIM Dealer Platform
SIM-card distributor platform for sub-dealer management, reporting, and inventory
// Built with
fastapi
python
react
typescript
postgresql
sqlalchemy Alembic AG Grid tanstack-query Ant Design Recharts
i18next
pydantic
axios
docker
vite ruff mypy claude-code-cli01 Problem
An enterprise needed a data management platform for importing, processing, and visualizing structured data from multiple sources (Excel, legacy databases). The platform required async processing for large datasets, multi-language support, and rich data grid visualization with filtering and sorting.
03 Solution
Built an enterprise data platform with FastAPI async backend, React 18 frontend with AG Grid for data visualization, and PostgreSQL 16 with Alembic migrations. Implemented async-first architecture throughout using asyncpg, SQLAlchemy 2.0 async, and uvicorn ASGI. Built data import pipelines for Excel (openpyxl) and legacy MySQL databases. Containerized with Docker multi-stage builds and nginx reverse proxy.
04 Outcomes
Qualitative
- Enterprise data grid handling large datasets with advanced filtering
- Async processing for non-blocking data imports
- Multi-language interface for international teams
- Secure containerized deployment with non-root user
06 Constraints
- Must handle large dataset imports without blocking
- Multi-language support (i18n) required
- Enterprise-grade data grid with advanced filtering
- Legacy database migration from MySQL sources
