Quick tip: Test drive SingleStoreDB using the Query Playground

Abstract

SingleStore provides a Playground that offers a fast and easy way to experience some of the capabilities of SingleStoreDB, without requiring any sign-up or downloads. In this very short article, we'll discuss some of the features of this Playground environment.

Introduction

There are a variety of ways to test drive SingleStoreDB. For example:

• SingleStoreDB Cloud. Create a free trial account with US$500 in credits and no credit card details are required.
• SingleStoreDB Self-Managed. Install the software yourself and available in several editions, such as Standard and Premium.
• SingleStoreDB Dev Image. A Docker image.

A recent addition to this list is the Playground environment. This is entirely browser-based, requiring no registration and comes pre-loaded with several databases:

• JSON Game Data
• MarTech
• TPC-DS
• TPC-H

Figure 1 shows the initial landing page.

Figure 1. Playground Landing Page.

The look and feel of the environment is very similar to SingleStoreDB Studio.

Figure 2 shows the top navigation bar.

Figure 2. Navigation Bar.

As we can see, there are several menu options, from left to right:

• Database. Choose the database from one of the examples mentioned earlier. In Figure 2, martech is shown selected.
• Three vertical dots. SQL code from a file can be uploaded into the editor or the SQL code from the editor can be saved to a file.
• + Example Queries button. Choose one of the pre-defined example queries appropriate for the selected database. The query will be pasted into the editor, ready to run.
• Run button. Execute the code in the editor. The results will be shown below the editor and can be saved to a CSV file.

A great walkthrough and tutorial of the Playground using the JSON Game Data example can be found in the article The JSON Playground in SingleStoreDB.

Summary

The Playground environment is a quick and simple way to get started with SingleStoreDB. The Playground comes with several popular databases built-in and ready to run. Example queries can be easily selected and run in the editor. The query results can also be saved to a CSV file. To fully experience the power and capabilities of SingleStoreDB, the next step would be to choose one of the other options (Cloud, Self-Managed or Docker).