AksaraSQL - Interactive SQL Learning for Indonesia
ยท
2 min read
Self-hosted, mobile-first SQL learning platform designed for the Indonesian market. Features a PGlite-powered sandbox and 7-layer security architecture for safe, interactive practice.
Overview
AksaraSQL addresses the critical gap in technical education in Indonesia by providing a mobile-first, Indonesian-language platform for mastering SQL.
Traditional platforms are often desktop-centric and English-only, creating significant barriers for students and career switchers in Indonesia. AksaraSQL eliminates these barriers through a modern, accessible interface and localized content.
Key Features
Mobile-First Interactive Learning
- Optimized for smartphone screens, enabling learning anytime, anywhere
- Indonesian-first UI, error messages, and problem descriptions
- Interactive SQL editor powered by CodeMirror 6
Sophisticated SQL Sandbox
- Client-Side Execution: Uses PGlite (Postgres WASM) for instantaneous feedback without server roundtrips
- 7-Layer Defense System: A secure, isolated environment for query validation featuring transaction isolation, read-only users, and statement timeouts
- Automatic Schema Management: Resets the environment for each problem attempt to ensure a clean practice state
Production-Grade Architecture
- Kong API Gateway: Centralized routing, rate limiting, and JWT validation
- Keycloak Integration: Enterprise-grade authentication and user management
- Modular Monolith: Built with Go (Gin) for a robust and maintainable backend
Tech Stack
- Backend: Golang (Gin framework) with
sqlx - Frontend: React with TanStack Start, Router, and Query
- Database: PostgreSQL (Primary & Sandbox)
- SQL Engine: PGlite (PostgreSQL WASM)
- API Gateway: Kong Gateway
- Auth: Keycloak
- Infrastructure: k3s cluster
Why This Project?
Technical literacy in data management is crucial for the modern Indonesian workforce, yet existing resources are often:
- Language-locked: English-primary content alienates many learners
- Device-restricted: Desktop-only designs fail in a mobile-first nation
- Intimidating: High barrier to entry for beginners
AksaraSQL solves this by:
- Removing the language barrier: Providing high-quality technical content in Indonesian
- Meeting users on their devices: A sleek, responsive mobile interface
- Ensuring safety & speed: Combining client-side execution with hardened server-side validation
It represents a complete, full-stack demonstration of how modern engineering can solve specific educational challenges at scale.
Passionate about accessible technical education? Let's talk!
P.S. Check out the mission at aksarasql.com