{"repo":"commandprompt/plPHP","free":true,"listed":false,"github":"https://github.com/commandprompt/plPHP","clone":"git clone https://github.com/commandprompt/plPHP.git","description":"Procedural Language PHP for PostgreSQL","language":"C","stars":56,"topics":["php","plpgsql","postgres","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"Write PostgreSQL functions, triggers, and procedures in PHP. PL/php is a procedural-language handler that lets you write database functions in PHP , stored and executed inside PostgreSQL. You get the convenience of PHP's standard library as a native PostgreSQL function: plain functions, set-returning functions, triggers, event triggers, and procedures with transaction control. [!NOTE] Release 2.0 modernizes PL/php (originally from 2010) for PostgreSQL 18 and the PHP 8 Zend API, installs as a first-class CREATE EXTENSION , and adds a large set of PL/Perl- and PL/Tcl-inspired features. --- Features --- --- 🧩 Scalars, arrays, composites Pass and return ints, text, booleans, multi-dimensional arrays, and composite/record types as native PHP values. 🔁 Set-returning functions RETURNS SETOF / RETURNS TABLE with return next() . ⚡ Triggers Row & statement triggers via $ TD (with SKIP / MODIFY ). 📣 Event triggers Back CREATE EVENT TRIGGER with RETURNS event trigger . 🗄️ Database access (SPI) spi exec , spi fetch row , spi processed , spi status , spi rewind . 📝 Prepared statements spi prepare / spi exec prepared / spi query prepared / spi freeplan . 🔐 Transaction control spi commit / spi rollback in procedures, plus subtransaction() blocks. 🧰 Utilities quote literal / quote nullable / quote ident , elog , session-global $ SHARED and per-function $ SD . 📦 Session setup Anonymous DO blocks, plphp modules autoloading, plphp.on init , and a plphp.start proc hook. 🧬 Native jsonb, h","default_branch":null,"files":null,"tree":[],"storefront":"/r/commandprompt","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/commandprompt/plPHP/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}