Pgx

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.
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.

Open-source alternatives to Pgx

Similar open-source projects, ranked by how many features they share with Pgx.

brianc/node-postgres
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 GitHub13,155
mysqljs/mysql
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 GitHub18,623
lib/pq
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 GitHub9,903
ent/ent
ent/ent
17,110View on GitHub
Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It functions as a code generation engine that transforms schema definitions into type-safe database clients, query builders, and migration scripts. By representing data as interconnected entities, the framework enables intuitive traversal of complex relationships and ensures that database interactions remain consistent with the application model at compile time. The framework distinguishes itself through its graph-based approach to data modeling and its reliance on compile-time cod
Goententity-frameworkorm
View on GitHub17,110

See all 30 alternatives to Pgx

jackcpgx

Features

Open-source alternatives to Pgx

brianc/node-postgres

mysqljs/mysql

lib/pq

ent/ent

Star history

Open-source alternatives to Pgx

brianc/node-postgres

mysqljs/mysql

lib/pq

ent/ent