Softpedia >Mac >Developer Tools >cubeSQL >  Changelog

cubeSQL Changelog

What's new in cubeSQL 5.0.1

Mar 17, 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

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 (Jul 12, 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

New in cubeSQL 4.2.0 (Dec 16, 2011)

  • SERVER: Fixed an issue related to the DISABLE LOGIN custom command
  • SERVER: Token connect now honors 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 honored. 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.