SQLiteManager 4.0.0 Public Beta 3

November 7th, 2012 | 1 Comment »

SQLiteManager Beta 3 is now available.

MacOS X Version:
http://www.sqlabs.com/download/beta/SQLiteManagerMac.zip
Windows Version:
http://www.sqlabs.com/download/beta/SQLiteManagerWin.zip

Release notes are available here.
As always, please let me know if you find any issue.

Thanks!

SQLiteManager 4.0.0 Public Beta 2

November 6th, 2012 | No Comments »

After some initial feedbacks we decided to release a new beta version.
Bete 2 includes the following changes:

  • Greatly increased performance while scrolling from a cubeSQL RecordSet.
  • Fixed a crash bug that occurs while scrolling from a cubeSQL RecordSet.
  • Fixed return values from Database lua class.
  • Fixed some issues related to Attachments window.
  • Fixed some issues related to Notes creation.
  • Detailed Analyser now works again on Windows.
  • Maximize buttons now active on Windows.
  • Updated sqlite to version 3.7.14.1.
  • Updated analyzer utility.

Please note that you can always check SQLiteManager news and latest version history from with the SQLiteManager app just selecting “SQLiteManager News” from the Help menu.

This is a fully functionality application that will expire in about a week.
Please let me know if you find any issue.

You can download your copy from:
MacOS X: http://www.sqlabs.com/download/beta/SQLiteManagerMac.zip
Windows: http://www.sqlabs.com/download/beta/SQLiteManagerWin.zip

Thanks a lot!

SQLiteManager 4.0 Public Beta

November 5th, 2012 | No Comments »

After more than a year of hard work, we are proud to announce the first public beta version of the upcoming SQLiteManager 4.0.

It has been rewritten from scratch and it now includes a lot of very powerful features like inline editing done right, lua scripting capabilities, listbox with infinite rows and columns and much much more.

Our goal was to develop the best sqlite manager application out there!
This is a fully functionality application that will expire in about a week.
Please let me know if you find any issue.

You can download your copy from:
MacOS X: http://www.sqlabs.com/download/beta/SQLiteManagerMac.zip
Windows: http://www.sqlabs.com/download/beta/SQLiteManagerWin.zip

Thanks a lot!

Announcing SQLiteDoctor

September 27th, 2012 | 1 Comment »

An SQLite database is highly resistant to corruption. If an application crash, or an operating-system crash, or even a power failure occurs in the middle of a transaction, the partially written transaction should be automatically rolled back the next time the database file is accessed. Though SQLite is resistant to database corruption, it is not immune and in some cases a special tool like SQLiteDoctor is required in order to be able to fully restore your damaged sqlite database.

There is also a new section about how to corrupt your sqlite databases.

Announcing SQLiteSync 1.5

September 24th, 2012 | No Comments »

What’s new in version 1.5.0:

  • Fixed a data migration issue
  • Improved script generation
  • Improved script window
  • Revamped database selection UI
  • Upgraded sqlite to version 3.7.13

Announcing SQLiteConverter 1.8.5

September 24th, 2012 | No Comments »


What’s new in version 1.8.5:

  • Fixed a port issue, hostname:port now correctly work.
  • Updated sqlite to version 3.7.13.
  • Updated ODBC engine.
  • Updated mySQL engine.
  • Updated postgreSQL engine.

cubeSQL 4.3 updated ObjC sdk

September 21st, 2012 | No Comments »

We just updated the ObjC sdk for cubeSQL 4.3.

Please note that it is a wrapper for the original C SDK, so you need to include the C sdk in your XCode Cocoa/iOS project in order to be able to compile it.

You can download the latest version from:
http://www.sqlabs.com/download/cubesql/CubeSQLObjC.zip

cubeSQL Special Limited Time Offer

September 3rd, 2012 | No Comments »

To celebrate the latest 4.3.0 release.
cubeSQL Unlimited Connections is just $99 for a limited time!
A $500 saving that includes one year of free updates!

Please RETWEET this special offer!!!

Announcing cubeSQL 4.3

August 29th, 2012 | No Comments »

We just released cubeSQL version 4.3 where we added SSL support, we fixed all know bugs and we improved overall performance. We recommend all our users to upgrade to version 4.3.

What’s new in version 4.3.0:

  • SERVER: Updated sqlite to version 3.7.13
  • SERVER: Added a new MAX_CONNECTIONS preference key to allow third party developers to limit number of allowed connections
  • SERVER: Added DOWNLOAD BACKUP DATABASE dbName WITH TIMESTAMP value custom command
  • SERVER: Fixed a rare issue that can affect old Windows distributions related to spurious console commands
  • SERVER: Improved UNC and Network paths handling under Windows
  • SERVER: Fixed a rare DOWNLOAD DATABASE crash bug
  • 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 some Windows distributions do not stop cubeSQL service if user disconnects
  • ADMIN: New icon
  • ADMIN: New SSL connection option
  • ADMIN: On Linux now checks if libgtkhtml is installed before opening the News panel
  • ADMIN: Other minor fixes and improvements
  • PLUGIN: New SSL options
  • C SDK: New SSL options

You can download you copy from: http://www.sqlabs.com/cubesql_download.php

cubeSQL and schedule backups

August 10th, 2012 | No Comments »

I think it’s time to write something about how to correctly setup a schedule backup with cubeSQL.

Most people don’t realise that it is a two step operation and we often receive support requests because in their opinion schedule backups do not work. I think that official documentation is not clear about this point and we plan to improve it in the next upcoming 4.3 version, in the meantime I’ll try to clarify required steps in this post.

Step 1 is to setup a schedule using the Schedules panel:

as you can see we added a new Schedule1 of type Backup, triggered every Sunday and 1:00 AM (and the Schedule Enabled checkbox is checked).

Once schedule has been created you need to ATTACH this schedule to a database in order to be able to correctly backups it. Please note that more than one schedule can be attached to a database and the same schedule can be attached to multiple databases!

Step 2 is to attach newly created schedule in the Databases panel:

select the database you want to backup and then from the Server menu select “Manage Schedules”:

From the popup menu then select newly created schedule and then press the Attach button.