Trusted Language Extensions (TLE) for PostgreSQL (pg_tle) is an open source project that lets developers extend and deploy new PostgreSQL functionality with lower administrative and technical overhead. Developers can use Trusted Language Extensions for PostgreSQL to create and install extensions on restricted filesystems and work with PostgreSQL internals through a SQL API.
PostgreSQL provides an extension framework for adding more functionality to PostgreSQL without having to fork the codebase. This powerful mechanism lets developers build new functionality for PostgreSQL, such as new data types, the ability to communicate with other database systems, and more. It also lets developers consolidate code that is functionally related and apply a version to each change. This makes it easier to bundle and distribute software across many unique PostgreSQL databases.
Installing a new PostgreSQL extension involves having access to the underlying filesystem. Many managed service providers or systems running databases in containers disallow users from accessing the filesystem for security and safety reasons. This makes it challenging to add new extensions in these environments, as users either need to request for a managed service provider to build an extension or rebuild a container image.
Trusted Language Extensions for PostgreSQL, or pg_tle, is an extension to help developers install and manage extensions in environments that do not provide access to the filesystem. PostgreSQL provides "trusted languages" for development that have certain safety attributes, including restrictions on accessing the filesystem directly and certain networking properties. With these security guarantees in place, a PostgreSQL administrator can let unprivileged users write stored procedures in their preferred programming languages, such as PL/pgSQL, JavaScript, or Perl. PostgreSQL also provides the ability to mark an extension as "trusted" and let unprivileged users install and use extensions that do not contain code that could potentially impact the security of a system.
To get started with pg_tle, follow the installation instructions.
Once you have installed pg_tle, we recommend writing your first TLE using the quickstart.
You can also find detailed information about the pg_tle extension management API and available hooks.
There are examples for writing TLEs in several languages, including:
pg_tle 1.5.3 supports PostgreSQL major versions 12 to 19 Beta 4.
pg_tle 1.5.0 supports PostgreSQL major versions 12 to 17.
pg_tle 1.4.0 supports PostgreSQL major versions 11 to 17.
Have a question? Have a feature request? We recommend trying the following things (in this order):
We welcome and encourage contributions to pg_tle!
See our contribution guide for more information on how to report issues, set up a development environment, and submit code.
We also recommend you read through the architecture guide to understand the pg_tle design principles!
We adhere to the Amazon Open Source Code of Conduct.
See CONTRIBUTING for more information.
This project is licensed under the Apache-2.0 License.