The Pervasive.SQL Relational Interface

---

Pervasive.SQL's relational interface, built on the SQL Relational Database Engine (SRDE), offers easy installation, uncomplicated maintenance, and high levels of performance and reliability.

Benefits

Many relational database application developers choose Pervasive.SQL because it provides scalability, maintenance-free operation, and a small memory footprint:

• Standard Interface. SQL and ODBC provide a well-known and standardized foundation upon which to build useful applications.
• Speed. Pervasive.SQL offers direct ODBC access to the database engine. Many competitive products use a translation layer to translate ODBC calls to proprietary "native" relational API calls that then access the database engine. In contrast, the Pervasive.SQL ODBC driver calls the database engine directly, without translating ODBC calls to a proprietary relational API.
• Scalability. Pervasive.SQL allows you to scale applications from single-user to large client/server environments without changing the application or the database.
• Maintenance-free Operation. Pervasive.SQL is simple to install and use. It requires no extensive performance setup or ongoing tuning by a database administrator.
• Small Memory Footprint. Pervasive.SQL has a small footprint, requiring only a small amount of memory.

Features

The Pervasive.SQL relational interface provides a flexible architecture that helps you easily scale your database applications from large client/server systems to single-user environments without additional coding. Pervasive.SQL offers easy installation, uncomplicated maintenance, high levels of performance and reliability, and a smooth migration path for data. In addition, bundling Pervasive.SQL with your application is easy with the Pervasive.SQL distribution component, which provides multi-user and single-user run-time support.

Pervasive.SQL has a comprehensive relational database management system interface that offers many features, including the following:

• Application scalability from standalone to client/server.
• Fully functional Workgroup and client/server engines.
• Declarative Referential Integrity.
• Bi-directional, updateable, and scrollable cursors.
• Named database support providing location transparency for applications.
• Comprehensive, industry standard data type support.
• Programming extensions such as triggers and stored procedures.
• Cost-based optimization from statistical analysis and enhanced fetch algorithms.
• Transaction processing enhancements such as full transactional logging.
• Standards enhancements, including ODBC support.
• Other features include additional Windows utilities, large file support (up to 64 GB), and additional data type variables such as TIMESTAMP, UNSIGNED, and CURRENCY.