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

cubeSQL 5 Special Offer

March 11th, 2015 | No Comments »

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

Don’t miss this opportunity!

cubeSQL 5 and Mavericks/Yosemite Firewall (updated)

March 11th, 2015 | 2 Comments »

If you have firewall turned ON on your Mavericks/Yosemite system that you could have troubles running cubeSQL because its default 4430 port could be blocked by default.

Starting from Yosemite OS X 10.10 ipfw has been removed (ipfw was the previous Mac firewall that could be easily configured using command line parameters and it has been replaced by pfctl). pfctl seems to prefer configuration files to command line parameters, which I find frustrating and it is a bit more complicated to configure. The ideal solution would have been to have it automatically configured within cubeSQL Mac installer but there are so many options that I prefer to have your configuration rules not touched and leave that option to you.

As someone suggested you can use a couple of nice freeware utilities which are basically a fronted to the command line described below. My personal suggestion is for: Icefloor but I think that Murus should also work fine. The only required thing to do is just to open the default 4430 TCP port used by cubesql.

So here you go a step by step terminal instructions (mostly taken from http://tinyurl.com/lz5y2sb):

sudo vim /etc/pf.conf

Add this line to the config file (after the com.apple anchor is fine) where en0 is your ethernet adapter and port 4430 is the port you’re using in cubeSQL:

pass in on en0 proto tcp from any to any port 4430

This allows TCP data on port 4430 to pass into your machine via en0. This allows it from any IP address, but you could have changed the first mention of “any” to an IP address in order to only allow from a single IP address.

If you aren’t using a wired connection, you can change en0 to en1, or if you’re uncertain which adapter you’re using, run the following command to see which is active on your setup, noting which has a status of “active”:

ifconfig

Save the config file and run the following to reload the config file, and verify using verbose:

sudo pfctl -vnf pf.conf

I also ran this, just in case:

sudo pfctl -Rf pf.conf

Yes it is not easy nor intuitive but this is the only solution if you want to have your firewall turned ON on Mac. (I promise that I’ll try to find out a better and preferably automated way to setup the firewall.)