Use Moqui Framework to build enterprise applications based on Java. It includes tools for databases (relational, graph, document), local and web services, web and other UI with screens and forms, security, file/resource access, scripts, templates, l10n, caching, logging, search, rules, workflow, multi-instance, and integration.
Background: Mobi's SQL operations can be replaced by XML, either DDL or DML. This is great.
But the problem is that it is not perfect. We still need to use SQL for many functions. Part of the XML and part of the SQL clearly impose an additional burden on operations and maintenance.
Specifically, let me list the situations that are currently not supported:
Flexible adjustment of field length. For example, if my varchar defaults to 40 and I need to adjust it to 32, I need to configure a '<dictionary-type type="varchar32" java-type="java.lang.String" default-sql-type=“VARCHAR(32)"/>' in the configuration file. Once I need to change the configuration, I need to restart the instance, which is obviously not good. Of course, there are usually not many changes in the situation.
Default values are not supported
Does not support self growth
Does not support null or not
My suggestion is to add these support options so that the XML functionality will be more robust, such as:
<field name="id" type=“bigint” length=“20” defalut-value=“0” not-null=“true” auto-inc=“true" is-pk="true"/>
Background: Mobi's SQL operations can be replaced by XML, either DDL or DML. This is great. But the problem is that it is not perfect. We still need to use SQL for many functions. Part of the XML and part of the SQL clearly impose an additional burden on operations and maintenance. Specifically, let me list the situations that are currently not supported:
My suggestion is to add these support options so that the XML functionality will be more robust, such as: <field name="id" type=“bigint” length=“20” defalut-value=“0” not-null=“true” auto-inc=“true" is-pk="true"/>