cubeSQL Version History

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