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

Xojo cubeSQL plugin updated to 64bit

October 29th, 2015 | 2 Comments »

Hello,
as you know Xojo recently release version 2015.R3 with 64bit support.

I am happy to announce that we have updated our Xojo plugin to be both 32 and 64bit compatible, you can find the latest version from: http://www.sqlabs.com/download/cubesql/CubeSQLPlugin.xojo_plugin.zip

We also rebuild cubeSQL Admin application to be both 32 and 64bit compatible (using sources you can find on our GitHub) account. You can download the latest version from:

  1. Linux 32bit: Admin/Linux/32bit/cubeSQLAdmin.zip
  2. Linux 64bit: Admin/Linux/64bit/cubeSQLAdmin.zip
  3. MacOS 32bit: Admin/MacOS/32bit/cubeSQLAdmin.zip
  4. MacOS 64bit: Admin/MacOS/64bit/cubeSQLAdmin.zip
  5. Windows 32bit: Admin/Windows/32bit/cubeSQLAdmin.zip
  6. Windows 64bit: Admin/Windows/64bit/cubeSQLAdmin.zip

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

cubeSQL and PHP

September 1st, 2015 | No Comments »

A quick post just to let you know that a cubeSQL user has started a cubeSQL php client open source fork on github:
https://github.com/thelfensdrfer/cubesql-client.

He already added some features and fixed some issues.
Seems like a repository to watch 😉

Announcing cubeSQL 5.0.4

August 23rd, 2015 | 7 Comments »

We announce the immediate availability of cubeSQL version 5.0.4. This version includes important fixes and we recommend all users to always stay up to date.

Due to some feedbacks we also rewrote the Linux and Windows installers and separate installers are now available for both 32 and 64 bit versions. Among many important changes we also upgraded sqlite to the latest 3.8.11.1 version.

What’s new in this version:

  • 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 (was on memory db)
  • SERVER: Several others fixes and improvements
  • ADMIN: Small fixes and improvements

cubeSQL is available for MacOS X (32 and 64bit), Linux (32 and 64bit) and Windows (64bit only).

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