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.

Building a New Application

Welcome to SingleStore Managed Service! We put together a guide to help you build a new application using SingleStore. Use this guide to follow a top-down approach to:

  • Preparing your data for SingleStore
  • Interacting with SingleStore
  • Designing your SingleStore tables to be optimized for your applications
  • Importing data from your originating database
  • Optimizing your queries for your applications
  • Connecting your application to SingleStore

Tutorial Outline

This tutorial is divided into the following sections:

Getting Started

  • Benefits of leveraging S2MS for your application
  • Why SingleStore is a developer’s first choice for applications
  • What kinds of apps are developers building?

Preparing Your Data for SingleStore

SingleStore Database Administration

  • SingleStore Portal
  • Drivers
  • MySQL Workbench
  • MySQL Command Line

Designing Your Tables

  • Data types
  • Designing a schema for an application
    • Sharding for application workloads
    • Sort keys for application workloads
    • Reference Tables

Ingesting Data

  • Using SingleStore Pipelines
  • Using INSERT Statements

Testing Your Queries

  • Run queries
  • Visual Explain
  • Concurrency test your queries

Connecting to Your Application Development Tools

  • Code samples to connect to SingleStore