SQLiteManager 3.9.5

May 15th, 2012 | No Comments »

We announce the immediate availability of SQLiteManager 3.9.5.

What’s new in this version?

  • Fixed foreign key issues in the table editor

In version 3.9.1 we fixed an issue related to UTF-16 encoded databases.
We really think this will be the latest 3.x release, next version should be a major 4.0 upgrade.
More information available at http://www.sqlabs.com/sqlitemanager.php

cubeSQL 4.3.0b5

May 9th, 2012 | 4 Comments »

During the past months we worked hard on the new upcoming cubeSQL release.
We fixed all know bugs and we added some powerful functionalities.

Here you go the details of all the changes so far:

  • 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 Windows do not stop cubeSQL service if user disconnects
  • ADMIN: New icon
  • ADMIN: New SSL connection option
  • ADMIN: Other small fixes
  • ADMIN: New data folder that contains a valid SSL certificate
  • ADMIN: On Linux now checks if libgtkhtml is installed before opening the News panel
  • PLUGIN: New SSL options

Please note that the archive contains just the executable files for all platforms and require a valid serial number in order to properly run. As always you can request a key from: http://www.sqlabs.com/cubesql_devkey.php

Download cubeSQL 4.3.0b5

Please report any bug to us!!!

SQLiteManager 3.9.5 and your help

May 7th, 2012 | No Comments »

We recently released SQLiteManager 3.9.1 where we fixed an issue with UTF-16 encoded databases and we are working on version 3.9.5 where we would like to fix a foreign key issue bug in the alter table panel (if you have details or more information about it please send us a feedback).

You know that each time we receive a bug report we’ll do our best to fix it and release a new version as soon as possible. You know also that we don’t gain anything from bugs or from unsatisfied customers but last week a rude user purchased SQLiteManager from the AppStore and he leaves a very unfair review even if I asked him more details in order to be able to promptly fix the issue (I also offered him a refund).

Our AppStore sales are suffering a lot due to this rude review and we have no way (as developers) to reply to reviews and to explain true situation. If you find SQLiteManager useful please help us leaving a fair review at the App Store.

App Store link: macappstore://itunes.apple.com/app/id412443832?mt=12

Thanks a lot for your help and for your invaluable support.

SQLiteManager 3.9.0

April 11th, 2012 | 3 Comments »

We announce the immediate availability of SQLiteManager 3.9.0.

What’s new in this version?

  • Fixed an ALTER TABLE bug that could result in an empty table
  • Fixed a cubeSQL bug that could result in not committed sql statements
  • Upgraded sqlite to the latest 3.7.11 version

More information available at http://www.sqlabs.com/sqlitemanager.php
P.S. This will probably be the last 3.x version before the release of the new 4.x product

SQLiteConverter 1.8.0

April 5th, 2012 | No Comments »

We announce the immediate availability of SQLiteConverter 1.8.0.

What’s new in this version:

  • Fixed a PostgreSQL related schema issue
  • Fixed a FoxPro related issue
  • Added an easy way to create a debug log file
  • Upgraded sqlite to the latest 3.7.11 version

More information available at http://www.sqlabs.com/sqliteconverter.php

cubeSQL mailing list

March 29th, 2012 | No Comments »

To better serve our customers we just opened a dedicated cubeSQL mailing list.
To subscribe just visit its dedicated admin page or send an email to cubesql-join@sqlabs.com.

Some cubeSQL news

March 29th, 2012 | 4 Comments »

We are working on the next cubeSQL version… where you’ll see a lot of improvements and features.

We are interested in trying to port cubeSQL to an ARM processor with Linux OS… do you know some good devices we could use for development and testing? We know about the very interesting Raspberry Pi project but its availability is too uncertainty at this time.

Please advice…

cubeSQL ODBC Driver 1.0b2

March 13th, 2012 | No Comments »

cubeSQL ODBC Driver version 1.0b2 is now available from:

What’s new:

  • Fixed an issue that caused Win32 installer to install the driver with the wrong name
  • Added support for auto-commit transactions
  • Fixed problem with authentication for System DSN’s on Mac
  • Added support for Mac OS X KeyChain
  • Fixed problems with MS Access import

Please test the new version and let us know if you find any problem.

ODBC Driver on Windows 64bit clarification

February 28th, 2012 | 5 Comments »

From a Jonathan Monroe suggestion I posted this comment few minutes ago, but it’s very important so it deserves a separated post:

In order to use ODBC with a 32-bit application (such as MS Office) on 64-bit Windows, you have to install the 32-bit driver. In order to configure a DSN for the 32-bit driver, you have to use the 32-bit ODBC Administrator, located at:

c:\windows\sysWOW64\odbcad32.exe

A DSN configured using the default 64-bit ODBC Administrator will not be recognized by 32-bit applications. More information about this situation is available here:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362(v=vs.85).aspx

It is important to understand that you have to use the 32-bit ODBC Administrator on 64-bit Windows if you want to use the driver with MS Office or any other 32-bit application.

cubeSQL ODBC Driver 1.0b1

February 27th, 2012 | 11 Comments »

Thanks to Jonathan Monroe from Actual Technologies we are proud to announce cubeSQL ODBC Driver version 1.0b1. You can download it from:

There are some outstanding issues, so it should be considered BETA software. The most serious problems right now are:

- the “auto-commit” mode (default) is not working. All inserts, updates and deletes must be manually COMMIT-ed
- the “Store user ID in Keychain” feature (OS X only) is not working. You should disable this checkbox on your DSN.

There are several minor issues with some of the numeric and date / time data types. So far the drivers have been tested with MS Excel on Mac and Windows, please test the new ODBC driver with your solution and let us know if you find any problem.