Trusted Language Extensions for Postgres

The development of Trusted Language Extensions (TLEs) by the RDS team aims to make Postgres extensions available on cloud platforms, which currently restrict them due to security concerns. TLEs are written in trusted languages that do not require access to system functions or files, allowing for more flexibility and ease of use. The pg_tle extension enables the installation of TLEs from any database client using a simple function, making it easier for developers to create and share code without needing cloud provider approval. By unifying a standard package platform across Supabase and AWS, the collaboration promotes open source development and speeds up the creation and sharing of new software. The introduction of dbdev, a PostgreSQL Package Manager, further simplifies the installation process with SQL commands, enabling users to easily install TLEs in their database migrations.