# SingleStore

## Setup

1. Register an account on [SingleStore](https://www.singlestore.com/)
2. Login to portal. On the left side panel, click **CLOUD** -> **Create new workspace group.** Then click **Create Workspace** button.

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-2d47d097d855c01004641220060cac599da29602%2Fimage%20(56).png?alt=media" alt=""><figcaption></figcaption></figure>

3. Select cloud provider and data region, then click **Next**:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-e4b4c3f94fb7be0c82aece1a0a24bcb3cc837dc7%2Fimage%20(57).png?alt=media" alt=""><figcaption></figcaption></figure>

4. Review and click **Create Workspace**:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-383cb56448c0a27900caf435d569912a9a43292d%2Fimage%20(58).png?alt=media" alt=""><figcaption></figcaption></figure>

5. You should now see your workspace created:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-b099b0073ff3edd56970521aefecf0aa5869fdde%2Fimage%20(60).png?alt=media" alt=""><figcaption></figcaption></figure>

6. Proceed to create a database

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-6d2342f89b30129f835ff06f9c39aa5761d9fe9d%2Fimage%20(65).png?alt=media" alt="" width="485"><figcaption></figcaption></figure>

7. You should be able to see your database created and attached to the workspace:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-675182ef03109fd15e2402407508447e7b0cca41%2Fimage%20(66).png?alt=media" alt=""><figcaption></figcaption></figure>

8. Click Connect from the workspace dropdown -> Connect Directly:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-79ffbdedd4cf52e1686b8284a3980823b276bf1a%2Fimage%20(61).png?alt=media" alt="" width="418"><figcaption></figcaption></figure>

9. You can specify a new password or use the default generated one. Then click Continue:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-97b8fa607c38fd66ceb681d7920c8dbf403fe100%2Fimage%20(62).png?alt=media" alt="" width="485"><figcaption></figcaption></figure>

10. On the tabs, switch to **Your App**, and select **Node.js** from the dropdown. Take note/save the `Username`, `Host`, `Password` as you will need these in Flowise later.

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-7bb5754acbf6d7ab1051ca647f0ea19354368d0d%2Fimage%20(63).png?alt=media" alt="" width="563"><figcaption></figcaption></figure>

11. Back to Flowise canvas, drag and drop SingleStore nodes. Click **Create New** from the Credentials dropdown:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-5d0c014137896a1aa86ccad72f26549ffa3c9abe%2Fimage%20(4)%20(1)%20(2)%20(1).png?alt=media" alt="" width="271"><figcaption></figcaption></figure>

11. Put in the Username and Password from above:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-8782e07d930223274ed7cb5edc6d6e63c819185f%2Fimage%20(64).png?alt=media" alt="" width="563"><figcaption></figcaption></figure>

13. Then specify the Host and Database Name:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-5cf127ecb67fc386a301d59e09fc41be09cc4a5c%2Fimage%20(5)%20(1)%20(2).png?alt=media" alt="" width="272"><figcaption></figcaption></figure>

13. Now you can start upserting data with SingleStore:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-a9a62b0c3b955fe8fde1b1a9bc94a09adfff1764%2Fimage%20(6)%20(1)%20(2).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-c1a9d1baf22926db9fccb5ac7eca01b29261d69a%2Fimage%20(7)%20(1)%20(2).png?alt=media" alt=""><figcaption></figcaption></figure>

14. Navigate back to SingleStore portal, and to your database, you will be able to see all the data that has been upserted:

<figure><img src="https://823733684-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F00tYLwhz5RyR7fJEhrWy%2Fuploads%2Fgit-blob-a068612f2b5c2082387e5d1420572b772ca429b6%2Fimage%20(70).png?alt=media" alt=""><figcaption></figcaption></figure>
