cubeSQL Changelog
What's new in cubeSQL 5.9.0
Jun 28, 2022- SERVER: Improved performance in several internal commands
- SERVER: Updated SQLite to the latest 3.38.5.1 version
- SERVER: Updated LibreSSL to the latest 3.5.3 version
- SERVER: Fixed an issue with the SHOW BACKUPS command
- SERVER: Fixed an issue with the MAX_BACKUPS settings
- SERVER: Fixed a cache authorization issue
- SERVER: Fixed an issue with database encryption command
- INSTALLER: Rebuilt native ARM macOS installer
New in cubeSQL 5.8.5 (Mar 19, 2021)
- SERVER: Updated SQLite to the latest 3.35.0 release
- SERVER: Added support for the new built-in SQLite math functions
- SERVER: Added support for WITH and RETURNING SQLite clauses
- SERVER: Fixed an issue with VMSelect commands used by Xojo plugins
- SERVER: Improved error logging for scheduled backups
- SERVER: Fixed a backup database bug
- SERVER: Other improvements and minor bug fixes
- MACOS: New ARM (M1) processor native build
- MACOS: Fixed several issues with Preference Panel
- MACOS: Preference Panel is now available for ARM processor (M1)
- XOJO PLUGIN: Fixed an issue with Currency values
- XOJO PLUGIN: Improved Xojo API 2.0 support
New in cubeSQL 5.7.1 (Jun 7, 2019)
- SERVER: Added a way to control memory usage to avoid huge queries creation
- SERVER: Added protocol information for each connected client
- SERVER: Added FOR KEY variant to SHOW INFO and SHOW MY INFO custom commands
- SERVER: Fixed an issue related to Freeware registration
- SERVER: Fixed an issue related to RESET SCHEDULE command
- SERVER: A lot of other improvements and minor bug fixes
- MACOS: Updated Preference Panel
- XOJO PLUGIN: Windows OpenSSL dynamic load issue fixed
- XOJO PLUGIN: Fixed issues related to NULL values
- C SDK: Updated SDK
New in cubeSQL 5.7.0 (Mar 17, 2019)
- SERVER: Upgraded sqlite to version 3.27.2
- SERVER: Fixed an issue with RESET SCHEDULE command
- SERVER: Improved IP address resolution
- SERVER: Added support for OpenSSL version 1.1 or higher
- SERVER: Added support for IPv6 protocol
- SERVER: Added a way to customize backup path directly within the scheduler
- SERVER: Various Windows specific fixes
- SERVER: Added SSL/Crypto custom path
- SERVER: A lot of other improvements and bug fixes
- ADMIN: A lot of improvements and bug fixes
- XOJO PLUGIN: All know issues has been fixed
- XOJO PLUGIN: Updated to the latest Xojo SDK version
- XOJO PLUGIN: Added support for Raspberry Pi
- C SDK: Updated SDK
- INSTALLER: All installers has been updated
New in cubeSQL 5.6.1 (Apr 25, 2017)
- SEerver:
- Upgraded sqlite to version 3.16.1
- Fixed an issue introduced in version 5.6.0 related to not correctly closed connections
- Other improvements and fixes
- Admin:
- General improvements and better Hi-DPI support
New in cubeSQL 5.0.0 (Mar 3, 2015)
- SERVER: Added new FILE UPLOAD/DOWNLOAD capabilities
- SERVER: Added ATTACH/DETACH database commands
- SERVER: Added shared cache mode options
- SERVER: Added zipfs sqlite support
- SERVER: Added ability to open databases outside of the "databases" folder
- SERVER: Added cubesql_register_tokenizer to plugin SDK
- SERVER: Added custom JSON startup config file support
- SERVER: Greatly enhanced SSL security to both client and server
- SERVER: Added peer client verification to SSL
- SERVER: Added new SSL+AES encryption
- SERVER: Added the ability to bridge to different database engines (PostgreSQL fully supported)
- SERVER: Added CLOSE database command (to completely unload database)
- SERVER: Upgraded sqlite to version 3.8.7 (up to 50% faster than cubeSQL 4.5)
- SERVER: Added a new command line parameter to specify custom log directory location
- SERVER: Added support for UNICODE61 (in FTS3/4)
- SERVER: Fixed issue with non native connections
- SERVER: Fixed some JSON over TCP issues
- SERVER: Improved JSON handling
- SERVER: Fixed some Win32 related issues
- SERVER: Win32 DLL now loaded from a custom DLL directory (with 32/64bit subdirectories)
- SERVER: Removed MVCC code
- SERVER: Improved set resource limits on Mac and Linux
- SERVER: Several others fixes and improvements
- ADMIN: IP address is now reported on Log pane
- ADMIN: Overall improvements and fixes
- OTHER: Updated cubeSQL Preference Pane on MacOS X
- OTHER: New startup script on MacOS X
- PLUGIN: New Xojo plugin format in addition to Real Studio format
- PLUGIN: Now correctly detects when SSL is not installed
- PLUGIN: Added support for new SSL+AES encryption protocol
New in cubeSQL 4.5.0 (May 2, 2013)
- SERVER: Minimum client buffer size has been increased from 4KB to 16KB
- SERVER: Added a new SET PREFERENCE MINIMUM_BUFFER_SIZE TO preference value to set clients buffer
- SERVER: Updated sqlite to the latest 3.7.16.2 version
- SERVER: Fixed a JSON queries related buffer size issue
- SERVER: Fixed a JSON related memory leak
- SERVER: Fixed a SHELL schedule issue
- SERVER: Some fixes to the scheduler subsystem
- SERVER: Changed syntax for the RESET SCHEDULER custom command
- SERVER: Introduced a new DATABASE_ADMIN privilege
- SERVER: Fixed a rare crash (confirmed on Linux but it could affect all other platforms)
- SERVER: Fixed all JSON UTF-8 encoding/escaping issues
- SERVER: New token connection to disable third party apps to connect to a private server:
- SET PREFERENCE 'SECRET_TOKEN' TO 'my_secret_token_string';
- SET PREFERENCE 'TOKEN_CONNECTIONS_ONLY' TO '1';
- SERVER: Added a new AUTOMATIC_ROWID_ENABLED preference setting
- ADMIN: Overall improvements
- ADMIN: Improved Retina support on MacOS X
- PHP: Fixed an issue due to empty recordset returned by JSON
- PHP: Added the connect_database method
- ADMIN: Other minor fixes and improvements
- C SDK: Small fixes
New in cubeSQL 4.3.0 (Oct 1, 2012)
- SERVER: Updated sqlite to version 3.7.13
- SERVER: Added a new MAX_CONNECTIONS preference key to allow third party developers to limit number of allowed connections
- SERVER: Added DOWNLOAD BACKUP DATABASE dbName WITH TIMESTAMP value custom command
- SERVER: Fixed a rare issue that can affect old Windows distributions related to spurious console commands
- SERVER: Improved UNC and Network paths handling under Windows
- SERVER: Fixed a rare DOWNLOAD DATABASE crash bug
- SERVER: Fixed a small log issue related to vm commands
- SERVER: Added SSL support
- SERVER: Added DROP PREFERENCE 'key' custom command
- SERVER: Added ENCRYPT DATABASE dbName WITH KEY newKey custom command
- SERVER: Added DECRYPT DATABASE dbName custom command
- SERVER: Improved REMOVE USER FROM GROUP custom command
- SERVER: Improved CREATE DATABASE IF EXISTS custom command
- SERVER: Improved handling of UTF-16 encoded databases
- SERVER: SET PREFERENCE BACKUP_PATH on Windows now correctly handle UNC and Network paths
- SERVER: While disconnecting client now waits at maximum 6 minutes if a backup operation is in progress
- SERVER: Added preference key SSL_CONNECTIONS_ONLY
- SERVER: Fixed a realsqlserver.settings migration bug
- SERVER: Fixed a bug related to MVCC turned ON and CREATE TABLE command when that table already exists
- SERVER: Improved debug output for Windows Service events
- SERVER: Fixed a rare Linux 32bit crash bug triggered by vmselect
- SERVER: Added -q and -m startup parameters (cubesql -h for usage)
- SERVER On some Windows distributions do not stop cubeSQL service if user disconnects
- ADMIN: New icon
- ADMIN: New SSL connection option
- ADMIN: On Linux now checks if libgtkhtml is installed before opening the News panel
- ADMIN: Other minor fixes and improvements
- PLUGIN: New SSL options
- C SDK: New SSL options