lib/pq
Pq
pq is a PostgreSQL driver for Go that implements the standard database/sql interface. It serves as a connection library and protocol implementation that translates application data types into the binary and text formats required by PostgreSQL.
The project provides specialized utilities for high-performance data ingestion using bulk data loading and a dedicated bulk data importer. It also features an implementation for listening to asynchronous server notifications and provides tools for connection load balancing across multiple hosts and ports.
The driver covers a broad surface of database interaction, including parameterized query execution, prepared statements, and type mapping for arrays and timezones. Security is handled through SSL/TLS encryption, GSSAPI authentication, and utilities for escaping SQL identifiers and literals to prevent injection. Additional capabilities include detailed diagnostic error handling and raw protocol communication debugging.
Features
- PostgreSQL Connectors - Implements a specialized Go driver for establishing and managing secure connections to PostgreSQL databases.
- SQL Database Connectivity - Implements the standard Go database/sql interface to provide seamless connectivity between Go applications and PostgreSQL.
- Connection Establishment - Manages the multi-step authentication and parameter exchange sequence required to establish a secure database session.
- Data Type Mappings - Translates database-specific OIDs and binary formats into native Go types during result set decoding.
- Database Connectivity - Enables the establishment of database connections using structured configurations, URLs, and connection strings.
- Database Drivers - Implements the standard database/sql interface to enable Go applications to interact with PostgreSQL.
- SQL Query Execution - Sends SQL statements to the PostgreSQL server and retrieves the resulting rows for application processing.
- Binary Protocol Implementations - Provides a full implementation of the PostgreSQL binary wire protocol for efficient client-server communication.
- Prepared Statements - Implements prepared statements to improve execution performance and security through pre-compiled query templates.
- Query Parameterization - Supports running SQL statements with markers to pass variables safely and prevent injection attacks.
- Query Result Fetching - Fetches rows from a query sequentially and decodes the raw data into compatible native types.
- Database Authentication - Implements mechanisms for validating user credentials and security tokens to authorize access to PostgreSQL instances.
- Bulk Data Ingestion - Provides high-performance utilities for streaming large datasets directly into tables via specialized bulk ingestion channels.
- PostgreSQL Bulk Importers - Provides a dedicated utility for high-performance data ingestion using PostgreSQL binary and copy protocols.
- Bulk Data Loading - Ships high-performance bulk loading capabilities to stream multiple rows into tables with minimal overhead.
- Encrypted Connections - Establishes encrypted connections to PostgreSQL using various SSL modes and GSSAPI authentication.
- Database Error Handling - Parses PostgreSQL server error codes and diagnostic messages to enable programmatic recovery and debugging.
- SQL Literal Escaping - Wraps string values in single quotes and escapes special characters for safe embedding in SQL statements.
- Load Balancing - Implements algorithms to distribute connection attempts across multiple hosts and ports to ensure availability.
- Ticket-Based Authentication - Supports GSSAPI integration to handle ticket-based authentication for secure database connections.
- Connection Encryption Modes - Enables encrypted connections using various SSL modes to verify server certificates and hostnames.
- Identifier Escaping - Provides utilities to escape database identifiers, wrapping them in quotes to ensure they are treated as literal names.
- TLS/SSL Configurations - Handles the negotiation of encryption levels and SSL/TLS configurations to secure data transit between the application and server.
- SQL Injection Prevention - Prevents SQL injection by using parameterized queries and escaping identifiers and literals.
- Database Notification Listeners - Implements listeners that trigger application events based on asynchronous notifications sent from the PostgreSQL server.
- Database Drivers - Pure Go PostgreSQL driver.
- Database Tools - PostgreSQL driver for Go.
- Database Drivers - Go database driver.
