Centralize your business logic using stored procedures on Valentina Server.
Valentina Server 14 introduced a completely new Python implementation that supports using Python as a native language for Stored Routines: Stored Procedures and User Defined Functions. Now make use of over 160 standard Python modules as well as third party and custom Python modules.
Why Stored Routines Anyway?
Stored routines are stored in the database, reducing network traffic between Valentina CLIENT and Valentina Server. Build cursors, iterate records and calculate value(s) entirely on the server. If you use Valentina CLIENT, you can make calls individually to Valentina Server, when you load the next record of a cursor. The network itself can be the primary bottleneck of client-server applications. If you use stored procedures instead, then you get almost no network traffic for this calculation and get back only the result.
Expand the Value of Your Business Logic
Your solution likely uses some form of special business logic. You can implement that within your application, but that effectively locks up your business logic within that single app. Moving that business logic over to stored procedures, not only does the server do all of the heavy lifting and give you back the result, but then you can selectively reuse that business logic among solutions that can access Valentina Server.
The Python Advantage: Rich Standard Library
Most SQL databases support stored procedures using SQL, but the number of functions are limited. For example, there are about 80 functions in ValentinaDB. Python has a vast standard library that includes modules for tasks such as data manipulation, regular expressions, file I/O, and more. Python's support for modular code through functions, modules, and packages makes it easier to write reusable and maintainable code. This richness allows developers to perform complex operations within the database environment, which might be cumbersome in other procedural languages.
Using Stored Procedures in Python from Xojo
|
|
Even though the Stored Procedures are in Python, they can be called from your Xojo app using the Valentina CLIENT for Xojo. Using just the CLIENT, you can CREATE / MODIFY / DELETE and execute stored procedures on Valentina Server. The Valentina CLIENT portion of Valentina ADK for Xojo is licensed at no additional cost along with Valentina Server, ValentinaDB ADK for Xojo and Valentina Reports for Xojo.
|
The Local Runtime portion of the Valentina ADK for Xojo installer is the portion used by ValentinaDB ADK for Xojo and Valentina Reports ADK for Xojo.
Beause the stored procedures are stored within a ValentinaDB database, you can test them locally as well.
Ω