whatsnew.rst.txt

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