LXP provides both dynamic and persistent PostgreSQL database connectivity, allowing for versatile execution of SQL
statements. The
SQL inclusion method
allows the execution of a query from within an LXP document.
Once a query is executed, its results are passed to the LXP parser for inline formatting. These values can either be
displayed immediately, or set as variables for use later in the document.
The persistent connections, inline formatting, and direct SQL query tags lend LXP unparalleled ease of use in the
arrangement of content from a database. An example use of the LXP database connectivity can be found in the
Fingerless
LXP package, a simple and flexible weblog implementation.
