What’s New¶

This document outlines features and improvements from each release.

Note

All releases before v1.0.0 are considered pre-release and are for non-production testing and evaluation, and may include changes to the API.

v1.14.0 - May 29, 2025¶

Add vector_db interface

v1.13.0 - April 16, 2025¶

Refactor external function server (experimental) type system

v1.12.4 - April 2, 2025¶

Back out charset setting code

v1.12.3 - April 1, 2025¶

Fix default charset issue

v1.12.2 - March 19, 2025¶

Fix workspace group lookup in some Fusion SQL commands

v1.12.1 - March 10, 2025¶

Fix struct formatting issue in vector result support
Add cloud notebook information to client version
Fix IN GROUP clause in Fusion SQL for files
Fix file-like objects in file upload APIs

v1.12.0 - February 27, 2025¶

Add support for external TVFs
Add support for pyarrow Table and pandas / polars DataFrames return values in external functions
Add support for return value field names
Add support for dataclasses and Pydantic external function parameter and return value definitions
Add singlestoredb.server.docker and singlestoredb.server.free_tier server interfaces
Fix vector result conversions when numpy is not installed

v1.11.0 - January 9, 2025¶

Fix connection memory leak
Add Fusion SQL commands for managing models

v1.10.0 - December 10, 2024¶

Add %run_shared and %run_personal magics
Update doc for Export service Fusion SQL commands

v1.9.0 - December 4, 2024¶

Add Fusion SQL commands for personal and shared files
Add Fusion SQL commands for Iceberg egress service
Add tls_sni_servername to connection
Fix special character parsing in connection URLs

v1.8.0 - November 19, 2024¶

Add Fusion SQL commands for scheduled notebooks

v1.7.2 - October 16, 2024¶

Fixes for apps

v1.7.1 - September 20, 2024¶

Fixes for apps

v1.7.0 - September 20, 2024¶

Add dashboard and code as a service functions

v1.6.3 - September 5, 2024¶

Fix HTTP (Data API) driver timeout
Add client_found_rows option to connection

v1.6.2 - August 6, 2024¶

Fix string length calculation

v1.6.1 - July 31, 2024¶

Fix memory leak in connections

v1.6.0 - July 29, 2024¶

Add job service Fusion commands

v1.5.0 - July 12, 2024¶

Add USE WORKSPACE Fusion command
Add vector_data_format= to connection options to specify JSON or BINARY for vector data

v1.4.3 - July 10, 2024¶

Purge expired JWTs from get_token as needed

v1.4.2 - July 9, 2024¶

Fix Javascript function name in portal object

v1.4.1 - July 2, 2024¶

Fix binary vector conversions
Add async events for JWT updates

v1.4.0 - June 13, 2024¶

Add ai module

v1.3.1 - May 23, 2024¶

Fix encoding_errors= option

v1.3.0 - May 10, 2024¶

Add ability to use iterables and queues as the source of LOCAL INFILE

v1.2.0 - April 25, 2024¶

Added support for vector data type conversions in query results
Added singlestoredb.notebook module for interacting with portal objects

v1.1.0 - April, 18 2024¶

Added new result types: numpy, pandas, polars, arrow
Added SHOW FUSION HELP command and doc to Fusion SQL handlers

v1.0.4 - April, 3 2024¶

Management API updates

v1.0.3 - April, 2 2024¶

Updates to external function application API
Add configuration parameter for Management API base URL

v1.0.2 - March, 8 2024¶

Add singlestoredb.management.get_secret function
Add add_endpoint_to_firewall_ranges= parameter to create_workspace

v1.0.1 - February, 16 2024¶

Fix issues in Fusion SQL Stage commands
Add call function to UDF app

v1.0.0 - February, 12 2024¶

Update Stage API
Fixes for deferred connections

v0.10.7 - January 31, 2024¶

Add secrets managemnt to Management API
Refactor UDF data converters

v0.10.6 - January 26, 2024¶

Add Fusion SQL handlers for suspend and resume
Various Fusion SQL handler fixes

v0.10.5 - January 23, 2024¶

Add pytest plugin

