Where to download older cubeSQL versions?

August 25th, 2014 | No Comments »

Just setup a dedicated download page for older cubeSQL versions:
http://www.sqlabs.com/cubesql_older_versions.php

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.”

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.