Cookbooks

A cookbook of practical, runnable recipes for each plx dialect. Every recipe was executed on PostgreSQL: plx transpiles the body to plpgsql and the standard interpreter runs it, and the output shown is the real captured result.

Each cookbook follows the same menu, so you can compare how a task reads across dialects: a scalar function, an accumulating loop, building a string, looping over a query, a set-returning function, error handling, a trigger, dynamic SQL, and a few idioms specific to the language.

Dialect	Cookbook	Reference
Ruby	Ruby cookbook	plxruby
PHP	PHP cookbook	plxphp
JavaScript	JavaScript cookbook	plxjs
TypeScript	TypeScript cookbook	plxts
Python	Python cookbook	plxpython3
Go	Go cookbook	plxgo
COBOL	COBOL cookbook	plxcobol
Oracle PL/SQL	PL/SQL cookbook	plxplsql
Transact-SQL	T-SQL cookbook	plxtsql

For the same worked examples shown side by side across dialects, see the User guide. For what each dialect cannot do, see Gaps and limitations.