v0.10.4 - January 18, 2024¶

Fix deferred connection URL in HTTP

v0.10.3 - January 17, 2024¶

Change Stage URLs
Fix password encoding in deferred connections

v0.10.2 - December 14, 2023¶

Make workspace group optional in Fusion SQL if it is specified in the environment

v0.10.1 - December 13, 2023¶

Cache regions in Management API
Add dummy fields to Region objects if the region ID does not point to an existing region

v0.10.0 - December 12, 2023¶

Add JWT authentication support to Fusion
Add experimental vector data format support to UDF server
Rename stages to stage
Add track_env connection parameter to automatically track the SINGLESTOREDB_URL environment variable

v0.9.6 - November 2, 2023¶

Fusion fixes and testing

v0.9.5 - October 31, 2023¶

Add defaults for builtin Fusion rules

v0.9.4 - October 31, 2023¶

More Fusion enhancements

v0.9.3 - October 25, 2023¶

Fusion fixes

v0.9.2 - October 24, 2023¶

Experimental Fusion SQL interface

v0.9.1 - October 17, 2023¶

Add name / ID indexing to workspace groups / workspaces / regions

v0.9.0 - October 16, 2023¶

Add Stage to Management API

v0.8.9 - October 4, 2023¶

Add debug option for connections

v0.8.8 - September 26, 2023¶

Fix error propagation issue in C extension

v0.8.7 - September 19, 2023¶

Add encoding_errors= parameter to connection

v0.8.6 - August 29, 2023¶

Fix WITH statements in HTTP

v0.8.5 - August 29, 2023¶

Fix DESCRIBE statements in HTTP

v0.8.4 - August 28, 2023¶

Fix boolean connection options

v0.8.3 - August 23, 2023¶

Fix % escaping in HTTP queries

v0.8.2 - August 10, 2023¶

Add nan_as_null and inf_as_null options for parameter conversion support
Separate structsequences and namedtuples for results_type
Performance improvements of binary data uploads

v0.8.1 - July 12, 2023¶

Add create_engine function to return SQLAlchemy engine while supporting environment variable parameter settings and settings in options

v0.8.0 - July 12, 2023¶

! Python 3.8 is now the minimum required version
Add parameter conversion routines to HTTP driver

v0.7.1 - June 15, 2023¶

Add connect_timeout and multi_statements options to connection

v0.7.0 - June 9, 2023¶

Add converters for numpy array to vector blobs, and pygeos / shapely objects to geography data

v0.6.1 - May 18, 2023¶

Fix GSSAPI/Kerberos packet data

v0.6.0 - May 17, 2023¶

Added GSSAPI/Kerberos support

v0.5.4 - March 15, 2023¶

Added expiration to workspaces

v0.5.3 - January 9, 2023¶

Fixed issue with parsing numeric results

v0.5.2 - December 14, 2022¶

Fixed issues with unbuffered reads

v0.5.1 - December 9, 2022¶

Added 32-bit Windows and aarch64 Linux packages
Added option to log queries

v0.5.0 - December 8, 2022 (API CHANGES)¶

! Query parameter syntax has changed from :1 for positional and :key for dictionary keys to %s for positional and %(key)s for dictionary keys
! results_format connection parameter has changed to results_type
High-performance C extension added
Added ssl_verify_cert and ssl_verify_identity connection options
Add Python 3.11 support

v0.4.0 - October 19, 2022¶

Add Python 3.6 support

v0.3.3 - September 21, 2022¶

Add ssl_cipher option to connections
Add show accessor for database SHOW commands

v0.3.2 - September 14, 2022¶

Fixes for PyMySQL compatibility

v0.3.1 - September 9, 2022¶

Changed cipher in PyMySQL connection for SingleStoreDB Cloud compatibility

v0.3.0 - September 9, 2022¶

Changed autocommit=True by default

v0.2.0 - August 5, 2022¶

Changed to pure Python driver
Add workspace management objects
Added auth.get_jwt function for retrieving JWTs

v0.1.0 - May 6, 2022¶

DB-API compliant connections
HTTP API support
Cluster manager interface