Hey Product Hunt,

I'm Prabath, the developer of Lightswitch API.

Software developers spend a lot of time working on data persistence for software applications. This usually involves setting up database servers, designing schemas (if relational), and writing lots of plumbing code between the application and the database.

Lightswitch API makes that process easier by combining the database and the plumbing layer in to a simple, cost-effective, Software-as-a-Service offering.

Lightswitch API designer uses ‘models’ as a way of representing data entities in an application. Models can be linked to each other, enforcing relationships. Once models are published, it will create a dedicated database in a backend server and spin up a REST API that allows you to do CRUD (Create, Read, Update and Delete) operations against the backend.

Sample JavaScript code helps you to integrate each model with your UI, or other parts of the application. There’s also an inbuilt security feature with a dedicated user store and token-based authentication.

Currently launching the product as a Public Beta. It is fully functional, and has enough features to build a simple application (see lightswitchapi.com/docs). The future roadmap covers:

✔️ Supporting more complex data visibility controls and authentication scenarios ✔️ Image/blob storage buckets ✔️ Migration pathways to Cloud PaaS providers

The product aims to provide a super simple user experience to anyone starting out a software development project, saving effort and time. This has been a solo effort, about two years in the making. It would be amazing to get some feedback here to validate the path forward.

All of the application can be accessed for free (with some rate limiting on IO operations), and if you would like to try it without the rate limits, feel free to subscribe using the promo code provided.

Hope you like it!