awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·
jackc avatar

jackc/pgx

0
View on GitHub↗
13,428 stars·997 forks·Go·mit·13 viewspkg.go.dev/github.com/jackc/pgx/v5↗

Pgx

This project is a database driver and interface for the Go programming language, specifically designed for PostgreSQL. It provides a low-level library for executing SQL queries, managing transactions, and handling data persistence within Go applications.

The driver distinguishes itself by implementing the native PostgreSQL binary wire protocol, which minimizes communication overhead and maximizes data transfer efficiency. It includes advanced connection pooling to maintain persistent database sessions and supports prepared statement caching to accelerate the execution of frequently repeated operations.

The toolkit facilitates complex data interactions by providing a query builder for constructing SQL statements and mechanisms for mapping database rows into strongly typed Go structures. These features ensure data integrity and provide a structured approach to managing relational data within backend services.

Features

  • PostgreSQL Connectors - Provides a high-performance driver for establishing native binary protocol connections to PostgreSQL databases.
  • Connection Pool Managers - Maintains a persistent set of active database connections to reduce the latency cost of establishing new sessions for every request.
  • Relational Database Drivers - Provides robust database interfaces and connection pools for interacting with relational data stores.
  • Backend Data Access Layers - Implements reliable data persistence layers in Go services by mapping database rows to application structures.
  • Binary Protocol Implementations - Communicates directly with the database using the binary wire protocol to minimize overhead and maximize data transfer efficiency.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI
  • Type-Safe Database Clients - Transforms raw database result sets into strongly typed language structures using reflection or code generation.
  • Database Interfaces - Implements a low-level interface for executing SQL queries and managing transactions in Go applications.
  • Prepared Statement Engines - Stores pre-compiled query plans on the database server to accelerate execution times for frequently repeated operations.
  • Database Performance Optimizers - Optimizes database communication by leveraging low-level protocol features to reduce latency and improve throughput.
  • Database Transactions - Coordinates the lifecycle of database transactions by tracking state transitions and ensuring atomic execution.
  • Query Builders - Provides a fluent, programmatic interface for constructing database queries while ensuring type safety and security.
  • Type-Safe Query Builders - Provides a toolkit for constructing complex SQL statements and mapping database rows to strongly typed Go structures.
  • Database Drivers - PostgreSQL driver with advanced feature support.
  • Databases and Storage - PostgreSQL driver and toolkit.
  • Database Drivers - Go database driver.
  • Cursor-Based Pagination - Requests large data sets in sequential chunks by passing opaque identifiers to the server to retrieve subsequent pages.
  • Data Query Filters - Applies boolean logic to query parameters to narrow down returned data sets based on specific field values.
  • Pagination - Requests multi-page data sets by using tokens to fetch subsequent segments of a response until all items are collected.
  • Schema-Aware Retrieval - Structures API responses based on predefined field definitions to ensure consistent access to documentation and version history.
  • Package Metadata Querying - Fetches detailed information about a specific package including documentation, dependency imports, and license data.
  • Module Metadata Retrievers - Fetches high-level information about a module including its repository location and version history.

    • Star history

    Star history chart for jackc/pgxStar history chart for jackc/pgx

    Frequently asked questions

    What does jackc/pgx do?

    This project is a database driver and interface for the Go programming language, specifically designed for PostgreSQL. It provides a low-level library for executing SQL queries, managing transactions, and handling data persistence within Go applications.

    What are the main features of jackc/pgx?

    The main features of jackc/pgx are: PostgreSQL Connectors, Connection Pool Managers, Relational Database Drivers, Backend Data Access Layers, Binary Protocol Implementations, Type-Safe Database Clients, Database Interfaces, Prepared Statement Engines.

    What are some open-source alternatives to jackc/pgx?

    Open-source alternatives to jackc/pgx include: npgsql/npgsql — Npgsql is a .NET data provider and client library that enables applications to connect, execute queries, and manage… brianc/node-postgres — This project is a Node.js client for PostgreSQL databases, providing a protocol parser to translate raw binary streams… mysqljs/mysql — This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL… lib/pq — pq is a PostgreSQL driver for Go that implements the standard database/sql interface. It serves as a connection… sfackler/rust-postgres — This project is a native PostgreSQL database driver for the Rust programming language. It functions as a type-safe… ent/ent — Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It…

    Open-source alternatives to Pgx

    Similar open-source projects, ranked by how many features they share with Pgx.
    • npgsql/npgsqlnpgsql avatar

      npgsql/npgsql

      3,702View on GitHub↗

      Npgsql is a .NET data provider and client library that enables applications to connect, execute queries, and manage data within PostgreSQL databases. It functions as a connection manager and translation layer between the application and the database server. The project features a connection manager capable of multi-host connectivity, providing load balancing and automatic failover across multiple servers. It includes specialized support for high-volume data import and export through bulk data operations and a mapping system that translates complex database types, such as arrays and JSON, into

      C#c-sharpdatabasedotnet
      View on GitHub↗3,702
    • brianc/node-postgresbrianc avatar

      brianc/node-postgres

      13,155View on GitHub↗

      This project is a Node.js client for PostgreSQL databases, providing a protocol parser to translate raw binary streams into JavaScript objects. It serves as a driver for executing queries, managing data, and integrating Node.js applications with PostgreSQL backends. The library includes a connection pool manager to reduce network overhead by caching reusable connections and a result streamer that uses cursors to retrieve large datasets incrementally. It also functions as an event listener for subscribing to asynchronous server-side notifications to trigger real-time application events. Broad

      JavaScriptlibpqnode-postgrespostgres
      View on GitHub↗13,155
    • mysqljs/mysqlmysqljs avatar

      mysqljs/mysql

      18,623View on GitHub↗

      This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL protocol to facilitate connecting to, querying, and managing data within MySQL databases. The driver includes a connection pool manager to maintain a cache of reusable database connections, reducing the overhead of frequent network handshakes. It also supports row-by-row result streaming to process large datasets without loading entire result sets into memory. Core capabilities cover SQL query execution, the management of database transactions, and the coordination of multiple

      JavaScriptjavascriptmysqlnodejs
      View on GitHub↗18,623
    • lib/pqlib avatar

      lib/pq

      9,903View on GitHub↗

      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 i

      Go
      View on GitHub↗9,903
    See all 30 alternatives to Pgx→