Xojo cubeSQL plugin updated to 64bit

October 29th, 2015 | 2 Comments »

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

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

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.


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.


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 | 2 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”:


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

Announcing cubeSQL 5

March 3rd, 2015 | 3 Comments »

After many months of development we are really happy to announce the immediate availability of cubeSQL version 5. This version represents an important milestone where we fixed all know bugs and we added a lot of important features. I’ll blog more about some of them in the upcoming weeks.

MacOS X installer has been rewritten from scratch using a custom made AppleScript application (its source code is available in the script folder inside the complete package). In this way we can support again MacOS X 10.6 and finally dropped the buggy PackageMaker app previously used for the MacOS X installer.

Due to the massive amount of work done in the SSL stuffs and thanks to the incredible support from Roth Soft AG, cubeSQL has officially been certified by a third party security and penetration testing company like Compass Security AG, specifically from its subsidiary Qualys SSL Labs.

What’s new in this version:

  • SERVER: Added new FILE UPLOAD/DOWNLOAD capabilities
  • SERVER: Added ATTACH/DETACH database commands
  • SERVER: Added shared cache mode options
  • SERVER: Added zipfs sqlite support
  • SERVER: Added ability to open databases outside of the “databases” folder
  • SERVER: Added cubesql_register_tokenizer to plugin SDK
  • SERVER: Added custom JSON startup config file support
  • SERVER: Greatly enhanced SSL security to both client and server
  • SERVER: Added peer client verification to SSL
  • SERVER: Added new SSL+AES encryption
  • SERVER: Added the ability to bridge to different database engines (PostgreSQL fully supported)
  • SERVER: Added CLOSE database command (to completely unload database)
  • SERVER: Upgraded sqlite to version 3.8.7 (up to 50% faster than cubeSQL 4.5)
  • SERVER: Added a new command line parameter to specify custom log directory location
  • SERVER: Added support for UNICODE61 (in FTS3/4)
  • SERVER: Fixed issue with non native connections
  • SERVER: Fixed some JSON over TCP issues
  • SERVER: Improved JSON handling
  • SERVER: Fixed some Win32 related issues
  • SERVER: Win32 DLL now loaded from a custom DLL directory (with 32/64bit subdirectories)
  • SERVER: Removed MVCC code
  • SERVER: Improved set resource limits on Mac and Linux
  • SERVER: Several others fixes and improvements
  • ADMIN: IP address is now reported on Log pane
  • ADMIN: Overall improvements and fixes
  • OTHER: Updated cubeSQL Preference Pane on MacOS X
  • OTHER: New startup script on MacOS X
  • PLUGIN: New Xojo plugin format in addition to Real Studio format
  • PLUGIN: Now correctly detects when SSL is not installed
  • PLUGIN: Added support for new SSL+AES encryption protocol

cubeSQL is available for MacOS X (32 and 64bit), Linux (32 and 64bit) and Windows (64bit only).It can be downloaded from: