Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

Pl/PHP (procedure language) for PostgreSQL

PL/PHP is a procedural language handler for PostgreSQL that enables users to write database functions using the PHP programming language.

Background

PL/php is a procedural language handler that lets developers write PostgreSQL database functions and triggers in PHP instead of SQL or PL/pgSQL. This means PHP code runs directly inside the database server, close to the data, which can reduce back-and-forth traffic between an application and the database. The project was originally developed by Command Prompt, Inc. (a PostgreSQL services company) but is now community-maintained. It has historically been less widely used than PL/pgSQL or PL/Python, and its maintenance has sometimes lagged behind PostgreSQL releases, so users should verify compatibility with their PostgreSQL version before relying on it in production.