cubeSQL Version History

    cubeSQL 5.5.0 (February 10th, 2016)
    • 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
    cubeSQL 5.0.4 (August 23th, 2015)
    • 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 (was on memory db)
    • SERVER: Several others fixes and improvements
    • ADMIN: Small fixes and improvements
    cubeSQL 5.0.1 (March 11th, 2015)
    • 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
    cubeSQL 5.0.0 (March 2nd, 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
    cubeSQL 4.5.0 (April 29th, 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
    cubeSQL 4.3.0 (August 27th, 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
    cubeSQL 4.2.0 (October 31th, 2011)
    • 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 (error 7055)
    • SERVER: Updated sqlite to version 3.7.8
    • SERVER: Running time for a developer key has been increased to 4 hours (was 2 hours)
    • SERVER: There is now a way to specify maximum number of backups to retain per database (to avoid disk is full error), in order to activate it just use the custom command: SET PREFERENCE MAX_BACKUPS TO value
    • 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 (default to 900 seconds but you can change it via the SET PREFERENCE MAX_TIMEOUT TO value).
    • PLUGIN: Added support for REAL Server and REAL SQL Server protocol, just set the db.useREALServer As Boolean property BEFORE db.Connect.
    cubeSQL 4.1.0 (August 02th, 2011)
    • SERVER: PING timeout is now a per connection property (and not a global 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
    cubeSQL 4.0.0 (May 24th, 2011)
    • First public release