SingleStore June Feature Announcement – Powering Real-Time Intelligence at Scale
We’re thrilled to announce the latest features released in our SingleStore 9.0 database engine release candidate and SingleStore Helios cloud service. These deliver a host of powerful new capabilities that make it easier to build & scale real-time analytics apps, ingest data, and integrate AI into mission-critical workloads.
Simplified Ingestion, Powerful Integration
SingleStore Flow is now available for seamless, high-performance data integration from Oracle, SQL Server, MySQL, PostgreSQL, and Snowflake. With built-in Change Data Capture (CDC), automated batch scheduling, and resilience to outages, Flow enables at-scale data movement into SingleStore—no code required.
New Data Load Wizards dramatically simplify getting started with SingleStore. Load data from AWS S3, or CSV/JSON local files using an intuitive, no-code interface—no scripts, no hassle.
AI: High-Performance Compute for Notebooks & Embeddings
Notebooks enable developers to easily run SQL or Python scripts directly in the Helios cloud portal, and sharing notebooks within your organization makes collaboration easier than ever. Python LLM APIs streamline integration of AI into your applications and agents.
Scheduled Jobs allow users to easily run notebook operations on an ad-hoc or regular cadence, making it simple and scalable to manage data within SingleStore.
Cloud Functions let you deploy serverless applications directly alongside your database, enabling seamless workflows like real-time transformation, API and LLM integration, and event-driven logic without external infrastructure.
Iceberg: Real-Time Speed on Your Data Lake
Our new Iceberg “Speed Layer” gives you sub-second analytics on top of Iceberg tables without moving all your data. For latency-sensitive workloads, designate data for “fastest access” and unlock experiences like real-time dashboards, mobile apps, and responsive decisioning—all directly from your data lake.
Developer Experience: Modern, Efficient, Powerful
Sequences for auto-increment columns give smaller, readable, sequential automatic ID values, improving on our existing auto-increment and making ports from other databases easier.
Cron-Style Job Scheduling with scheduled notebooks gives you precise timing control for scheduled jobs, with familiar Cron notation.
Query History in SingleStore now includes advanced metrics like CPU, disk, network and lock times—giving developers deep visibility into query performance trends. Analyze failed, slow, and resource-intensive queries easily with configurable thresholds.
Easy Pipeline Monitoring with rich dashboards for important metrics like data ingestion volume, lag etc.
Full-Text Search Improvements, including custom column mappings and custom stop word lists, and a Korean (Nori) analyzer.
Notebook Versioning brings github version control to interactive notebooks, so you can manage, compare, and restore code with full confidence across your development lifecycle.
Performance at Scale: Smarter Optimization, Faster Queries
Automated Feedback Re-optimization enables the engine to learn from past queries and improve performance over time—automatically, and with no tuning required.
Multi-Value Indexes significantly accelerate searches over nested arrays and documents, ideal for JSON-heavy or document-centric workloads. They’re comparable to GIN indexes in PostgreSQL and help with migration from PostgreSQL and Mongo.
Vector and Text Search Improvements: improved vector index memory tracking and caching make managing and tuning vector index search easier; full-text index caching improves performance.
Shared Dev Clusters scale from lightweight startup environments to full-featured enterprise testing platforms, while Database Branching and Online PITR offer cost-effective point-in-time recovery, isolated testing, and development flexibility.
SingleStore has always supported purchases through Cloud Marketplaces, but now with our AWS Marketplace Billing API customers can charge on-demand and storage usage directly to their Marketplace account as well.