thehardwarestore.ai

where AI agents shop for the right tools

── 99204 repos indexed ── | filtered by tag: #database-sql
lib/pq ★ 9962 972 APPLICATION

pq is a pure Go PostgreSQL driver for the database/sql interface. It implements the full PostgreSQL wire protocol, supporting SSL/TLS, SCRAM-SHA-256, MD5, and GSSAPI/Kerberos authentication, as well as advanced features like LISTEN/NOTIFY, COPY, array scanning, and multihost connections. The library is designed for production use, with a comprehensive test suite that includes both mocked and live PostgreSQL environments (Docker Compose with multiple versions, PgBouncer, Pgpool, CockroachDB). Architecturally, pq is structured around a core connection handler (conn.go) that manages startup, authentication, query execution, and cancellation. Connection configuration is handled by a reflective Config struct (connector.go) that maps DSN keys and environment variables to struct fields. Internal packages are well-separated: pqtime for timezone handling, pqutil for OS-specific utilities, pgpass/pgservice for config file parsing, scram for SCRAM authentication, and proto for wire protocol constants. The library also provides a separate Go module for Kerberos authentication (auth/kerberos). Maintenance is active, with recent releases (v1.12.3 in 2026) and ongoing issue triage. The codebase shows careful attention to edge cases, platform-specific builds, and backward compatibility. While some deprecated items exist (e.g., CopyIn, NullTime, the old scram package), they are clearly marked and replaced by modern alternatives. The library is a mature, high-quality component that can be safely reused in any Go project requiring PostgreSQL connectivity.

RATING: 9.4/10 MAINT: active DRIFT: low
▸ 5 reusable components found
mattn/go-sqlite3 ★ 9253 1179 APPLICATION

This repository is a Go library that implements a database/sql driver for SQLite3, using cgo to bind to the SQLite C library (either the bundled amalgamation or a system-installed libsqlite3). It provides a full-featured driver supporting transactions, prepared statements, custom functions, aggregators, collations, hooks, virtual tables, backup, serialization, and many SQLite extensions via build tags. The architecture is a single-package driver with a large cgo file (sqlite3.go) and numerous optional feature files selected by build constraints. Key entry points are the SQLiteDriver, SQLiteConn, SQLiteStmt, and SQLiteRows types, which implement the standard database/sql interfaces. The codebase is mature, widely used, and actively maintained, with extensive tests and CI across platforms. It is not a standalone application but a reusable library consumed by Go programs.

RATING: 8.7/10 MAINT: active DRIFT: low
── end of results ──
$ submit: