LightSwitch API

LightSwitch API Fortifies its No-code REST API Developer Platform
with MySQL HeatWave

"Our no-code REST API helps startups or small development teams build software applications rapidly with very little cost. MySQL HeatWave has raised the bar by providing the backend architecture that boosts performance, scalability, and security."

Prabath Yapa
LightSwitch API

Australian SaaS ISV chooses MySQL HeatWave to power its no-code software development platform with increased performance, scalability, security, and at a lower cost.

Introduction & Background

LightSwitch API is a technology startup based in Australia that has developed a no-code REST API to assist software developers in constructing robust and scalable web, mobile, and Internet of Things (IoT) applications.

The product provides web-based application programming interfaces (APIs) that adhere to Representational State Transfer (REST) architecture, which are commonly used in software applications. With LightSwitch API, customers can build REST APIs without any custom coding or infrastructure.

Business Challenges & Goals

While developing LightSwitch API, the company looked for a cloud-based managed database service to be used as a default storage option.

Their main requirements were performance, security, and low-cost subscription pricing in order to provide customers with these same benefits.

After reviewing the main cloud platforms, and testing AWS, MySQL HeatWave was chosen as the preferred provider for the product.

Business Results & Metrics

Selecting MySQL HeatWave as its underlying database has boosted performance, lowered costs, and provided LightSwitch API with the security and scalability needed to take its solution mainstream. With MySQL HeatWave running on Oracle Cloud Infrastructure (OCI), the company can build out its no-code product according to its ambitious roadmap, including early adopter feedback.

With the combination of MySQL HeatWave with OCI and LightSwitch API, software developers can significantly reduce the complexity of backend and database setup, connectivity, identity management, and scalability. From the early stages of software development, LightSwitch API allows storing and retrieval of data, server-side filtering, authenticating users, and controlling data access on top of MySQL HeatWave.

MySQL HeatWave’s scalability provides LightSwitch API users with the ability to handle large amounts of data and requests, scaling up or scaling down according to demand without any downtime. Its high-performance in-memory query accelerator eliminates bottlenecks for downstream web applications, interacting with LightSwitch API to cache responses and reduce bandwidth usage by sending only relevant data.

The combination of LightSwitch API and MySQL HeatWave enables developers to generate application backends instantly, compared to the weeks or months previously spent configuring infrastructure and writing code to connect applications to a database.

As a cloud database designed for speed and scalability, MySQL HeatWave’s optimized in-memory representation results in significant performance improvements and reduced costs for the platform. This is a strong advantage that LightSwitch API can pass along to a customer base of individual developers, small teams, and startups.

OCI’s built-in security features ensure LightSwitch API customers that their data is maintained securely and can be stored, retrieved, backed up, and recovered with peace of mind.

Why MySQL HeatWave?

LightSwitch API compared all cloud database providers and deemed MySQL HeatWave to be the best in terms of both performance and cost. They were also impressed by the proactive nature of MySQL support.

“It was easy and straightforward to get started with MySQL HeatWave which performs much better than other cloud database offerings and at a lower cost,” said Prabath Yapa.

Next Steps

As the overall solution architecture gains momentum and customer requirements become apparent, LightSwitch API will incorporate MySQL HeatWave analytics and other features into the product and make them available to the no-code customers.