Due to realizing the full potential of the six most advanced programming paradigms, lsFusion has the completeness of ERP platforms, outperforms SQL platforms in declarativeness and performance, while being almost as flexible and scalable as ORM platforms.

All this makes lsFusion a kind of silver bullet in business / web application development with not extremely large budgets and number of users.

Compare by features
  • features
  • non-functional requirements
  • role
See all Features

Name ERP RDBMS + UI ORM + UI RAD Electronic tables lsFusion
Subtype Commercial Free
Examples SAP, MS Dynamics AX Oracle + (Oracle Forms / ADF), MS SQL + (Wrms) Postgres, MySQL, Firebird Java Spring, Odoo, J2EE, .NET MS Access, Foxpro, Delphi, 1C 8.1 or earlier Excel, Google Docs lsFusion
Single language for data There is no object–relational impedance mismatch in the platform - when a developer has to constantly choose between "fast" SQL queries and code in a "convenient" imperative language. Both approaches are so abstracted and combined that the boundary between them is almoKt non-existent. The developer always works with data in the same paradigm, and how and where all this work is done is entirely the responsibility of the platform itself. -Although 4GL languages (ABAP, C #, Foxpro, etc.) provide native support for SQL, they still operate with concepts from relational algebra such as tables, groups, joins, etc. -Although 4GL languages (ABAP, C #, Foxpro, etc.) provide native support for SQL, they still operate with concepts from relational algebra such as tables, groups, joins, etc. -Although 4GL languages (ABAP, C #, Foxpro, etc.) provide native support for SQL, they still operate with concepts from relational algebra such as tables, groups, joins, etc. -Although 4GL languages (ABAP, C #, Foxpro, etc.) provide native support for SQL, they still operate with concepts from relational algebra such as tables, groups, joins, etc. -Although 4GL languages (ABAP, C #, Foxpro, etc.) provide native support for SQL, they still operate with concepts from relational algebra such as tables, groups, joins, etc. - +
Single paradigm for UI The platform doesn't split the user interface into interactive forms and reports. Any form can contain both input and calculated data and can be displayed in a print (like a classic report) or interactive (editable) view. Accordingly, users can not only see the data they need to make a decision, but also immediately enter the decision they've made through the same UI. - - - - - + +
Server-to-client access The platform doesn't split business logic into server and client sides, which allows developers to request modal interaction with the user at any time. In this case, the platform automatically pauses the current action, sends a request to the user, and resumes the action as soon as the response is received. +Supported only in 4GL language-based platforms (SAP) - - - + + +
No ORM, Yes SQL WhWhen a certain action involves data processing for many objects at once, the platform tries, whenever possible, to perform this processing on the database server with a single query (i.e. for all objects at once). In this case, all generated queries are optimized as much as possible depending on the features of the database server. +/- + + - - - +
Data change events The platform allows you to create event handlers for any changes in any data (even calculated data). The use of this mechanism allows you to significantly increase the modularity of the created solutions. -/+Triggers (events) only for data materialized in a single table (class). -/+Triggers (events) only for data materialized in a single table (class). -/+Triggers (events) only for data materialized in a single table (class). -/+Triggers (events) only for data materialized in a single table (class). - - +
Dynamic physical model The platform allows you to materialize any existing indicators in the system at any time, add new tables or delete existing ones, or change the location of materialized indicators in these tables. -/+There is no transparent data materialization - only objects and their fields can be mapped to tables with a single key (i.e. you can only handle tables with two or more keys directly through SQL). - - -/+There is no transparent data materialization - only objects and their fields can be mapped to tables with one or two keys (i.e. you can only handle tables with three or more keys directly through SQL) - - +
Constraints on any data The platform allows you to create constraints on the values of any data (even calculated data). All such constraints (as well as events) are global, so an inexperienced user or developer cannot break them with an incorrect transaction. - -/+Constraints only for formulas involving data materialized in a single table -/+Constraints only for formulas involving data materialized in a single table - - - +
Absolute reactivity All calculated data is automatically updated once the data it uses is changed. This rule applies always and everywhere, whether you're displaying interactive forms or simply accessing data inside the action being executed. -/+In the UI for special cases involving input data. -/+There are some reactive elements in the materialized (indexed) view mechanism. -/+There are some reactive elements in the materialized (indexed) view mechanism. -/+In the UI for special cases involving input data. -/+In the UI for special cases involving input data. + +
Cross-platform server Supports any OS for which JVM is implemented, as well as the most popular relational databases. +/-No optimizers for adapting queries to the features of specific databases (e.g. lack of certain optimizations in free databases such as predicate push-down, various handlings for custom aggregate functions and recursions, etc.). In fact, all of these platforms are simply translators into the corresponding syntax. - - +/-No optimizers for adapting queries to the features of specific databases (e.g. lack of certain optimizations in free databases such as predicate push-down, various handlings for custom aggregate functions and recursions, etc.). In fact, all of these platforms are simply translators into the corresponding syntax. - - +
Open database structure The mapping of logic to the database is absolutely transparent, and the developer can totally control this process. No generated names or surrogate tables. + + + + + + +
Cross-platform client The platform supports both desktop and web clients. For the desktop client, as well as for the server, the platform supports any OS for which there are JVM implementations. Also, since relative (rather than absolute) positioning is used for the components, they are rendered in the web client natively using CSS (without JavaScript), which significantly improves UI responsiveness in the web client. In addition, neither the desktop nor the web client contain any application logic, which greatly simplifies their deployment (i.e. you can use the same client for any logic). + -/+It depends on the specific UI. However, using the desktop and web versions simultaneously is not supported. -/+It depends on the specific UI. However, using the desktop and web versions simultaneously is not supported. -/+It depends on the specific UI. However, using the desktop and web versions simultaneously is not supported. - + +
Declarative handling of external formats Any form can not only be shown to the user interactively or printed out, but also can be exported in most popular data formats (JSON, XML, CSV, XLS, DBF, etc.). This operation is symmetrical - you can also import data from a file in any of these formats back into the form. Both processes are absolutely declarative and use the same concepts as the UI, which greatly simplifies interaction with external systems. -/+Handling of external formats is strictly imperative (with small signs of declarativeness in certain mechanisms such as those for handling XML for remote calls in Web services using WSDL) and is performed in a separate paradigm (unrelated to the UI). -/+Handling of external formats is strictly imperative (with small signs of declarativeness in certain mechanisms such as those for handling XML for remote calls in Web services using WSDL) and is performed in a separate paradigm (unrelated to the UI). -/+Handling of external formats is strictly imperative (with small signs of declarativeness in certain mechanisms such as those for handling XML for remote calls in Web services using WSDL) and is performed in a separate paradigm (unrelated to the UI). +/-Handling of hierarchical formats (JSON and XML) is usually declarative, but is performed in a separate paradigm (unrelated to the UI). -/+Handling of external formats is strictly imperative (with small signs of declarativeness in certain mechanisms such as those for handling XML for remote calls in Web services using WSDL) and is performed in a separate paradigm (unrelated to the UI). -/+Handling of external formats is strictly imperative (with small signs of declarativeness in certain mechanisms such as those for handling XML for remote calls in Web services using WSDL) and is performed in a separate paradigm (unrelated to the UI). +
Efficient client-server communication Client-server communication at the physical level minimizes synchronous round-trip calls (i.e. each user action leads to a single - usually asynchronous - request/response pair). The desktop client also archives and encrypts all transferred data (when necessary). During client-server communication (via TCP/IP for the desktop client or HTTP for the Web client), the platform provides guarantee of delivery - it resends any lost requests and ensures that they are processed in the correct order. All these features help the platform run efficiently even on low-bandwidth, unstable, or high-latency communication channels. - - - - - - +
Transparent integration The platform supports access to the system via the most common general-purpose application protocol (HTTP), and the access interface includes not only execution of some action (with automatic argument parsing), but also execution of lsFusion code (as when accessing SQL servers). In addition, the platform at the language level supports access to SQL servers, other lsFusion systems, any external systems via HTTP, etc. And, since the server itself is implemented as a Spring bean, you can manage its life cycle using a standard Spring IoC container. All these features allow you to use lsFusion not only as a fully-fledged development platform, but also as a database or even as a Java library. -/+No code execution (as in SQL servers). All communications are performed either through HTTP without parsing any arguments or through WSDL (XML) with parsing arguments. Cannot be loaded as a library. +/-Cannot be loaded as a library. +/-Cannot be loaded as a library. +/-Code execution (as in SQL servers) is not supported. - - +
CI in ACID right out of the box The platform can safely roll back the state of the application server to the state at the start of any transaction. This allows you to use the native integrity tools of modern SQL servers, which not only significantly reduces labor costs and chances of human errors when developing a system for a highly concurrent environment, but also makes such a system much more scalable (provided that versioned DBMS are used). - + + - - - +
Transparent linking of Java libraries / SQL functions The application server runs on a Java virtual machine (JVM), which allows you to link any of the numerous existing Java libraries to it. All you have to do is create your Java action, register it with the platform, and then use it just like any other action written on the platform's language. Similarly, you can transparently use custom SQL functions of the database server you're using. - + + + - - +
Everything as code All elements of the system, from events to form design, are written in the lsFusion language and stored in plain text files (without any shared repositories with an unknown structure). This allows you to use popular version control systems (Git, Subversion) and project-building tools (Maven, Gradle, built into IDEs) when working with projects. In addition, this approach simplifies the support and deployment of the system you develop, because it allows, first, using a simple text editor to view and, if necessary, quickly modify the logic, and second, easily identify any element in the system, by its file and line number in this file. -/+Forms and other metadata (tables, ledgers, etc.) are usually created interactively and stored in binary form in a shared repository or file (data export is possible, but not in formats that allow convenient editing/viewing such as XML). -/+Basically, the database theoretically allows you to work with the database's structure as with code - you can create scripts marked "CREATE OR REPLACE" and/or with versions and ADD/DELETE commands, then remember the previous version of the database to deploy or roll back changes between these versions, but by default this is not part of the database itself and should be organized directly by developers. -/+Basically, the database theoretically allows you to work with the database's structure as with code - you can create scripts marked "CREATE OR REPLACE" and/or with versions and ADD/DELETE commands, then remember the previous version of the database to deploy or roll back changes between these versions, but by default this is not part of the database itself and should be organized directly by developers. + + - +
Low-code language The platform allows you to group element names into namespaces and consider names in the same namespace as having higher priority when searching for elements. In most cases, you need to specify only the "short" name of the element you're searching, which makes the code more concise and readable. In addition, you can specify a class for each parameter in the code, and this class will also be taken into account during elements search (i.e. explicit typing is supported). This not only makes your code shorter and simpler, but also gives you early error detection, smart auto-completion, and lots of other useful features. - -/+The databases support namespaces, but do not support explicit typing (because they work with tables rather than functions, i.e. they do not support any parameters at all). -/+The databases support namespaces, but do not support explicit typing (because they work with tables rather than functions, i.e. they do not support any parameters at all). + - - +
Powerful IDE Intellij IDEA-based IDE with everything developers could ever need: usages search, code/error highlighting, smart auto-completion, quick jump to declarations, class structure, renaming of elements, usage tree, data change breakpoints, debugger, and many other features. -/+ +/-In general, two different specialized IDEs are used (one for the client and one for the database server), so no calls between the server and client are supported at all (i.e. they are not visible in uses, renaming, etc.). +/-In general, two different specialized IDEs are used (one for the client and one for the database server), so no calls between the server and client are supported at all (i.e. they are not visible in uses, renaming, etc.). + -/+ - +
Metaprogramming Do you want to create your own high-level operator, or maybe you just don't know how to generalize the logic, but want to reuse it? The platform provides full support for automatic code generation, both server-side and IDE-side. - - - + - - +
Three-tier architecture The platform executes the imperative part of the system logic (i.e. everything related to data changes) on application servers and the declarative part (i.e. everything related to data calculations) on database servers. This separation simplifies the scaling of the system you develop and strengthens its fault tolerance due to the different nature of workload on these servers (e.g. using swap on an application server is much more dangerous than on a database server). + -/+Technically, the third tier (application server) is implemented by either the Web client or the database server. -/+Technically, the third tier (application server) is implemented by either the Web client or the database server. + - - +
Clustering Since the application servers don't have any shared data, you can easily add as many of them as you need. In addition, the platform can transfer user data between database servers asynchronously, which, in turn, allows you to dynamically distribute the workload among them. For example, if data is written to the database (and thus ACID is needed), performing processing on the masters, and in other cases - on the least loaded slaves. +/-In addition to the database, yet another bottleneck and a potential point of failure is the lock manager, which also makes clustering harder. + -/+ + - - +
Extensions The extension technique allows developers to extend the functionality of one module in another (e.g. modify forms or classes created in another module). This mechanism makes the solutions you create much more modular. - - - - - - +
Asynchrony The platform tries to perform all operations asynchronously whenever possible (i.e. return control to the user without waiting for the operation to complete). For example, such operations include most input operations and local event handling. - - - - - + +
Polymorphism and aggregations The platform supports inheritance (including multiple inheritance) and polymorphism (again, including multiple polymorphism). And, if inheritance isn't enough for you for whatever reason, the platform also provides an aggregation mechanism that, together with inheritance, allows you to implement almost any polymorphic logic. -/+Only single inheritance of tables (object classes) and single polymorphism are supported. -/+Only single inheritance of tables (object classes) and single polymorphism are supported. -/+Only single inheritance of tables (object classes) and single polymorphism are supported. -/+Only single inheritance of tables (object classes) and single polymorphism are supported. - - +
WYSIWYG The platform provides a lot of WYSIWYG features right out of the box. For example, the user can edit any data that he sees, do it at once for all visible objects (group editing), do copy-paste (including, for example, from Excel), merge / undo / save the changes made and do many other things that he is used to doing with Excel. - - - - - + +
Internationalization Within any string literal (e.g. an element caption or string constant) the platform allows to use IDs (in brackets) to which you can then set different texts for different languages. Accordingly, when this literal is accessed, the platform automatically localizes it depending on the language settings of the user, whose actions lead to this access. + + - + - - +
Retroactive changes The platform allows users to change any previously-entered data (e.g. to fix input errors) and only updates the data that is actually needed without thousands of related reversal operations, long reposting, or global database locks. In addition, the platform allows the simultaneous editing of the same data (e.g. the same document), which can be critical if you have a lot of data or need to enter it very quickly. - - - - - + +
Advanced administration tools The platform provides a complete set of administration tools: interpreter - executes lsFusion code, process monitor - gets information about the current processes (such as call start time, stack, user, etc.), scheduler - executes action at specified times (including periodically), profiler - measures the performance of all actions executed for all/given users (builds a graph of calls, time division between the application server and the database server, etc.), messenger - for internal notifications/communication with users in the system, and numerous logs - connections, errors, etc. + + -/+ - - - +
Advanced interactive UIs When interacting with a user, the platform can display any data not only as single objects and lists, but also as trees, both flat ("nested") and recursive (e.g. classifiers). Moreover, if there is too much information, the platform allows you to group various form blocks into folders (tabs) and named collapsible containers. In this case, when the data is not visible to the user, it is not read/calculated (e.g. all lists are dynamic by default, i.e. only a limited number of objects are read initially, while the rest of them are read as the current object in the table is changed). -/+Trees are only recursive and only for explicit (not computed) hierarchies. Dynamic lists are implemented manually by writing special queries. -/+Trees are only recursive and only for explicit (not computed) hierarchies. Dynamic lists are implemented manually by writing special queries. - - - +/- +
Security policy A flexible security policy allows you to define data access restrictions both at the form level and at the level of specific actions / indicators. In this case, the user will not only not see this data, but will not even be aware of its existence. + + + + - - +
Open source code The open source code of the platform and IDE allows developers to study the behavior of the platform from the inside, create pull requests or custom builds, as well as license the developed solutions to be used in a strict security environment. - - + + + - +
Deep user customization Users can customize any form, e.g. add custom selections and sorting rules, add / remove / reorder columns. Also, on any form the user can perform basic analysis - group the data he sees, calculate sums / maximums and other aggregates. In addition to the UI settings, users can also add logging, fill-in control, notifications about any data changes (including calculated data), etc. +/-Only basic UI settings (design, selections, ordering) are supported. - - - - +/-Only basic UI settings (design, selections, ordering) are supported. +
Free license The platform is licensed under LGPL v3, which allows you to freely use, distribute, and modify the platform as you wish. - - + + + - +
+Yes
+/-With limitations
-/+In particular cases
-No
NFR ERP RDBMS + UI ORM + UI RAD Electronic tables lsFusion
Examples SAP, MS Dynamics AX Oracle, MS SQL, Postgres + UI (Java, .Net, Delphi) Java Spring, Odoo, .NET MS Access, Foxpro, Delphi Excel, Google Docs lsFusion
Common types of systems Multi-functional low-load systems with structured data Multi-functional high-load systems with structured data Specialized ultra-high-load systems Specialized low-load systems with structured data Specialized low-load systems with unstructured data Any system with structured data (except ultra-high-load systems)
Common industries Business applications (manufacturing, wholesale) Business applications (banking, retail) Web applications (websites, online services, portals) Business applications Any industry Any industry
Development speed 4 3 2 4 3 10
Development simplicity 4 3 2 4 3 10
Modularity 3 3 5 3 1 10
Flexibility 4 7 10 5 3 7
Portability 4 3 9 3 3 10
Supportability 8 6 6 3 2 10
Openness 4 7 10 4 4 10
Usability 6 5 3 5 7 10
Performance 3 9 3 3 3 10
Integrity 4 7 4 4 2 10
Scalability 4 6 10 3 2 8
Security 8 8 6 3 2 10
Internationalization 10 6 10 4 4 10
Cost 4 6 10 8 8 10
NFR ERP RDBMS + UI ORM + UI RAD Electronic tables lsFusion
Examples SAP, MS Dynamics AX Oracle, MS SQL, Postgres + UI (Java, .Net, Delphi) Java Spring, Odoo, .NET MS Access, Foxpro, Delphi Excel, Google docs lsFusion
For developers 4 3 2 4 2 10
For administrators 5 4 4 4 2 10
For users 5 3 3 3 5 10
For businesses 4 3 5 4 5 10