CubeSQL Version History
A fully featured and high performance relational database management system built on top of the sqlite database engine.
cubeSQL has been deployed more than 124 million times since 2013.
cubeSQL with up to 2 concurrent connections is now Freeware. Request your free key today!
Requirements
- MacOS 10.7 or higher
- Windows VISTA/7sp1/8/10 or higher
- Linux kernel 2.6.2 or higher
Version 5.9.0
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
Version 5.8.5
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
LINUX: New RaspberryPi native build
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
Version 5.8.0
SERVER: Added built-in support for OpenSSL (via LibreSSL). No need to install OpenSSL on the host system
SERVER: Updated SQLite to the latest 3.33.0 release
SERVER: Updated macOS Pref Panel
SERVER: Improved VM commands
SERVER: Internal performance improvements
SERVER: A lot of other improvements and minor bug fixes
MACOS: Updated Preference Panel
MACOS: 32 bit build is no longer available (you should use CubeSQL version 5.7.2 instead)
LINUX: Updated installer to support systemd
XOJO PLUGIN: Added support for Xojo API 2.0
C SDK: Updated SDK
Version 5.7.2
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
Version 5.7.0
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
Version 5.6.1
SERVER: Upgraded sqlite to version 3.16.1
SERVER: Fixed an issue introduced in version 5.6.0 related to not correctly closed connections
SERVER: Other improvements and fixes
ADMIN: General improvements and better Hi-DPI support
Version 5.6.0
SERVER: Upgraded sqlite to version 3.15.0
SERVER: Fixed an issue related to SSL connections
SERVER: VMBind commands now honor the max_commandlen value
SERVER: The startup -i parameter is now correctly handled
SERVER: Improved client disconnection
SERVER: Improved SSL check
SERVER: Other improvements and fixes
PLUGIN: Fixed issue with db.InsertRecord and rs.Update methods
ADMIN: General improvements
INSTALLER MAC: Added Sierra compatibility
INSTALLER LINUX: Improved modern Linux compatibility
Version 5.5.0
SERVER: Improved sqlite native plugins detection
SERVER: Improved external database engine support
SERVER: Improved SSL support
SERVER: Improved JSON support
SERVER: Upgraded sqlite to version 3.10.2
SERVER: Fixed a corruption issues related to encrypted sqlite databases and VACUUM command
SERVER: Fixed several issues related to SSL connections
SERVER: Fixed several issue related to Windows
SERVER: Maximum number of shared databases is now a dynamic value that can be set from the command line
SERVER: Other fixes and improvements
OTHERS: Added new native PHP connector
OTHERS: Improved SSL manual
PLUGIN: Xojo plugin available for 64bit systems
Version 5.0.4
SERVER: Fixed disabled login issue
SERVER: Workaround for unable to block on epool issue on some Linux systems
SERVER: Upgraded sqlite to the latest 3.8.11.1 version
SERVER: Better Windows version information
SERVER: Several issues fixed for external database engines
SERVER: Fixed several dynamic loading issues
SERVER: Improved native sqlite plugins detection
SERVER: Fixed cryptic error messages in encrypted connections
SERVER: Added Connection reset by peer log
SERVER: Added UPLOAD_FILE and DOWNLOAD_FILE privilege
SERVER: Added ENGINE SELECT/EXECUTE
SERVER: ENGINE commands now bounds to groups
SERVER: DROP USER also removes from preference file
SERVER: Several others fixes and improvements
ADMIN: Small fixes and improvements
Version 5.0.1
SERVER: Fixed an issue that prevents correct loading of certain plugins
SERVER: Fixed an issue with disabled logins
SERVER: Fixed an issue with current connection counter
SERVER: Fixed an issue with manual backup path
ADMIN: Small fixes and improvements
OTHER: Improved Mac Installer
Version 5.0.0
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
SERVER: Added CLOSE database command
SERVER: Upgraded sqlite to version 3.8.7
SERVER: Added a new command line parameter to specify custom log directory location
SERVER: Added support for UNICODE61
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
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
Version 4.5.0
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
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
Version 4.3.0
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
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
Version 4.2.0
SERVER: Fixed an issue related to the DISABLE LOGIN custom command
SERVER: Token connect now honours clear/encrypt disabled login
SERVER: Fixed an issue related to double single quote in custom commands
SERVER: Fixed a crash bug that affects all platforms triggered by heavy load
SERVER: Added ADD LOG ENTRY custom command in order to allows client to add messages to the log file
SERVER: Fixed a Windows only crash bug
SERVER: Fixed a Windows only hang
SERVER: Fixed all the issues that triggers an incorrect "db is locked" error message
SERVER: Updated sqlite to version 3.7.8
SERVER: Running time for a developer key has been increased to 4 hours
SERVER: There is now a way to specify maximum number of backups to retain per database
SERVER: Fixed several JSON related issues
SERVER: Dramatically improved JSON queries performance
SERVER: A lot of others small fixes and improvements
SERVER: Updated C SDK
SERVER: There is now a native 32bit and 64bit DLL SDK for Windows native connections
PLUGIN: Timeout value is now properly honoured. Set it to 0 if you want to wait MAX_TIMEOUT value
PLUGIN: Added support for REAL Server and REAL SQL Server protocol, just set the db.useREALServer As Boolean property BEFORE db.Connect.
Version 4.1.0
SERVER: PING timeout is now a per connection property
SERVER: Fixed a Linux memory leak
SERVER: Fixed a couple of possible crashes
SERVER: Fixed some Authorisation plugin related issues
SERVER: Fixed an issue related to the SHOW DATABASE INFO command
SERVER: Foreign key support is now ON by default
SERVER: Fixed a crash related to custom plugins
SERVER: Added RENAME DATABASE custom command
SERVER: Added SET BASE64 REGISTRATION TO name WITH KEY value custom command
SERVER: Fixed a couple of JSON related issues
SERVER: Fixed some issues related to Win32 Service Manager
SERVER: Admin privileges associated to a database should now work in the same way as REAL Server
SERVER: Added support for Prepared statements
SERVER: Updated sqlite to the latest 3.7.7.1 version
SERVER: Other small fixes and optimisations
ADMIN: Fixed a nil object exception in the Console Panel
ADMIN: Added the News Panel
ADMIN: MVCC enable/disable is now a button
C SDK: Added support for Prepared statements
PLUGIN: Updated SDK with some more client related functions
OSX: Fixed a crash in the OSX PrefPane
Version 4.0.0
First public release