Announcing SQLiteManager 4.6

June 17th, 2016 | No Comments »

We are happy to announce the latest SQLiteManager 4.6.0 release with the following changes:

  1. Improved SQL parser engine.
  2. Improved support for SQLCipher encrypted databases.
  3. Improved support for Windows 8 and Windows 10.
  4. Updated sqlite to the latest 3.13.0 version.
  5. Updated SQLCipher engine to the latest 3.4.0 version.
  6. Other improvements and fixes.

This is a recommended upgrade.
You can download this version from:

Announcing cubeSQL 5.5

February 10th, 2016 | No Comments »

After several months of development we are proud to announce the immediate availability of cubeSQL 5.5.

cubeSQL 5.5 is probably the most stable version we have ever released, it also includes several performance related changes that you’ll immediately noticed when compared to older versions. SSL support has been greatly improved and thanks to Tino Gruse from Roth Soft AG we now have a complete and detailed guide about how to Setup SSL.

Important Changes
With this version we also introduced some important changes related to pricing.
The freeware version key continues to be free but the number of concurrent users has been reduced from 3 to 2.

Pricing for versions (except unlimited connections) has been reduced:

  1. 5 users from $299 to $149
  2. 10 users from $399 to $299
  3. 20 users from $499 to $399

Special Offer
In order to try to incentivate the upgrade to this latest version we are offering (for a limited time) the unlimited version for just $99 (a $500 saving).
Don’t miss this opportunity!

Complete 5.5 change history:

  • 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 is available for MacOS X (32 and 64bit), Linux (32 and 64bit) and Windows (64bit only).

cubeSQL 5.5.0 can be downloaded from:

SQLiteManager 4.5

October 7th, 2015 | No Comments »

We are happy to announce that we just released SQLiteManager 4.5.0 version with the following changes:

  • Improved CSV parser engine.
  • Improved suppor for SQLCipher encrypted databases.
  • Updated sqlite to the latest version (patched to prevent corruption after VACUUM on encrypted databases).
  • Fixed an issue in InfiniteListbox.ComputeProperties that leads to an overlap between the scrollbar and the canvas and that leads to a most critical Paint event continuously called. This slow down has finally be solved.
  • Other improvements and fixes.

This is a recommended upgrade!
You can download this version from:

Announcing cubeSQL 5

March 3rd, 2015 | 3 Comments »

After many months of development we are really happy to announce the immediate availability of cubeSQL version 5. This version represents an important milestone where we fixed all know bugs and we added a lot of important features. I’ll blog more about some of them in the upcoming weeks.

MacOS X installer has been rewritten from scratch using a custom made AppleScript application (its source code is available in the script folder inside the complete package). In this way we can support again MacOS X 10.6 and finally dropped the buggy PackageMaker app previously used for the MacOS X installer.

Due to the massive amount of work done in the SSL stuffs and thanks to the incredible support from Roth Soft AG, cubeSQL has officially been certified by a third party security and penetration testing company like Compass Security AG, specifically from its subsidiary Qualys SSL Labs.

What’s new in this version:

  • 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 is available for MacOS X (32 and 64bit), Linux (32 and 64bit) and Windows (64bit only).It can be downloaded from:

Mac App Store

October 19th, 2014 | No Comments »

I could’t agree more so I just post a link to this excellent article:

SQLiteManager 4.3.3 with SQLCipher support

September 8th, 2014 | No Comments »

We am happy to announce the immediate availability of SQLiteManager 4.3.3 that among several issues fixed it adds support for the extremely popular SQLCipher sqlite database encryption extension (256-bit AES encryption).

What’s new in version 4.3.3:

  • Added support for SQLCipher encrypted databases.
  • Fixed some printing issues.
  • Fixed issue with dump command and encrypted databases.
  • Fixed issue with add/change/remove encryption commands.
  • Fixed clustered primary keys in Table design.
  • Other issues fixe and improvements.

You can download the latest version from:


April 29th, 2014 | 2 Comments »

We are working on a major SQLiteManager 4.3 version but in the meantime we decided to release a minor update in order to fix some annoying issues with the 4.2.9 version.

You can download the latest version from:

cubeSQL and 1701 Software

April 24th, 2014 | 1 Comment »

Seattle, WA USA (April 22, 2014) — 1701 Software, Inc. announced today the immediate availability of CubeSQL database servers on their Xojo® optimized web hosting accounts. All customers will be provided free of charge an unlimited connections server license while hosting with 1701 Software. They will be able to utilize the power and flexibility of multiple SQLite databases running on their very own instance of CubeSQL server.

CubeSQL server was the first commercially available database server based on the popular SQLite database engine. It is a fully featured and high performance relational database management system created in 2005 and has continued to improve with each release. It is the ideal database server for both developers who want to convert a single user database solution to a multi-user project and for companies looking for an affordable, easy to use and easy to maintain database management system.

SQLite has always been an excellent database for use on the web. However due to the file based nature of SQLite database files it can be difficult access a single database from multiple applications simultaneously. CubeSQL provides a native Xojo® plugin that provides client based access to the CubeSQL server the desktop or web. It also supports PHP, JSON, and other development environments for easy integration in to business applications.

Customers will be able to create multiple databases on their private virtual server provided by 1701 Software free of charge. This amounts to significant savings as a software developer can start using best of breed technologies with Xojo® from the moment they sign up for web hosting. All servers are backed up on a regular schedule and replicated to geo-redundant locations providing safe and secure database backups. Customers will also be able to schedule their own backups to their private server file system.

“Xojo® developers have been spoiled by the power and flexibility of SQLite and are often disappointed in the more complex database systems” said Phillip Zedalis, Managing Developer of 1701 Software, Inc. “This is a real opportunity for our customers to create best in class web applications using the tools and platforms they already know and love.”

SQLiteManager 4.2.9

April 9th, 2014 | No Comments »

We are happy to announce a new SQLiteManager version with the following changes:

  • Added Export query in SQL pane.
  • Fixed a Foreign Key issue in some custom alter table commands.
  • Fixed some CSV import issues.
  • Updated underline text engine.
  • Updated sqlite to the latest version.
  • Other small issues has been fixed.
  • A lot of other improvements.

New version available from:

P.S. We submitted version 4.2.9 to the Mac App Store too, it should be available soon.

cubeSQL Xojo Plugin

April 8th, 2014 | No Comments »

We just upgraded cubeSQL plugin for Xojo with support for Cocoa, Carbon MachO, Linux and Windows.


You can download the latest version from: