lib/pq

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 driver for PostgreSQL.
• Database Drivers - Go database driver.

Star history