SQLiteManager 4.6.8

December 1st, 2016 | No Comments »

We just released SQLiteManager 4.6.8 release with the following changes:

  1. Fix for WITH queries.
  2. Updated FTC.
  3. Fix a crash issue.
  4. Improved HiDPI support.
  5. New Windows 64bit build.
  6. Several other internal enhancements and fixes.

This is a recommended upgrade.
You can download this version from: http://www.sqlabs.com/sqlitemanager/

Announcing cubeSQL 5.6

November 8th, 2016 | No Comments »

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

Version History:

  • 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

Special Offer
In order 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!

 
cubeSQL 5.6 fixes all know issues and it also includes several performance related changes that you’ll immediately noticed when compared to older versions. cubeSQL is available for MacOS X (32 and 64bit), Linux (32 and 64bit) and Windows (32 and 64bit).

cubeSQL 5.6.0 can be downloaded from:
http://www.sqlabs.com/cubesql_download.php

SQLiteManager 4.6.6 updated for MacOS only

September 23rd, 2016 | No Comments »

Due to an incorrect signing certificate, SQLiteManager 4.6.5 could have some issues on Mac.
We fixed the problem and we already replaced the damaged executable.

Please download the fixed MacOS only version from:
http://www.sqlabs.com/download/SQLiteManager.zip

Announcing SQLiteManager 4.6.5

September 19th, 2016 | No Comments »

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

  1. Performance enhancements.
  2. Updated FTC to the latest 3.1.6 version.
  3. Fixed an issue in HexEdit mode.
  4. Fixed a parsing issue that could lead to a wrong constraint table type.
  5. On Mac windows positions and size associated to each local database are now preserved.
  6. If database contains some data then default to Data tab on open.
  7. Various fixes and improvements.

This is a recommended upgrade.
You can download this version from: http://www.sqlabs.com/sqlitemanager/

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: http://www.sqlabs.com/sqlitemanager/

Updated cubeSQL Xojo plugin

June 12th, 2016 | No Comments »

cubeSQL Xojo plugin has been updated to version 1.9.8.
Plugin is available for Mac, Windows and Linux (32 and 64bit version).


XojoPlugin

This build fixes an issue with binary data and db.InsertRecord and rs.Update Xojo methods. Please note that due to an internal Xojo issue, Xojo 2015r2.2 or higher is required.

You can download the latest version from: CubeSQLPlugin.xojo_plugin.zip

cubeSQL on Synology NAS

June 6th, 2016 | 4 Comments »

Thanks to Christopher Rieke, there is now an installer that is able to install cubeSQL on Synology NAS.

You can download installer script from: synology_cubesql.spk

Some details:

  • Script is tested only on 64bit systems and depends from the return value of the the “uname -m” command.
  • You can also check out the content of the spk file by extracting it with “tar -cvf
  • You need to create a shared folder called “cubeSQL” to be able to successfully launch cubeSQL.
  • He decided to store databases and settings there. So it is easy to make a backup of these folders.
synology_web_gui

The art of indexing

May 12th, 2016 | No Comments »

Indexing a database seems more art than science and proper indexes can have a tremendous speed up for your queries. This really nice talk can help to make better decision and more important can help to make better index design:

  

cubeSQL Connectors

March 25th, 2016 | No Comments »

Just a short post to announce the immediate availability of a new GitHub repository where we plan to post as open source the various cubeSQL connectors out there.

In this first version we started with the PHP connector, both the traditional JSON based one and a new native PHP connector.

Additional contributors are more than welcome.
https://github.com/cubesql/connectors

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:
http://www.sqlabs.com/cubesql_download.php