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

Check if your cubeSQL server is up and running (with StatusCake)

March 25th, 2015 | 1 Comment »

A lot of time there is the need to monitor if a server like cubeSQL is up and running (and if something goes wrong to be promptly notified). I recently discovered a nice service StatusCake which perfectly fits with the majority of these needs.

There is a free account that you can try before any further purchase. Setup a cubeSQL is really easy, just set Test type to TCP and then enter IP or hostname and port (4430 is the official cubeSQL default port, registered at IANA).

Screen Shot 2015-03-25 at 12.21.19

Once setup, you’ll have access to both a reserved area where you can monitor your service and a public page full of useful stats (optional). And note that you’ll be promptly notified by email, sms or via a http call when something goes wrong with your server.

statuscake

I strongly recommend to give StatusCake a try.

cubeSQL Admin is now open source

March 19th, 2015 | No Comments »

We’re excited to announce that cubeSQL Admin application is now open source on GitHub.

github

Repository is located at: https://github.com/cubesql/cubeSQLAdmin
If you make any improvement please share back your changes!

cubeSQL 5 with older MacOS X versions

March 12th, 2015 | No Comments »

We just setup a new installer made specifically for older MacOS X versions like 10.6, 10.7 or 10.8.
You can download it from: MacOS X Installer