SQLBase Key Features
Embedded Database
Very Low Total Cost of Ownership (TCO)
SQLBase effectively reduces the development, deployment and maintenance costs of business applications. The ultra-low
TCO of SQLBase ensures that ISVs and end-customers can maximize their ROI on business database applications. SQLBase
offers very competitive deployment pricing; including a pay as you go licensing model that allows you to buy the number
of licenses needed without any large upfront payments.
SQLBase is known for its DBA-less operations that reduce database administration almost to zero. This is an important
feature for vertical solutions, as it decreases the cost associated with end-user support as well as making it more
cost-effective for large end-user deployments.
Freedom of Choice: Windows and Linux Development and Deployment
SQLBase allows you to develop and deploy on Windows and Linux, providing you with a choice as well as opening new
deployment markets. Customers can choose to have Windows only environments, Linux only or mixed environments with
Windows and Linux desktop and server systems. Moving databases from one platform to the other is as easy as copying
the database file.
Easy Embedded Deployment
There is a variety of ways by which SQLBase integrates into third party installers. SQLBase can be installed using
a silent install option, or a great alternative for ISVs is using the SQLBase Embedded Deployment Pack. ISVs can
use the SQLBase Embedded Deployment Pack to create custom installers that include the installation of their product
and the SQLBase installation in one installer task. SQLBase itself can be installed multiple times on one computer
as part of several vertical solutions being deployed to one computer. SQLBase embedding support is unmatched in the
industry and minimizes the hassle of deploying applications to millions of users.
High Scalability from a Single-User Laptop to Multiple Hundred Users
SQLBase scales easily from a one user laptop to hundreds of users. SQLBase provides several technologies to
enable high transaction and reporting throughput. Advanced isolation levels let data readers read data that is in
the process of being updated without running into a lock. Think of it like a street without red traffic light and
without speed limits.
SQLBase International Unicode® Globalization Support
SQLBase International Unicode® support enables easy worldwide deployment of solutions. Users can simply work with
the language, character set and glyphs they are used to, regardless of where they are located. One database can contain
and manage data for many countries and languages and then the data can be retrieved and sorted according to specific
rules. For example, based on the defined rules, SQLBase will present that data to local users in their local language.
Organizations no longer need to worry about managing separate databases for localization.
Full Integration into Leading Development Systems
SQLBase allows users of Team Developer, Visual Basic, VB.NET, ASP.NET, C#, and Delphi to seamlessly integrate SQLBase
into their Visual Development Environment (VDE), use ADO.NET, and all VS.NET queries, SQL and XML-functionality to
create database applications for Windows or ASP.NET applications.
Zero Administration
SQLBase is designed as a maintenance-free database and is capable of running unattended for months at a time;
extending disk files as appropriate, eliminating redundant connections and more. Due to the zero administration
requirements, ISVs and Corporate IT can reduce expensive resources like technical support.
Robust Structure and Self-Recovering Capabilities
Unlike flat-file databases, SQLBase has transactional integrity at its core, providing the level of assurance
user's demand. System failures are a fact of life, but SQLBase's advance logging capabilities allow it to recover automatically.
Advanced Security
With optional Treasury triple-DES encryption, SQLBase integrates new security and authorization functions
unsurpassed by any other desktop or workgroup database. The security features make SQLBase a premier choice for
Web applications where a database outside the firewall-secured company network is needed.
Comprehensive Monitoring and Logging
SQLBase provides unique support for database event logging, allowing quick identification and resolution of production
issues. Internal database information is also available on demand via the API, giving developers the tools they need to
track down problems.
Open and Flexible
SQLBase's comprehensive API and support for a variety of interfaces means developers can concentrate on the application,
not the database - but with the assurance that functionality is always within reach.
SQLBase supports:
- .NET Data Provider
- OLE DB
- ODBC, Linux ODBC (iODBC, unixODBC)
- Pure Java (level 4) JDBC
- Windows and Linux C-API
- Team Developer
- Consistency Across Platforms (Windows and Linux)
SQLBase Desktop and Server share a common code line, reflected in identical SQL functionality and interfaces. This saves
time and money by simplifying configurations and cutting development time, allowing you to build a single program version
for both single- and multi-user applications.
Powerful SQL Support
With a full, true relational implementation, SQLBase reduces your development time by allowing you to write the SQL
your application really needs. And with its advanced cost-based query optimizer it will deliver the performance your customers demand.
Comprehensive API
A comprehensive API allows developers to create applications that exhibit a fit and finish that will appeal to all
classes of user. From multi-user contention handling to advanced querying, your applications will be able to impress
users in demos - and empower them in day-to-day use.
Web-Based and Client Server Applications
SQLBase's TCP/IP protocol provides access to a SQLBase server from anywhere in the world via the Internet. Windows
clients running applications created with any standard development tool, such as Team Developer or Visual Basic,
can use the SQLBase client software components, either directly or via ODBC and OLE DB.
JDBC Support
SQLBase offers cross-platform Java applications direct database access with a 100% Java-compliant (Level 4) JDBC driver.
Small Footprint, Big Access
SQLBase's small footprint allows self-contained applications to run happily on the smallest Windows PC. Similarly,
client/server applications fly when located on standard file servers - something traditional enterprise databases
simply cannot match.
Successful Track Record
Created in 1988 as the first RDBMS for PC networks, SQLBase was originally deployed on DOS, it then became the
first RDBMS for NetWare, and is now available for Windows and Linux platforms. Since its inception, over
100,000 multi-user servers and 1,000,000 single-user engines have been deployed, making SQLBase one of
the most persistent embedded databases in the industry.