#Pervasive sql mac os#
#Pervasive sql full#
#Pervasive sql software#

SRDE extends its functionality by supporting stored procedures, user-defined functions, and triggers.

Significant other features include relational integrity, database security, and temporary tables. SRDE parses SQL queries and sends them to the MKDE to run. The second database engine, the SQL Relational Database Engine or SRDE, operates in a manner similar to other relational database engines, that is, through the support of Structured Query Language queries. Configuration settings for caches can be pre-configured by ISVs to optimize Pervasive PSQL performance for their applications. When a call is made to the MKDE, cached data is searched first physical storage is searched if there is no cache of the data. The MKDE caches data in memory to facilitate performance. It supports multiple keys on a record and therefore multiple indexes in the file. In the MKDE, records are stored in files which are roughly equivalent to the tables of a relational database engine. If a transaction does not fully run its course due to an external event such as a power interruption, the data remains in the state in which it existed before the transaction began to run.

#Pervasive sql full#

The MKDE operates in complete database transactions and guarantees full ACID ( Atomicity, Consistency, Isolation, Durability). Low-level API calls and memory caching of data reduce the time required to manipulate data. This places the MicroKernel Database Engine in the category of NotOnlySQL databases. Calls to the MKDE are made programmatically with Btrieve API rather than through the use of a query language therefore, Pervasive PSQL does not have to parse the request. It uses key-value store to store and access the data. Pervasive's transactional database engine, the MicroKernel Database Engine, interacts directly with the data and does not require fixed data schema to access the data. Both engines can access the same data, but the methods of data access differ.

#Pervasive sql software#

The central architecture of Pervasive PSQL consists of two database engines: (1) the storage engine, known as MicroKernel Database Engine (MKDE) and described by Pervasive Software as a transactional database engine and (2) the relational database engine, known as SQL Relational Database Engine (SRDE). Pervasive PSQL supports stand-alone, client-server, peer-to-peer and software-as-a-service (SaaS) architecture. Historically, Pervasive PSQL served as a DBMS for small and medium enterprises. вЂњUsers include Novell, Microsoft, PeachTree Software, Fair Isaac, Disney World, Radio Shack, Cardiff and others.вЂќ The accounting industry formed a large part of its market in 2007. Pervasive PSQL is embedded by OEMs like Sage, maestro* Technologies, ABACUS Research AG (Switzerland), and Unikum (Sweden) in packaged software applications that address the accounting, finance, retail, point-of-sale, entertainment, reservation system, and medical and pharmaceutical industry segments. Uses and customersД«ecause Pervasive PSQL is used for embedded databases, and sold indirectly, it is not well known. Pervasive Software was acquired by Actian Corporation in 2013. The original name for Pervasive PSQL was Btrieve. Editions are also specifically designed for different computer networking deployment needs, such as workgroup, client-server, and highly virtualized environments, including Cloud computing.

Both 32-bit and 64-bit editions of Pervasive PSQL are available.

#Pervasive sql mac os#

Pervasive PSQL runs on system platforms that include Microsoft Windows, Linux, and Mac OS X. It is available for software as a service (SaaS) deployment due to a file-based architecture enabling partitioning of data for multitenancy needs.ДЄpplications can store the data and the relationships in tables in a relational model (RDBMS) or store the data in a schema-less way with no fixed data model ( key-value store). It is optimized for embedding in applications and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). Actian Zen (named Pervasive PSQL before version 13) is an ACID-compliant database management system (DBMS) developed by Pervasive Software.