cubeSQL 4.5

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/

Tags: cubesql

4 Comments

Oliver Osswald

May 3, 2013 Reply

I have difficulties to find more information about properties, features etc:
- when I want to make use of the new preference 'SECRET_TOKEN' from Xojo, then I would set the '.token' property, like:
db = New CubeSQLServer
db.token = "my_secret_token"

Right?

What about SQLite Manager and cubeSQLAdmin, can I still connect or how would I set the token there?

Next questions:
- What is the preference AUTOMATIC_ROWID_ENABLED doing? Is it to be able to switch it OFF?

- What is the DATABASE_ADMIN privilege for, and how is it different from privileges ADMIN or DATABASES?

- What is the www folder for, inside of the /cubesql folder?

- And last but not least: When I retrieve a recordset with SQLSelect method from a remote CubeSQLServer, and do not NIL it out immediately, then the CPU goes to and remains at about 100%. I do not see such a thing when using a local connection to a Xojo SQLiteDatabase. Is this a known issue?

Oliver
marco

May 3, 2013 Reply

- Yes right but then you should send a:
SET PREFERENCE ‘TOKEN_CONNECTIONS_ONLY’ TO ’1′;
to allows only connections with that token set.

- With SQLiteManager you'll be able to connect from the next version (when token field will be added to the connection pane).

- Server has AUTOMATIC_ROWID_ENABLED set to ON by default, you have now the option to turn it off in order to speed-up queries.

- DATABASE_ADMIN allows you to add admin privileges at database level instead that at server level.

- www folder is currently not used.

- We are not aware of any issue... please send me more details or better, a project that is able to reproduce the issue.
jharris

May 6, 2013 Reply

Hi Marco,

It sure would be nice to get an example of using JSON & vb.net. Most of the time I use RealBasic to connect to the server, but it would be nice to be able to connect/query with some of my VB apps.

Regards,
jharris
Oliver Osswald

May 10, 2013 Reply

I was wrong, the 100% CPU usage is due to a framework bug of the IDE, not because of cubeSQL! (Currently, when a Xojo TextField has focus, it heats up the CPU to a 100% usage, even when nobody is typing...)

About The Author: Marco

4 Comments

Oliver Osswald

marco

jharris

Oliver Osswald

Leave a Reply Cancel

cubeSQL 4.5

About The Author: Marco

4 Comments

Oliver Osswald

marco

jharris

Oliver Osswald

Leave a Reply Cancel

More recent stories