Notebook Icon

Developers

Guides

SingleStore Database Cheat Sheet

List of useful commands for SingleStore SQL and Kai (MongoDB API) operations.

Programming & Integrations

How To Stream Real-Time Data Into SingleStore From Estuary Flow with Dekaf

Discover how Estuary Flow’s Dekaf enables seamless change data capture (CDC) for streaming data into SingleStore. This guide explores Dekaf’s key features, its integration with SingleStore, and step-by-step instructions for setting up a PostgreSQL data capture pipeline.

Real-timeIngestProgramming & Integrations

Optimizing Table Data Structures

Learn how to select the right shard, rowstore, and columnstore keys to improve performance and efficiency based on your workload.

Data ManagementPerformance

The Complete Guide to Scaling Elasticsearch

Master the art of scaling Elasticsearch to enhance performance. Discover practical strategies and tips to optimize your setup.

PerformanceData ManagementIngest

How to Fix MySQL Error: 'the table is full'

The “table is full” MySQL error is one of the most frustrating errors you can encounter. Here's what it means and the steps to resolve it.

Data Management

How to Fix MySQL Error 1040: Too Many Connections

Understand what the error means and how to resolve it with configuration tweaks and following best practices.

Performance

How to Load 100 Billion Rows of Data Ultrafast

Learn efficient strategies for loading massive datasets into SingleStore, focusing on pipelines, cluster setup, and best practices to swiftly upload and verify 100 billion rows of data.

IngestPerformance

A Beginner’s Guide to Vector Embeddings

The fundamentals of vector embeddings, including their types, applications and implementation.

VectorsAI / ML

A Beginner's Guide to LangChain

Explore the fundamentals of LangChain, including its core functionalities, a step-by-step tutorial to kickstart your journey, prompt templates, chain creation, and developing applications using a LangChain LLM.

AI / MLProgramming & Integrations