date: 2025-12-09 title: 'Spice v1.10.0 (Dec 9, 2025)' type: blog authors: [peasee] tags: [release, caching, acceleration, dynamodb, cayenne, opentelemetry, data-connector, distributed query, performance]
Announcing the release of Spice v1.10.0! ⚡
Spice v1.10.0 introduces a new Caching Acceleration Mode with stale-while-revalidate (SWR) semantics for disk-persisted, low-latency queries with background refresh. This release also adds the TinyLFU eviction policy for the SQL results cache, a preview of the DynamoDB Streams connector for real-time CDC, S3 location predicate pruning for faster partitioned queries, improved distributed query execution, and multiple security hardening improvements.
Low-Latency Queries with Background Refresh: This release introduces a new caching acceleration mode that implements the stale-while-revalidate (SWR) pattern. Queries return cached results immediately while data refreshes asynchronously in the background, eliminating query latency spikes during refresh cycles. Cached data persists to disk using DuckDB, SQLite, or Cayenne file modes.
Key Features:
refresh_check_interval to balance freshness and source loadRecommendation: Use retention configuration with caching acceleration to ensure stale data is cleaned up over time.
Example spicepod.yaml configuration:
For more details, refer to the Data Acceleration Documentation.
Higher Cache Hit Rates for SQL Results Cache: A new TinyLFU cache eviction policy is now available for the SQL results cache. TinyLFU is a probabilistic cache admission policy that maintains higher hit rates than LRU while keeping memory usage predictable, making it ideal for workloads with varying query frequency patterns.
Example spicepod.yaml configuration:
For more details, refer to the Caching Documentation and the Moka TinyLFU Documentation for details of the algorithm.
Real-Time Change Data Capture for DynamoDB: The DynamoDB connector now integrates with DynamoDB Streams for real-time change data capture (CDC). This enables continuous synchronization of DynamoDB table changes into Spice for real-time query, search, and LLM-inference.
Key Features:
refresh_mode: changes to incrementally update accelerated datasetsNote: DynamoDB Streams must be enabled on your DynamoDB table. This feature is in preview.
Example spicepod.yaml configuration:
For more details, refer to the DynamoDB Connector Documentation.
Spice can now push metrics to an OpenTelemetry collector, enabling integration with platforms such as Jaeger, New Relic, Honeycomb, and other OpenTelemetry-compatible backends.
Key Features:
Example spicepod.yaml configuration for gRPC:
For more details, refer to the Observability & Monitoring Documentation.
S3 Location Predicate Pruning: The S3 data connector now supports location-based predicate pruning, dramatically reducing data scanned by pushing down location filter predicates to S3 listing operations. For partitioned datasets (e.g., year=2025/month=12/), Spice now skips listing irrelevant partitions entirely, significantly reducing query latency and S3 API costs.
AWS S3 Tables Write Support: Full read/write capability for AWS S3 Tables, enabling direct integration with AWS's managed table format for S3. Use standard SQL INSERT INTO to write data.
For more details, refer to the S3 Data Connector Documentation and Glue Data Connector Documentation.
Distributed query planning and execution have been significantly improved:
DistributeFileScanOptimizer improvements for faster planning with large datasetsFor more details, refer to the Distributed Query Documentation.
Search capabilities have been improved with several performance and reliability enhancements:
list_vectors calls for better performanceIndexerExec now properly handles limit pushdown for more efficient searchesFor more details, refer to the Search Documentation.
Multiple security improvements have been implemented:
top_n_sample order_by clause parsing to prevent injection attacks.clear history command in the REPL to fully clear persisted historyNo breaking changes.
No major cookbook updates.
The Spice Cookbook includes 82 recipes to help you get started with Spice quickly and easily.
To upgrade to v1.10.0, use one of the following methods:
CLI:
Homebrew:
Docker:
Pull the spiceai/spiceai:1.10.0 image:
For available tags, see DockerHub.
Helm:
AWS Marketplace:
🎉 Spice is now available in the AWS Marketplace!
list_vectors (or equivalent) when indexing into VectorIndexs by @Jeadie in #8282stale-while-revalidate pattern. by @phillipleblanc in #8365caching_stale_if_error to caching accelerator; fix multiple upstream requests during SWR; fix Arrow accelerator by @phillipleblanc in #8425