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
In order to celebrate our 5.0 release, for a very limited time, cubeSQL unlimited connection is now just $99.
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.)
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:
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:
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:
into the system folder: /Library/LaunchDaemons
Make sure the plist has the following privileges:
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.
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.”
We just upgraded cubeSQL plugin for Xojo with support for Cocoa, Carbon MachO, Linux and Windows.
You can download the latest version from: