LIANJA 7.1.0 IS NOW AVAILABLE AVAILABLE FOR WINDOWS, LINUX AND MACOS VISIT THE LIANJA ONLINE STORE NOW
The following represents an overview of the main features that are actively under development by the Lianja Development Team. We'll do our best to update this roadmap as our developers continue their work.
Lianja is a community driven development project so if there is anything specifically that you would like to see supported in the product that you do not see on this list then please submit an enhancement request.
We value your feedback so if you find anything that does not behave as expected please submit a ticket so that we can get it fixed. If we don't know about them they won't get fixed!
If there is something on the roadmap that you would like to see pulled forward in time, these can be developed as sponsored features.
Development Milestones
Lianja App Builder 6.0 Release Lianja SQL Server 6.0 Release Lianja Cloud Server 6.0 Release Lianja App Builder 6.1 Release Lianja SQL Server 6.1 Release Lianja Cloud Server 6.1 Release Lianja App Builder 6.2 Release Lianja SQL Server 6.2 Release Lianja Cloud Server 6.2 Release Lianja App Builder 6.3 Release Lianja SQL Server 6.3 Release Lianja Cloud Server 6.3 Release Lianja App Builder 7.0 Release Lianja SQL Server 7.0 Release Lianja Cloud Server 7.0 Release Lianja App Builder 7.1 Release (Latest) Lianja SQL Server 7.1 Release (Latest) Lianja Cloud Server 7.1 Release (Latest) Lianja App Builder 7.2 Release (Coming Soon) Lianja SQL Server 7.2 Release (Coming Soon) Lianja Cloud Server 7.2 Release (Coming Soon) Lianja Cloud 1.0 Release
Development Roadmap Revision History
Lianja App Builder Revision History can be found here. Lianja SQL Server Revision History can be found here. Lianja Cloud Server Revision History can be found here.
Lianja App Builder 6.0 Release
Released 31-Mar-2021
The version 6.0 release includes:
Lianja App Builder 6.0.1 Release
Released 6-Apr-2021
The version 6.0.1 release includes:
- Performance and stability improvements.
- Bug fixes.
Lianja App Builder 6.0.2 Release
Released 15-Apr-2021
The version 6.0.2 release includes:
Lianja App Builder 6.1 Release
Released 18-Jun-2021
The version 6.1 release includes:
- Simplified WebView section use with customizable/editable parameters when you click the keyboard icon in the section header.
- Added a new section type "DataListView".
- Added a new section type "ChartView".
- Support for "Web Components". These provide the ability to develop and embed "Web Components" in WebViews using a WebComponent architecture that will enable Telerik and other third party UI components to be used seamlessly in Lianja.
- Added a new function EXECPYSP().
See https://www.lianja.com/doc/index.php/EXECPYSP() for details.
- Add SET DATEFORMAT TO e.g. SET DATEFORMAT TO "hu_HU".
- Added SET DATE TO LOCALE. This selects the appropriate date format in scripting ( e.g. ctod() ) and in the UI. It should be placed in the config.db file.in C:\lianja\conf.
- Performance and stability improvements.
- Bug fixes.
Lianja App Builder 6.2 Release
Released 07-Jul-2021
The version 6.2 release includes:
- Added a new "Before Refresh" delegate which is called before data is fetched into the UI.
- Added the ability to provide feedback to a user when loading data. This is most useful in web and mobile apps and is typically used in the "Before Refresh" delegate.
e.g.
Lianja.showLoadingMessage("Your message..." [, cTheme]) // cTheme can be "a", "b", "c", or "d" Lianja.hideLoadingMessage()
- Added additional visual feedback Lianja system object methods:
Lianja.showErrorMessageWithIcon(cMessage [, lNoTimeout]) Lianja.showSuccessMessageWithIcon(cMessage [, lNoTimeout]) Lianja.showWarningMessageWithIcon(cMessage [, lNoTimeout])
- Added the ability to toggle the visibility of the page header and section header from code. This is available in desktop and web apps.
e.g.
Lianja.get("page1").headervisible = true | false Lianja.get("page1.section1").headervisible = true | false
- Significant performance improvements for web Apps.
- Bug fixes.
Lianja App Builder 6.2.1 Release
Released 27-Jul-2021
The version 6.2.1 release includes:
- New Lianja system object methods to animate dialog pages over the Page viewport:
- Lianja.showDialogPage()
- Lianja.hideDialogPage()
- The following Lianja system object methods have been enhanced to allow a timeout interval in milliseconds to be specified. They previously allowed only a fixed timeout of 5000 milliseconds to be enabled or disabled.
- Lianja.showMessageWithIcon()
- Lianja.showErrorMessageWithIcon()
- Lianja.showSuccessMessageWithIcon()
- Lianja.showWarningMessageWithIcon()
- Performance improvements.
- Bug fixes.
Lianja App Builder 6.3 Release
Released 09-Dec-2021
The version 6.3 release includes:
Lianja App Builder 6.3.1 Release
Released 13-Dec-2021
The version 6.3.1 release includes:
Lianja App Builder 6.3.2 Release
Released 17-Dec-2021
The version 6.3.2 release includes:
- Added Sparkline Charts in grid cells: specify the Spark line expression to return a comma separated list. Load the "Example Grid Badges" App (example_gridbadges) to see them in operation.
- Added Ratings in grid cells: specify a greater than 0 value in the new Rating max value attribute. Load the "Example Grid Badges" App (example_gridbadges) to see them in operation.
- Performance and stability improvements.
- Various bug fixes.
Lianja App Builder 7.0 Release
Released 03-Feb-2022
The version 7.0 release includes:
Lianja App Builder 7.1 Release
Released 09-Mar-2022
The version 7.1 release includes:
Report Builder Improvements
- New report delegates:
- Row Renderer
- Before Row
- After Row
- Text Translator
- Improved report print layout engine.
- Corrected report chart printing.
- Added 'Pagebreak After Summary' checkbox to Grouping settings.
- Added 'Page Left Margin' and 'Page Right Margin' to Page Layout settings.
- Added 'Page Orientation' combobox to Page Layout settings: Portrait or Landscape.
- Drag and drop of columns to reorder them.
- New 'Backup' and 'Restore' Report Builder toolbuttons. Keep versions of your reports as you design them. Roll changes back at any time.
- New Page Layout Custom Options.
- Group summary now also supports count to display number of rows in the group.
- Various bug fixes.
- New system object methods to simplify report printing and viewing:
- Lianja.showReportViewer(cReportName [, cOptions])
- Lianja.printReport(cReportName [, cOptions])
- Lianja.printHtml(cHtml [, cFilename [, cOptions]])
Script Editor Improvements
- Improvements to search operations in the Script Editor:
- Added 'Find Next' keyboard shortcut: Ctrl + . (>).
- Added 'Find Previous' keyboard shortcut: Ctrl + , (<).
- Added a Search Bar which searches across all files in the App of Library. Just type text and press return
WebView Enhancements
ImageStrip Enhancements
- New improvements to the functionality of ImageStrip Sections.
- New example_imagestrip demo App included in the Lianja App Builder distribution.
- New Image viewer to show a larger version of the selected image.
- One-click/touch access to the image notes editor.
- One-click/touch access to add or delete images.
New Update Distributions
- New smaller, quicker to install 'update' distributions for the following:
- Lianja App Builder for Windows
- Lianja Cloud Server for Windows
- Lianja App Builder for Linux
- Lianja Cloud Server for Linux
Additional Improvements
- Added a new system table sysfiles: select * from sysfiles where filename == 'pattern' [into cursor yourfiles]. This fills a cursor with details of all the matching files in the current directory. It is particularly useful if you have tens of thousands of files to process and it is impractical to load their details into an array in memory.
- Added an additional parameter to keyLookup(). If set to true and the keylookup table was not open, it is left open after the first call to improve performance.
- Lianja packages can now include huge files greater than 1GB. This provides the ability to deploy huge databases in packages.
- The section Before Data Update event delegate can now cause the update to be cancelled when its return value is false. It can include custom validation with Lianja.showErrorMessage() used to provide user feedback.
- Added a new Virtual Table property to handle character mapping between utf-8 and locale specific encoding for use with the VFP OLEDB driver, e.g. codec=windows-1252. See here for supported codepage values.
- VFP OLEDB Virtual Table performance improvements.
- Improved memory management.
- Performance and stability improvements.
- Various bug fixes.
Lianja App Builder 7.2 Release
Expected release Q2 2022
The version 7.2 release will include:
Extended Python Support
Visual Components Improvements
- Visual Components built in the Canvas Designer can now use LianjaScript, JavaScript or Python as the scripting language. Previously only JavaScript was supported.
- New Visual Component/Form Manager (enhanced Component Gallery)
- 'NEW' button to create a new component opens/creates the mycomponents App with a new Page and Canvas Section.
- Double-click a component's tile to open its containing App to edit the component.
- Navigate between editing components in different Apps with 'Back' and 'Home' buttons.
- When a Canvas Section is saved as a Visual Component, the component is saved in the current App as well as the specified components directory. This provides the ability to visually design component forms in LianjaScript/VFP, JavaScript and Python.
- New Lianja.showDialogForm() Lianja system object method to activate component forms.
- New initForm event delegate for Canvas Sections. This delegate is called when a Visual Component form is activated. You can open a database and the database tables required by the component form in this delegate. Note that activating a form will automatically PUSH DATASESSION / POP DATASESSION so there is no need to do this.
Page Builder Assistant Improvements
- The Page Builder Assistant is now embedded in the App Inspector to speed up development, giving quick access to key Page, Section, Formitem and GridColumn attributes and delegates and easy navigation between the UI elements.
- Many Page Builder Assistant additions and improvements:
New Cryptographic Hash Functions
- Added several new cryptographic hash functions. SHA-256 is a popular hashing algorithm used in Bitcoin encryption (and other blockchain applications):
- sha256(cExp) - this returns the SHA256 cryptographic hash for the specified character string.
- sha256file(cFilename) - this returns the SHA256 cryptographic hash for the specified file.
- sha256record([alias]) - this returns the SHA256 cryptographic hash for the current active record.
- crc32record([alias]) - this returns an 8 byte hexadecimal value (a cyclic redundancy check) for the current active record.
Additional New Functions
- New function tableSeqno(cDatabase, cTable). You can use this to apply a default seqno() in client/server Web Apps. If you use seqno() in a default value for a column then when the App is generated as a Web or Mobile App seqno() will automatically be translated to use tableSeqno().
- New gmtime() function to return a datetime expressed in Coordinated Universal Time (UTC).
Debugging Improvements
- New Form method to help in debugging custom forms: printObjectTree().
// example output:
form::form [visible=0, height=700, width=700]
mycontainer5::container [visible=0, height=480, width=640]
myheader5::label [visible=0, height=40, width=156]
grid5::grid [visible=0, height=192, width=256]
- New writeoutput() function and ? > command that can be used in server-side Lianja Server Pages in Web Apps to assist in debugging.
- Add the set debugout on command to the .rsp script along with writeoutput() or ? > calls.
- Open the App in the browser using Preview live in browser.
- Monitor the writeoutput() and/or ? > display in the App Builder Console workspace.
CarouselView Improvements
Virtual Table Improvements
New Groupbox Style Labels
- Canvas Section Label advanced controls can now be styled as groupboxes:
Additional Improvements
- Added a new Web/Mobile App Setting: Disable success notifications. This operates in Web/Mobile Apps to disable the 'noise' from successful operations such as updating records, uploading images etc. Notifications only occur when an error occurs.
- Improved SQL compatibility with Visual Foxpro.
- SQL optimizer improvements and fixes resulting in an overall speed boost.
- Improved garbage collection.
- UI datetime date display format now defaults to the system locale. It can be changed using the set dateformat command.
- Improved deployment. Select only those files to be deployed and they will be compiled if required and then deployed. Use 'Preview' first to verify the files that will be deployed.
- When saving data as xml/excel (SELECT or COPY) any invalid characters are now escaped.
- Usability improvements in grid editing.
- Many Canvas Designer improvements.
- Minor UI improvements.
- Performance and stability improvements.
- Various bug fixes.
Lianja App Builder 8.0 Release
Expected release 2022
The version 8.0 release will include:
Lianja App Builder 9.0 Release
Expected release date 2022
The version 9.0 release will include:
- Apps to optionally be generated as "React Native" Apps.
- Native Windows x64 build.
- Visual FoxPro Report (.frx file) import tool into the Lianja Report Builder.
- Visual Form/Dialog Builder that works with existing VFP .scx and .vcx files.
- Performance and stability improvements.
- Fix reported bugs.
Lianja App Builder 10.0 Release
Expected release date 2022
The version 10.0 release will include:
- Cross platform .NET Core SDK integation
- Add dynamically compiled C#.NET as a supported language cross platform.
- Performance and stability improvements.
- Fix reported bugs.
Lianja SQL Server 6.0 Release
Released 31-Mar-2021
The version 6.0 release includes:
- Performance and stability improvements.
- Fix reported bugs.
Lianja SQL Server 6.0.1 Release
Released 6-Apr-2021
The version 6.0.1 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.0.2 Release
Released 15-Apr-2021
The version 6.0.2 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.1.0 Release
Released 18-Jun-2021
The version 6.1.0 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.2 Release
Released 07-Jul-2021
The version 6.2 release includes:
- Significant performance improvements
- Bug fixes
Lianja SQL Server 6.2.1 Release
Released 27-Jul-2021
The version 6.2.1 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.3 Release
Released 09-Dec-2021
The version 6.3 includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.3.1 Release
Released 13-Dec-2021
The version 6.3.1 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 6.3.2 Release
Released 17-Dec-2021
The version 6.3.2 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 7.0 Release
Released 03-Feb-2022
The version 7.0 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 7.1 Release
Released 09-Mar-2022
The version 7.1 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 7.2 Release
Expected release Q2 2022
The version 7.2 release includes:
- Performance improvements
- Bug fixes
Lianja SQL Server 8.0 Release
Expected release 2022
The version 8.0 release will include:
- Available as a docker image.
- Native Windows x64 build.
- Fix reported bugs.
Lianja Cloud Server 6.0 Release
Released 31-Mar-2021
The version 6.0 release includes:
- Note: the location of the Lianja 64 bit ISAPI extension for IIS has changed. See ISAPI Extension for IIS for full details.
- Performance and stability improvements.
- Fixed various reported tickets.
Lianja Cloud Server 6.0.1 Release
Released 6-Apr-2021
The version 6.0.1 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.0.2 Release
Released 15-Apr-2021
The version 6.0.2 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.1.0 Release
Released 18-Jun-2021
The version 6.1.0 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.2 Release
Released 07-Jul-2021
The version 6.2 release includes:
- Significant performance improvements
- Bug fixes
Lianja Cloud Server 6.2.1 Release
Release 27-Jul-2021
The version 6.2.1 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.3 Release
Released 09-Dec-2021
The version 6.3 includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.3.1 Release
Released 13-Dec-2021
The version 6.3.1 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 6.3.2 Release
Released 17-Dec-2021
The version 6.3.2 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 7.0 Release
Release 03-Feb-2022
The version 7.0 release includes:
- Performance improvements
- Bug fixes
Lianja Cloud Server 7.1 Release
Released 09-Mar-2022
The version 7.1 release includes:
- Performance and stability improvements.
- Fixed various reported tickets.
Lianja Cloud Server 7.2 Release
Expected release Q2 2022
The version 7.2 release will include:
- Performance and stability improvements.
- Fixed various reported tickets.
Lianja Cloud Server 8.0 Release
Expected release 2022
The version 8.0 release will include:
- Available as a docker image.
- Performance and stability improvements.
- Fixed various reported tickets.
Lianja Cloud Server 9.0 Release
Expected release 2022
The version 9.0 release will include:
- Handle UI states in the Web and Mobile clients.
- Handle dynamic roles and permissions just like the desktop version already does.
- Synchronization of data from offline to online (Lianja Cloud Server) mode in Lianja Mobile Apps.
- Native SSL support (https://) without having to use IIS or Apache.
- Native windows x64 build.
- Performance and stability improvements.
- Fixed various reported tickets.
Lianja Cloud Server 10.0 Release
Expected release date 2022
The version 10.0 release will include.
- Cross platform .NET Core integration.
- Performance and stability improvements.
- Fix reported bugs.
Lianja Cloud 1.0 Release
Expected release 2022
The version 1.0 release will include.
Lianja Cloud is a no compromise solution that takes the pain out of cloud adoption and lets you concentrate on your business Apps.
- A multi-tenant solution running on AWS.
- Subscribe online at www.lianjacloud.com for your own tenancy.
- Pay monthly or annually to save money. View you AWS monthly costs in real time in the Lianja Cloud Admin Console "Billing" panel.
- A fully scaleable architecture using best-of-breed Amazon AWS technologies. Load balanced, Containerized, horizontally scaleable, replicated data, automatic backups.
- Use Lianja App Builder to DEVELOP, TEST and DEPLOY your custom Apps and Data then easily SHARE these with your team, company or customers in the cloud. Lianja Cloud provides secure, reliable access to your custom Web and Mobile apps developed using Lianja App Builder.
- Configure your own custom domain name e.g. apps.yourcompany.com in the Lianja Cloud Admin Console.
- Users access your custom web apps through the Lianja App Center after authenticating in your Lianja Cloud tenancy.
- Includes the Lianja Cloud Admin Console for administration of users, permissions, row level security and column data masking based on user roles. The Lianja Cloud Admin Console is a web-based UI that allows you to monitor and administer your Lianja Cloud tenancy.
- After you create and set up your Lianja Cloud tenancy you can use the Lianja Cloud Admin Console to assign an SSL certificate and perform tenancy monitoring and a variety of administration tasks.
- Monitor your Lianja Cloud tenancy in the Lianja Cloud Admin Console "Dashboard" panel. View connected users, disk usage, CPU usage, network I/O and other useful information in the "Dashboard".
- Configure automatic and/or manual snapshot backups in the Lianja Cloud Admin Console "Backups" panel. Easily restore from a snapshot backup.
- ODBC drivers for Lianja, MySQL, MSSQL and PostgreSQL are pre-installed.
- Handles hot updating of Apps, Library and Data schemas while users are active simply by creating a lianja .lpk file in the "Deploy" workspace and upload it to your Lianja Cloud tenancy "packages" folder. The Lianja Cloud tenancy can handle both "automatic" updates and manual updates as specified in the Lianja Cloud Admin Console "Configuration" panel.
- Pay as you grow: Available for 5, 10, 25 or 100 concurrent users, or alternatively BYOL (Bring Your Own License). Upgrade at any time in the Lianja Cloud Admin Console "Subscriptions" panel.
- Running on Linux x64 instances to minimize costs and optimize performance.
- Continuous Deployment of your Lianja Web and Mobile Apps. Integrated with GitHub.
|