Pervasive SQL

Pervasive SQL. Very reliable database system. It is one of the lowest maintenance and high performance in the world. simplifies development and deployment, and improves the performance of your mission critical applications.

Summary

[ hide ]

• 1 Evolution
• 2 Scalability and performance
• 3 Low total cost of ownership
• 4 Flexibility
• 5 New development tools
• 6 Latest version
  • 1 Pervasive PSQL v11
    • 1.1 News
    • 1.2 Advantages
    • 1.3 Supported Platforms
  • 7 See also
  • 8 Sources

Evolution

Pervasive SQL has grown over time from the roots of the Btrieve engine, which still maintains technical support for its API libraries . Even in the latest version released, compatibility with all previous versions is guaranteed, even with Btrieve 6.15 reading ability of Btrieve 5.x files. This means that the recent version of PSQL is compatible with applications and data created more than ten years ago. Those who have invested in acquiring the new versions can easily gain in performance by converting their files from 6.x to the latest version, with a simple assistant program.

Scalability and performance

The scalability of a data management solution – that is, its ability to grow with you by managing your data the way you need – is key to the success of your business. Pervasive SQL offers the same dual data access technology from previous versions with several key enhancements:

• 30 different performance optimizations related to all SQLinterfaces that produce significant improvements in Cartesian junctions and TPC-C tests.
• Support for tables up to 128 GB.
• Faster data access thanks to doubling the page size to 8 KB.
• New bulk data copy utility for high-performance import.

Low total cost of ownership

The performance increase is only valid when it is economically affordable. Pervasive SQL offers you the same self-configuring engine capable of running 24 * 7, making maintenance easy and virtually eliminating the need for an administrator to keep your business running and costs low. The improvements in Pervasive SQL allow us to continue reducing support and deployment costs:

• Notifying the user of application version conflicts during installation helps reduce configuration-related support calls.
• Improved control of registry key conflicts caused by legacy applications simplifies upgrades.
• Enhanced communication network allows faster location of the server engines or station workand speeds up the installation process.
• Updates to allow clients to locate serversin IPX and TCP / IP environments .

Flexibility

Pervasive SQL offers you a large number of possible configurations and platforms to best suit your needs, maximizing deployment options:

• Freedom of choice of platforms – server solutions for Windows, Linux and NetWare, as well as complete freedom for configuring workstations.
• Full compatibility with Btrieve applications on all supported platforms.
• New support for ISAM data types, which means you won’t have to alter your COBOL application’s data model to use SQLaccess .

New development tools

In conjunction with the tools available on the CD or in the Pervasive Development Center, the Pervasive SQL Development Kit includes the following tools:

• A Control Center (Pervasive Control Center) rewritten in Java under the Eclipse platform, which will also serve as the basis for all future graphics tools.
• The DDF Builder is back! Completely redesigned, it will make it easier for developers to describe existing data files for SQL access.
• Full Text Search allows developers to offer full text search features in their applications. It includes searches on text, numeric, date and logical fields, with support for wildcards, synonyms and ANDand OR searches .

Last version

Pervasive PSQL v11

Pervasive PSQL v11 incorporates very interesting news for the community of developers and database administrators such as:

• Optimized for multi-core servers
• Windows 64-bit ODBC driver
• Compatible with IPv6
• NET 3.5 provider with .NET Entity Framework support
• PDAC for RAD Studio 2010 and 2009

News

Pervasive PSQL v11 offers a parallel implementation of Pervasive PSQL that includes many improvements so that your applications can benefit from teams with multiple cores

• Improvements to the low-level synchronization mechanisms of the transactional interface
• Multiple users can read cached pages at the same time and their operations can continue on multiple cores
• Users accessing independent files can continue in different nuclei
• Non-user-specific activities such as checkpoints and log management can also use additional kernels.

Advantage

• Higher performance on multi-core machines without changing your application.
• Greater scalability – more users, more cores, more data processing capacity.
• Simple transition to IPv6.
• More 64-bit relational support.
• Updated development tools.
• Simple migration from previous versions.

Supported Platforms

• Windows 7.
• Windows 2008 and 2008 R2.
• Windows Vista.
• Windows Server 2003.
• Windows XP.
• Red Hat Enterprise Linux 4 and 5.
• SUSE Linux Enterprise 9 and 10.