Gupta Technologies LLC is prepping a version of its embedded database, SQLBase, that promises to simplify application deployment and run at far greater speeds.
To achieve that simplification, SQLBase 8.5 will allow multiple servers to run in isolation on a single machine—a feature that will be important for VARs and ISVs, according to Gupta officials in Redwood Shores, Calif.
As it now stands, problems arise when SQLBase customers have more than one instance of the database running—for example, if one department were using it for a payroll application while another used it for a shipping application. Such a setup can cause problems with data processing and with DLLs.
SQLBase 8.5 is designed to avoid such problems by giving programmers control over what paths lead to information such as DLL files or configuration data.
SQLBase 8.5 also supports ANSI Join syntax, including multiple outer joins. Multiple outer join enables queries to extract data from a number of tables. An example of where this would come in handy is if a query requested data for an employee who is both part of a given department and also a member of a sales staff—a total of three table sources, including employee information, department information and sales staff information. The capability to do multiple outer joins is common to major enterprise databases, but less so in low-end databases such as SQLBase—which means SQLBase is reaching up to where the big boys are, said Charles McLouth, product manager for SQLBase.
The upgrade also promises performance thats 40 percent faster, on average, and can reach 125 percent faster speeds, officials said.
SQLBase 8.5 will be generally available on Sept. 8. The price is $495 per user. SQLBase Developers Edition costs $29.95. That cost covers only development, not deployment.