Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

Getting Started

We are excited for you to get started building your first application with SingleStore Managed Service (S2MS). Hundreds of developers have built apps using S2MS to power their new startup idea, pet project, or even school projects! There are many reasons people come to us, so read on as we discuss the simple steps to getting speed.

Some terminology used in this guide:

  • App/Application: Web- or mobile-based, customer or internal facing application.
  • Object storage: Cloud-based data repository.

There are a few key steps to building the database for your first app, and here’s how SingleStore can help:

  • Design your schemas - Make a few simple, straightforward selections on how your data is distributed and sorted to set yourself up for millisecond response
  • Load your data - Five lines of SQL to ingest thousands of records per second
  • Test your queries - Simple Portal interface to run queries, with in-depth visual profiling tool to make them fast
  • Connecting to your app - We offer many connectivity options, no matter where you’re building your first app

These steps are applicable to all of the applications that have been built on SingleStore.

Here are a few ideas to help you brainstorm on some concepts to embed within your app:

  • Geospatial apps for real-time tracking and fencing using points, paths, and polygons
  • Analytical apps with complex aggregations and real-time updates
  • Mobile apps with rapid queries and high concurrency

Let’s get started by discussing some of the basic things to consider when bringing your data over from one of these databases.

Sample Architecture

Here’s example of how SingleStore is used by many to give immersive, responsive experiences to their customers. This can be done in many ways, and you’ll see below how one user leveraged SingleStore Managed Service not just as a fast query layer for an app, but as the data hub to send information downstream to other apps.


Users just getting started may already have data being generated by their application. If not, maybe you just have some synthetic data. Regardless of what kind of data you have or where it’s coming from, there is sure to be a way to ingest it within SingleStore and test out queries.