REAL Server is a relational database management system

Relational database management system

A relational database management system is a database management system that is based on the relational model as introduced by E. F. Codd. Most popular databases currently in use are based on the relational database model....

 (RDBMS) built on top of the sqlite database engine.

History

REAL Server evolved from the SQLiteServer originally developed by SQLabs in 2004. In May 2005 REAL Software

REAL Software

Real Software, is a privately held, privately financed vendor of software development tools, based in Austin, Texas.-Products:Real Software's cross-platform development tool, Real Studio is available in four editions: Real Studio Personal Edition, for hobbyists and students, Real Studio...

, Inc., creator of REALbasic

REALbasic

Realbasic is the object-oriented dialect of the BASIC programming language used in Real Studio, a programming environment, developed and commercially marketed by Real Software, Inc of Austin, Texas for Mac OS X, Microsoft Windows, 32-bit x86 Linux and the web.- Language features :RB is a strongly...

, purchased the source code and the copyrights of the SQLiteServer and invested in its development

New product development

In business and engineering, new product development is the term used to describe the complete process of bringing a new product to market. A product is a set of benefits offered for exchange and can be tangible or intangible...

. In 2007/2008 the first version of the REAL SQL

SQL

SQL is a programming language designed for managing data in relational database management systems ....

 Server was released. A new version was released in April 2009 and renamed REAL Server. In September 2010 SQLabs repurchased all the server's Intellectual Properties and a new major release is now under development by the SQLabs team.

Features

• Event based,
• Asynchronous sockets,
• Multi-core and multiprocessor
  Multiprocessor
  Computer system having two or more processing units each sharing main memory and peripherals, in order to simultaneously process programs.Sometimes the term Multiprocessor is confused with the term Multiprocessing....
  
   aware,
• Strong AES encryption (128, 192 and 256 bit),
• Supports unlimited connections (For each supported operating system, REAL Server uses a state of the art event API, kqueue on Mac OS X, epool on Linux and I/O Completion Ports on Windows),
• Full ACID
  ACID
  In computer science, ACID is a set of properties that guarantee database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction...
  
   (Atomic, Consistent, Isolated, Durable) compliant,
• Platform independent storage engine,
• Full support of triggers and transactions,
• Journal engine for crash recovery,
• Supports databases of 2 terabytes,
• Supports sqlite
  SQLite
  SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
  
   3 databases,
• Automatic logging,
• Automatic compression,
• Multiversion concurrency control
  Multiversion concurrency control
  Multiversion concurrency control , in the database field of computer science, is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.For instance, a database will...
  
   (MVCC),
• Plugins for extending the SQL
  SQL
  SQL is a programming language designed for managing data in relational database management systems ....
  
   language and the custom commands supported by the server,
• Restore and backup support,
• Mac OS X
  Mac OS X
  Mac OS X is a series of Unix-based operating systems and graphical user interfaces developed, marketed, and sold by Apple Inc. Since 2002, has been included with all new Macintosh computer systems...
  
  , Windows
  Microsoft Windows
  Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
  
   and Linux
  Linux
  Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
  
   support.

Connectivity

REAL Server can be used with the following:

• REALbasic
  REALbasic
  Realbasic is the object-oriented dialect of the BASIC programming language used in Real Studio, a programming environment, developed and commercially marketed by Real Software, Inc of Austin, Texas for Mac OS X, Microsoft Windows, 32-bit x86 Linux and the web.- Language features :RB is a strongly...
  
  
• PHP
  PHP
  PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
  
  
• C SDK
• ODBC

External links

• SQLabs.
• REAL Server, Official REAL Server website
• SQLite, Official website for SQLite