cubeSQL

A fully featured and high performance sqlite based server.


Download Buy Now

cubeSQL has been deployed more than 125 million times since 2013.
Current version: 5.9.6 released on December 4th, 2024.

Image

CubeSQL Version History

  • Version 5.9.6
    December 4th, 2024

    SERVER: Updated SQLite to the latest 3.46.1 version
    SERVER: Updated LibreSSL
    SERVER: Fixed a crash for non-SSL connections
    SERVER: Added -P command line argument (to force optional verify peer even if root CA certificate is loaded)
    SERVER: Disable explicit call to tls_handshake to increase performance and to fix some reported issues
    SERVER: Fixed an issue with backups and custom suffix
    SERVER: Improved SSL support in case of certificate not found
    SERVER: Improved the DOWNLOAD DATABASE command
    SERVER: Added SQLITE_SOUNDEX macro definition
    SERVER: New ARM64 build
    SERVER: Other improvements and minor bug fixes
    C SDK: Improved connection in mixed IPv4/IPv6 environments
    C SDK: improved TLS connections without a root certificate.
    C SDK: LibreSSL static is now used in all platforms
    C SDK: Other internal improvements and minor bug fixes
    XOJO PLUGIN: Updated to the latest C SDK
    XOJO PLUGIN: New ARM64 build for Linux and Windows
    XOJO PLUGIN: Other internal improvements and minor bug fixes
    ADMIN: Updated plugin and several internal improvements
    WEB ADMIN: New 1.1.0 release (https://github.com/cubesql/webadmin)

  • Version 5.9.0
    June 28th, 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

  • Version 5.8.5
    March 19th, 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
    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
    September 29th, 2020

    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
    June 6th, 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

  • Version 5.7.0
    March 18th, 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

  • Version 5.6.1
    January 12th, 2017

    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
    November 8th, 2016

    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
    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

  • Version 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
    SERVER: Several others fixes and improvements
    ADMIN: Small fixes and improvements

  • Version 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

  • Version 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
    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
    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
    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
    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
    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
    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
    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
    August 02th, 2011

    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
    May 24th, 2011

    First public release

A fully featured and high performance relational database management system built on top of the sqlite database engine.

cubeSQL has been deployed more than 125 million times since 2013.

Buy Now



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