cubeSQL Xojo Plugin

April 8th, 2014 | No Comments »

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

XojoPlugin

You can download the latest version from:
http://www.sqlabs.com/download/cubesql/beta/CubeSQLPlugin.zip

cubeSQL 4.5 Special Offer

May 14th, 2013 | 1 Comment »

In order to celebrate our 4.5 release, for a very limited time, cubeSQL unlimited connection is now just $99.

Don’t miss this opportunity!

cubeSQL MacOS X Admin 4.5.1 quick fix

May 13th, 2013 | 2 Comments »

Hello,
we found an issue in the cubeSQL MacOS X Admin application (it affects only the MacOS X version and ONLY the upload/download database features).

We already rebuild all the installer packages available from:
http://www.sqlabs.com/cubesql_download.php

If you want to download just the admin app, here you go a quick link:
http://www.sqlabs.com/download/cubesql/cubeSQLAdmin_451_MacOSX.zip

cubeSQL 4.5

April 29th, 2013 | 4 Comments »

We just released cubeSQL version 4.5 with the following changes:

  • 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 (confirmed on Linux but it could affect all other platforms)
  • 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

New version is available from: http://www.sqlabs.com/cubesql/

cubeSQL 4.3 updated ObjC sdk

September 21st, 2012 | No Comments »

We just updated the ObjC sdk for cubeSQL 4.3.

Please note that it is a wrapper for the original C SDK, so you need to include the C sdk in your XCode Cocoa/iOS project in order to be able to compile it.

You can download the latest version from:
http://www.sqlabs.com/download/cubesql/CubeSQLObjC.zip

cubeSQL Special Limited Time Offer

September 3rd, 2012 | No Comments »

To celebrate the latest 4.3.0 release.
cubeSQL Unlimited Connections is just $99 for a limited time!
A $500 saving that includes one year of free updates!

Please RETWEET this special offer!!!

Announcing cubeSQL 4.3

August 29th, 2012 | No Comments »

We just released cubeSQL version 4.3 where we added SSL support, we fixed all know bugs and we improved overall performance. We recommend all our users to upgrade to version 4.3.

What’s new in version 4.3.0:

  • 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 (cubesql -h for usage)
  • 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

You can download you copy from: http://www.sqlabs.com/cubesql_download.php

cubeSQL and schedule backups

August 10th, 2012 | No Comments »

I think it’s time to write something about how to correctly setup a schedule backup with cubeSQL.

Most people don’t realise that it is a two step operation and we often receive support requests because in their opinion schedule backups do not work. I think that official documentation is not clear about this point and we plan to improve it in the next upcoming 4.3 version, in the meantime I’ll try to clarify required steps in this post.

Step 1 is to setup a schedule using the Schedules panel:

as you can see we added a new Schedule1 of type Backup, triggered every Sunday and 1:00 AM (and the Schedule Enabled checkbox is checked).

Once schedule has been created you need to ATTACH this schedule to a database in order to be able to correctly backups it. Please note that more than one schedule can be attached to a database and the same schedule can be attached to multiple databases!

Step 2 is to attach newly created schedule in the Databases panel:

select the database you want to backup and then from the Server menu select “Manage Schedules”:

From the popup menu then select newly created schedule and then press the Attach button.

cubeSQL new ODBC driver

July 9th, 2012 | 5 Comments »

Thanks to Jonathan Monroe from Actual Technologies we have another cubeSQL ODBC driver build.

The following issues remain:

  • indexes and primary keys are not returned
  • column nullability not returned for column descriptions
  • tables with date fields can’t be used as “linked tables” in MS Access
  • MS Word mail merge not yet supported
  • all text fields are concatenated together in PHP

You can download the new build in the cubeSQL download section. Please let us know of any issues you’ll find with this release.

cubeSQL on ARM processors

June 22nd, 2012 | 2 Comments »

Our Raspberry Pi is arrived… cubeSQL on ARM processors is now much more closer. Since the beginning cubeSQL has been designed to be portable to other platforms so Linux ARM porting should not be a very big task…

Stay tuned for future news ;-)