Procedural Languages

LightDB-A supports a pluggable procedural language architecture by virtue of its PostgreSQL heritage. This allows user-defined functions to be written in languages other than SQL and C. It may be more convenient to develop analytics functions in a familiar procedural language compared to using only SQL constructs. For example, suppose you have existing Python code that you want to use on data in LightDB-A, you can wrap this code in a PL/Python function and call it from SQL.

The available LightDB-A procedural languages are typically packaged as extensions. You register a language in a database using the CREATE EXTENSION command. You remove a language from a database with DROP EXTENSION.

The LightDB-A Database distribution supports the following procedural languages; refer to the linked language documentation for installation and usage instructions:

• PL/Container
• PL/Java
• PL/Perl
• PL/pgSQL
• PL/Python
• PL/R