Recent Blogs Posts

Lianja 9.4 (9.4.3) supports the ability to Create, Edit and Display HTML Articles in an ArticleView section or in the Report Viewer.

Articles are HTML formatted files that can contain {macros} and other embedded content which are substituted when displayed.

Articles are embedded in an ArticleView and are dynamically generated. They can be used in Desktop, Web and Mobile Apps.

Uses of Articles

Articles have a variety of uses including:
...

A Visual Report Builder is a tool that allows you to create and customize reports from your data without coding. You can use a visual report builder to:

• Visualize data in different ways, such as charts, graphs, maps, tables, and more. Visualizing your data can help you discover patterns, trends, and insights that are not easily seen in raw numbers or text.
• Analyze your data from different sources, such as forms, surveys, databases, spreadsheets, or online services. You can filter,

...

Lianja is a low-code Apps platform.

To reduce coding and speed up your App development you need to understand the Lianja Apps Architecture and follow best practices when building your Apps.

Lianja is a feature rich development environment which encourages you to build Apps by "thinking" and keeping your coding down to an absolute minimum.

By following best practices as detailed in this article you will become proficient in developing Lianja Apps quickly. ...

LianjaScript and Python integration

Python is now the most popular programming language in the world.

LianjaScript is a data-centric scripting language specifically used for developing database applications. It is a modern day superset of Microsoft Visual FoxPRO which was widely praised for its speed and flexibility.

Lianja has complete two-way integration with Python. You can execute Python code directly from LianjaScript and execute LianjaScript code directly ...

Lianja provides the ability to visually create forms that will run on Desktop, Web and Mobile devices.

If you come from a VFP background this is the equivalent of the VFP form designer.



You can visually build forms that use any of the following scripting languages as the Lianja UI framework is scripting language independent across Desktop, Web and Mobile Apps.

• LianjaScript/VFP
• Python
• JavaScript
• Typescript

...

The Lianja Script Editor is a full featured and modern source code editor. It includes support for syntax highlighting, intelligent code completion, code snippets, code folding, intellisense and Intellitips. Go beyond normal Intellisense with "Live" pick lists for cursors, parameter hints for all functions, function and variable discovery and much more.

Full documentation can be found at:
https://lianja.com/doc/index.php/Script_Editor

Lianja grids are highly customizable and flexible. In this article I will explain the magical features and functionality of Lianja grids which is particularly relevant to No-Code and Low-Code developers.

All of this functionality is available in Desktop, Web and Mobile Apps.

So let's get started.

Grid overview

In its simplest form a grid displays data in rows and columns with the ability to browse millions of records with built in pagination. ...

Lianja provides the ability to build standalone executables on Windows.

This has been a popular request, so we have added in this functionality.

These executables can only be built for Apps that have been hand coded in LianjaScript, Python, JavaScript, TypeScript or Babel using the Lianja UI Framework.

This functionality is primarily for building small GUI Apps not for business Apps running under the Lianja App Center under the control of Permissions and Roles. ...

The Lianja Admin Console for Lianja Cloud provides you with everything you need to administer your users, databases, packages, reports and - very importantly - forensics in the cloud. It also contains a real time dashboard that is dynamically updated. This monitors the users connected and the CPU, memory and disk usage. The Lianja Admin Console is a Lianja App so you can open it in the App Builder, study how it is implemented, modify it and enhance it and deploy it to your server.

Full ...

MetaTypes provide a powerful means of defining custom types and then subclassing them in Pages, Sections and FormItems.

Each MetaType that you define in the MetaType Editor can contain attribute/value pairs as well as delegates and their procedure or function names.

A MetaType is essentially a 'class' which can be inherited simply by specifying its name in the 'Meta Types' attribute for user interface elements. (Pages, Sections and FormItems).

For full details ...

Setup Lianja backup/restore target directory for use with Dropbox, OneDrive and iCloud.

Dropbox

Windows

Code:

mkdir ~\Dropbox\Lianja\data\backups\
mklink /D \Lianja\data\backups\  ~\Dropbox\Lianja\data\backups\

Linux

Code:

