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 commandAdd
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
functionAdd
add_endpoint_to_firewall_ranges=
parameter tocreate_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
tostage
Add
track_env
connection parameter to automatically track theSINGLESTOREDB_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
andinf_as_null
options for parameter conversion supportSeparate
structsequences
andnamedtuples
forresults_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
andmulti_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 toresults_type
High-performance C extension added
Added
ssl_verify_cert
andssl_verify_identity
connection optionsAdd 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 connectionsAdd
show
accessor for databaseSHOW
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