SQLBase® Embedded Database


What’s New in SQLBase 11.6

SQLBase 11.6 is all about ease of use, high performance, easy and powerful database monitoring, and increased limits and roles. Significant new functionality, requested by customers, is in this powerful release of the beloved embedded database workhorse - SQLBase.

SQLBase 11.6 Command Center: Monitor, Analyze, Solve

  • Monitor: Use the easy and intuitive SQLBase Command Center to monitor what is going on with your SQLBase servers – both local and remote SQLBase servers.
  • Analyze: Easily detect the performance bottlenecks or other database related issues.
  • Solve: Put solutions in place that solve performance bottlenecks.

SQLBase 11.6 Command Center has all the information about your SQLBase servers. Command Center helps you to monitor the health of your and your customers’ SQLBase installations. In case of performance bottlenecks, the new performance monitoring allows you to detect the source of the problem with a few mouse clicks. Solving the issue might only involve creating a few new indexes or switching to the new Read Committed isolation level . The following screenshot shows the auditing options available in SQLBase Command Center. Just click any of the options to start the audit.

The image below is a print preview of a SQL performance audit.

SQLBase 11.6 Roles: Significantly easier user administration by means of the new roles concept. Simply create a few roles and define detailed security for only the roles. Then assign as many users as you like to a role. SQLBase Command Center lets you easily manage users and roles.

The image below shows the new Role rights tab for tables in SQLBase Command Center.

SQLBase 11.6 Increased Limits: More columns per table/view, more data for char and nchar fields. Now create up to 1000 columns per table or view. Create NCHAR Unicode fields having a length of 500 characters and varchar fields up to 1000 characters. Use the new LONG NVARCHAR datatype for unlimited length Unicode data.

SQLBase 11.6 Enhanced Read Committed (RC) for Better Multi-user Application Performance: Enhanced RC modes allow reuse of existing applications without changes and leverage the no lock reading mode of RC. In RC mode queries never have to wait for locks to be released before they read data. This can dramatically accelerate multi-user applications.

SQLBase 11.6 64-bit Windows Drivers: Do you have 64-bit applications that need to access SQLBase? SQLBase 11.6 comes with a 64-bit ODBC, OLEDB and .NET Data Provider.