cubeSQL Xojo and REALbasic plugins

December 2nd, 2014 | No Comments »

We just updated both Xojo and REALbasic plugins to a stable 1.9.6 version. If you use any of them to connect to cubeSQL you are recommended to upgrade the plugin.

Latest version can be downloaded from:
http://www.sqlabs.com/download/cubesql/cubeSQLPlugin.zip

cubeSQL 4.5 and Yosemite

October 18th, 2014 | 2 Comments »

With the recent release of Yosemite, Apple changed the way startup items works (they removed support for the old StartupItems way).

So in order to automatically launches cubeSQL on system startup you need to copy the script:
http://www.sqlabs.com/download/cubesql/others/cubesql_startup.tgz
into the system folder: /Library/LaunchDaemons

Make sure the plist has the following privileges:
pListPrivileges

To change plist privileges from the Terminal just type:
sudo chown root:wheel com.sqlabs.cubesql.plist

Please note that the upcoming cubeSQL version 5 will automatically take care of the change.

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!!!