StaticAPI - Static Content API Generator

August 2025 - Present

TypeScript
NextJS
PostgreSQL
Prisma
Redis

A full-stack web application that enables developers to define static API endpoints without writing code. Users can create endpoints using either a visual schema editor or a file-based editor, and the platform automatically deploys these endpoints to serve JSON responses for use in client applications.

Why?

Serving static content is a common requirement for portfolios, prototypes, and applications that need lightweight backend functionality. Traditionally, making changes to static content requires a redeploy, which slows iteration. This platform removes that bottleneck by letting users dynamically create and update static JSON endpoints, enabling faster development and easier content management.

How?

  • Frontend (Next.js + React)

    • Built a responsive UI with a drag-and-drop visual editor and JSON file editor.
    • Provided real-time preview of API responses before deployment.
  • Backend (Node.js + Prisma + PostgreSQL)

    • Designed schema to store endpoint definitions and versioned JSON content.
    • Used Prisma ORM for type-safe database access, with raw SQL for performance-critical queries.
  • Scalability & Performance

    • Added Redis caching for low-latency lookups of frequently requested endpoints.
    • Integrated RabbitMQ to publish update events, ensuring API resolver and notification services stayed in sync.
  • Deployment & Security

    • Deployed APIs with role-based access control and JWT authentication.
    • Containerized with Docker for reproducible deployments.