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.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