The Lianja Database

The Lianja database is a high performance SQL and NoSQL (Navigational data access) database.

Despite its powerful features the Lianja database is simple to set up and easy to use.

It is used in many business critical installations worldwide including banking, defense and logistics.

Key features

• Embedded in Lianja App Builder, Lianja App Center, Lianja Cloud Server and Lianja SQL Server
• Incorporates a local cursor engine
• Tight coupling between language (Lianja/VFP) and data
• High concurrent throughput incorporating row level locking
• Fast and reliable with a small footprint
• Chronological Data Versioning and audit trails to satisfy regulatory requirements
• Very large file support (2^64) for the most demanding storage requirements
• Supports storage of documents, images, video and other binary content
• Supports "Hot backup" and off-site replication
• Cluster ready, highly scalable, with self-healing indexes
• Incorporates cost-based query optimization using indexes
• Incorporates SmartQuery™ technology with intelligent query caching
• Write stored procedures in Lianja/VFP scripting
• Write triggers in Lianja/VFP scripting
• Supports integration with third party SQL databases using virtual tables
• Supports row level security (RLS)
• Supports dynamic data masking (DDM)
• Has integrated support for metadata at the database, table and column level
• Many productivity extensions to standard SQL e.g. SELECT data and save as XML, JSON, HTML in one statement
• Supports JSON with a native JSON data type and the ability to query on JSON members using SQL SELECT with fully optimized queries
• Supports full JSON CRUD operations; INSERT, SELECT, UPDATE and DELETE of JSON
• Can be used as high performance key/value table storage
• Available for Windows, Linux and macOS
• Provides drivers for ODBC data access

Lianja SQL

Full documentation can be found here.

Creating a database and its tables

Full documentation can be found here.