The PSQL Relational Engine
PSQL’s Relational Engine offers easy installation, uncomplicated maintenance, and high levels of performance and reliability.
Benefits
Many relational database application developers choose PSQL 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. PSQL 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 PSQL ODBC driver calls the database engine directly, without translating ODBC calls to a proprietary relational API.
•
Scalability. PSQL allows you to scale applications from single-user to large client/server environments without changing the application or the database.
•
Maintenance-free Operation. PSQL is simple to install and use. It requires no extensive performance setup or ongoing tuning by a database administrator.
•
Small Memory Footprint. PSQL has a small footprint, requiring only a small amount of memory.
Features
The Relational Engine provides a flexible architecture that helps you easily scale your database applications from large client/server systems to single-user environments without additional coding. PSQL offers easy installation, uncomplicated maintenance, high levels of performance and reliability, and a smooth migration path for data. In addition, bundling PSQL with your application is easy with the PSQL distribution component, which provides multi-user and single-user run-time support.
•
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 and ADO.NET support.
•
Other features include additional Windows utilities, large file support (up to 256 GB), and additional data type variables such as TIMESTAMP, UNSIGNED, and CURRENCY.