luapgsql

Provides native C bindings to PostgreSQL, enabling low-latency database operations without middleware, as highlighted in its key features for direct connectivity.

Supports parameterized queries through its parameter binding feature, ensuring safe SQL execution and preventing common security vulnerabilities.

Offers built-in transaction support, essential for maintaining data integrity in applications that require ACID-compliant database operations.

Follows Lua's philosophy of simplicity, resulting in a lightweight library that integrates seamlessly with Lua ecosystems, as stated in its philosophy section.