Creator Pulse
Full-Stack Engineer (Elixir/Vue/AI)
An AI-augmented storefront and analytics platform engineered to showcase a robust e-commerce architecture. Features a high-concurrency Elixir/Phoenix backend, Nuxt 3 SSR storefront, Vue 3 SPA dashboard, and an autonomous Text-to-SQL AI consultant.
Tech Stack
Accelerating Development with Claude Code
I heavily utilized Claude Code to scaffold the Elixir/Phoenix backend, write Ecto migrations, generate AI Text-to-SQL logic, and mock over 10,000 realistic transaction records. This allowed me to focus on high-level architecture rather than repetitive boilerplate.
Text-to-SQL Architecture
The standout feature is the "Chat with Your Data" capability. Built on top of Elixir/Phoenix and OTP/GenServers, it enables creators to type natural language queries which are securely transformed into SQL.
Frequently asked questions are cached in-memory via GenServers to reduce database load and LLM API costs. Furthermore, queries are bounded by a read-only PostgreSQL role to mitigate SQL injection vectors.
01 USER INTENT
Input: "How many templates did I sell last week?"
02 LLM TRANSLATION (Elixir Backend)
Output: SELECT COUNT(*) FROM transactions ...
03 SECURE EXECUTION
PostgreSQL evaluates via read-only `analytics_reader` role
04 DYNAMIC CHARTING (Vue 3)
JSON Payload delivered → Chart.js rendering
Public Storefront (Nuxt 3 SSR)
SEO-Optimized Performance
A high-performance, Server-Side Rendered (SSR) public storefront built in Nuxt 3 designed to display creator digital products. The SSR architecture ensures critical SEO signals are present upon first load, driving better organic discovery.
- SSR for optimal SEO
- Nuxt 3 dynamic routing
- Responsive layout
- Fast initial load speeds
Creator Product Listings
Dynamic Store Configurations
Allows creators to manage multiple digital items such as e-books, templates, and courses. Each product has tailored pricing and variant logic handled cleanly through Elixir backend endpoints.
- Granular control over e-books, courses, templates
- Dynamic product configuration
- Elixir-curated rapid API response
- Clean UI/UX flow
Checkout Flow UI
Conversion-Focused Transactions
A frictionless checkout experience engineered with modern Vue 3 components, tracking real-time purchase data into the `transactions` table. Essential for collecting the business metrics fed directly into the Text-to-SQL logic.
- Responsive checkout interface
- High-conversion design patterns
- Immutable transaction logging
- Ecto state management
Private Creator Dashboard
Vue 3 SPA Real-Time Analytics
A fast Single Page Application built utilizing Vue 3's Composition API. Features real-time dashboard navigations tracking daily and monthly revenue metrics without full page reloads, ensuring optimal creator experience.
- Vue 3 Composition API
- Interactive dashboard components
- Daily/monthly revenue metrics
- Fluid SPA navigation
“Chat with Your Data” AI Consultant
Autonomous Database Interrogation
The flagship feature. Users ask questions like “What were my sales by product?” and an AI translates this into SQL, executes it, and renders a dynamic visualization. Features GenServer caching and highly indexed queries.
- Natural Language to SQL
- Gemini API integration
- OTP/GenServers for query caching
- Dynamic chart (bar, line, pie) rendering
Core Technologies
Elixir
Backend
Phoenix
Framework
Nuxt 3
Public UI (SSR)
Vue 3
Dashboard (SPA)
PostgreSQL
Database
Ecto
ORM
Gemini API
AI LLM
Claude Code
AI Dev Workflow
OTP/GenServers
Concurrency
Tailwind CSS
Styling
Architecture & Implementation
Creator Pulse was built to explore highly concurrent backends, modern SSR frameworks, and cutting-edge AI integrations in an e-commerce context.