Wappler 5.3.0 Released

Wappler General Announcements
1

Wappler 5.3.0 Released

Check the new Wappler site at https://wappler.io/
and download Wappler 5.3.0 from your Account Dashboard

Or just do “check for updates” on the Wappler tray icon for automatic install!

What’s New

Finally it is here! The greatly anticipated full local database support for mobile and desktop apps!

Create an SQLite database schema in Wappler’s Database Manager and use it fully as local database in your mobile apps based on Capacitor. You can empower the new SQLite Database actions in App Connect Flows now and fully build complex database queries visually with the same Database Query Builder and Updater you are used to on the server side but now enjoying their power client side in your apps. See Using Local Databases in Mobile and Desktop apps

Note the Capacitor SQLite Connector is a beta extension now to let your try to new functionality first. So make sure you have chosen to run experimental options and have enabled the Beta extensions channel in your Wappler Settings.

We have also greatly improved the Database Manager to support also client side databases in apps, like the ones for Capacitor SQLite plugin and also improved a lot the table data editing in tabs.

Furthermore we have fixed huge amount of issues as reported in our community.

Capacitor SQLite Connector - now as beta extension

  • Add new Databases Query, Insert, Update and Delete flow actions for SQLite databases in Capacitor
  • You can fully use now database actions based on SQLite in Capacitor based projects in Page and App Flows
  • Make sure you create first a database connection in the Database Manager
  • SQLite databases are created locally on the user mobile device
  • Database manager with track your changes and deliver them as schema changes for the SQLite plugin for Capacitor, so that database migration is done automatically
  • Support for Web, iOS, Android and Electron platforms in Capacitor

Mobile Development with Capacitor

  • Auto installation of Capacitor required plugins
  • Add specific auto configuration options
  • Improve auto installation of plugins and includes to be all in the right order
  • Use the latest version for jeep-sqlite
  • Compare plugins version and update if newer
  • Update project files also when plugin modules are updated

Database Manager

  • Auto track data changes in table editors and when the track option is on, save the data next to the schema changes for later apply on deploy
  • Keep also track of deletes
  • Add also id fields to new insert records, together with check if already exist to not be added again.
  • Auto generate the update sql for the new Capacitor SQLite databases, now also with initial data population.
  • Automatically generate inserts statements from changes for the local Capacitor SQLite databases
  • Improved handling of searchPath in Postgres databases, leave it to default when not specified.
  • Auto select the table in database manager when opened in tab editor for data edit
  • Edit Tables in Tab has a new save dialog that allows you to check to keep the changes in a database changes ile as well
  • Implement the new keep IDs option for database changes, default off
  • Added new option to save the record IDs when creating database seeds
  • Improved the table data editor in tab to only pass the changes to the Database Manager when Keep as Changes is selected and not execute them directly, as those will be executed when the changes are applied in the Database manager
  • Fixed the table data editor filter display and options

General

  • Add routing file only if it exists

App Connect Flows

  • Improved data binding inside Page Flows repeaters
  • Enhanced styling for the Flow comments, multi line and better styling
  • Improved listing of output fields in repeats

Server Connect

  • Added No Auto Load as dynamic attribute to the Server Connect component

NodeJS

  • Fixed group action

Fixed issues

7 Likes