Path: blob/main/docs/src/whatsnew.rst
469 views
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.15.4 - September 4, 2025 --------------------------- * Fix precision values for decimals (#91) v1.15.3 - August 27, 2025 ------------------------- * Fix error and memory handling in the C extension v1.15.2 - August 18, 2025 ------------------------- * Fixed object attribute 'servers' error in UDF application (#87) (experimental) * Added enforcement for function definition limits (#86) * Improved error handling for mismatched numpy versions * Updated documentation with scheduled jobs information * Improved UDF application logging (experimental) v1.15.1 - August 7, 2025 ------------------------ * Add more validation of UDF type parameters in UDF app (experimental) * Add docstring information to function information returned by UDF app (experimental) * Update OpenAI wrapper * Fix starter workspace connections * Fix management API HTTP requests with extra parameters v1.15.0 - July 21, 2025 ----------------------- * Fix issues with SQL notebook cells in notebooks called from `%run_shared` or `%run_personal` * Add starter workspace objects to Management API * Add async support, timeouts, logging, and the ability to cancel UDFs in the UDF ASGI application (experimental) v1.14.2 - June 16, 2025 ----------------------- * Fixes for Iceberg export Fusion SQL (experimental) v1.14.1 - June 10, 2025 ----------------------- * Add additional Fusion SQL commands for Iceberg export (experimental) * Fix unsigned ints in Data 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