One of the important ways to create custom functions for the applications you develop on the Kuika platform is to use SQL actions. Unlike the default system actions that Kuika offers, SQL actions allow you to perform more complex data operations specific to your project.
One of the important ways to create custom functions for the applications you develop on the Kuika platform is to use SQL actions. Unlike the default system actions that Kuika offers, SQL actions allow you to perform more complex data operations specific to your project.
As the name suggests, SQL actions allow you to create customized actions using SQL commands. These actions go beyond the standard system actions in line with your technical knowledge and provide customized solutions to the needs of your application. Kuika provides an easy-to-use SQL editor for these actions. With this editor, you can create your actions by writing your own SQL commands.
For example, in an e-commerce application you developed with Kuika, let's imagine that you have designed a screen where users list products in a gallery view. On this screen, you may want to show the detail information of the products, the number of favorites and the number of reviews about the product. You can easily create this kind of functionality using SQL actions.
You can quickly create relatively simple actions using Kuika's Select Action without writing SQL commands or code. However, for actions that require more complex and extensive processing, you may need to create custom actions using SQL commands. In this case, Kuika's SQL Editor comes into play.
There are two modules in Kuika that you can use to create SQL actions:
The first one is the UI Design Module. You can create your SQL actions while designing your user interface through the UI Design Module.
The other module is Datasources Module. Through the Datasources module, you can manage the operations related to your data sources, define your SQL actions and integrate them into your application.