mkdir ~/Dropbox/Lianja/data/backups/
ln -s /opt/lianja/data/backups/  ~/Dropbox/Lianja/data/backups/

MacOS

Code:

mkdir ~/Dropbox/Lianja/data/backups/
ln -s /Users/Shared/Lianja/data/backups/

...

A digital dashboard is a business intelligence tool that allows business leaders to track, analyze and report on KPIs and metrics. Modern, interactive dashboards make it easy to combine data from multiple sources and deeply explore and analyze the data directly within the dashboard itself.

You can build a digital dashboard in Lianja without any coding needed.

In this article I will show you the steps needed to build a dashboard like this.

Dashboards are made ...

Lianja Package Files (.lpk) are used to package up Apps, databases and Library files to transfer to another Lianja App Builder installation.
They can also be installed/updated automatically by the Lianja Cloud Server.

1. Build a package

You build a Lianja package file (.lpk) in the "Deploy" workspace.



Note: If you have a project open then the files contained within the project will already ...

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

It is embedded in Lianja App Builder, Lianja App Center, Lianja Cloud Server and Lianja SQL Server.

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.

A Lianja database is a container holding a collection of tables, ...

Many developers have requested the ability to be able to build modern Web Apps in Lianja while running legacy VFP applications side by side accessing the same data.

Although this is possible using Lianja virtual tables with the VFP ODBC driver, OLEDB provides better performance and flexibility.

In Lianja 6.3 we have provided the ability to use OLEDB providers as an alternative means of transparent data access.

Let’s look at how we can integrate Lianja and ...

if you want to use https to serve your lianja web apps you need an SSL certificate installed and install the Lianja apache module.

Firstly Install the Lianja apache module.

https://www.lianja.com/doc/index.php...dule_for_Linux

This tutorial shows how to setup an SSL certificate on Ubuntu 18.04

https://www.digitalocean.com/communi...n-ubuntu-18-04

And this on centos 8 and redhat ...

LianjaScript Modules are similar to libraries in that they can be dynamically loaded and contain procedures that may be used in your Apps.

Modules however encapsulate all procedures, functions and public variables and make these only visible from an object. This prevents name clashes and is a simple way to wrap code libraries into objects without any special coding syntax.

Modules provide simple (Object-Oriented Programming ) OOP concepts:

• Objects
• Abstraction
• Encapsulation
• Inheritance
• Polymorphism

...

There are many types of data queries in Lianja Apps. UI consistency is important for onboarding users with minimum training being needed. Providing powerful built-in data querying is an important requirement of a No-Code and Low-Code platform.

Action queries

An action query is a query that navigates between records using the ActionBar.



Instant Search

Instant Search allows the user to search the data on ...

A Progressive Web App (PWA) is a website that can be installed on your device and provide an app-like experience.
What is a Lianja PWA? Learn more here.

Lianja supports a wide range of functionality for building Progressive Web Apps (PWA).

Media capture

Media capture allows apps to use the camera and microphone of a device. After recording a video you can play it, download it or record another one.

Capture and upload photos. The ...

I'm sure you may have heard the term "Responsive UI" used. This article explains what it is and how Lianja handles a responsive UI in more ways than can be imagined.

Let's look at the functionality built into Lianja to let you build Apps that can run on multiple devices all with possibly different screen resolutions. This is a fundamental feature of LIanja and requires no coding to build Apps with a responsive UI.

The UI of an App can adjust its appearance based ...

Lianja 6.3 introduced a new Key/Value Store (KVS) to support data streaming and IoT applications.

A key-value database is a type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier. Both keys and values can be anything, ranging from simple objects to complex compound objects.

KVS is implemented as a collection of functions built into ...

No-code Developer QuickStart in Lianja

Understanding the Lianja application architecture
https://www.lianja.com/doc/index.php...p_Architecture

Creating a database and its tables
https://www.lianja.com/doc/index.php...and_its_tables

Creating an App
https://www.lianja.com/doc/index.php...rst_Lianja_App

Creating a page
https://www.lianja.com/doc/index.php...y:Page_Builder ...