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