choptastic/sql_bridge

This system is a database abstraction layer for Erlang applications, providing a unified interface for interacting with MySQL and PostgreSQL databases. It manages connection pooling, transaction handling, and query execution through standardized adapter modules. The system also includes utilities for SQL logging, primary key generation, and compatibility across different Erlang versions.

The repository now includes a sample configuration file (priv/sample.config) and a compatibility script (priv/compat.escript) in the priv directory. The sample config provides a template for configuring sql\_bridge, including settings for database adapters (MySQL/PostgreSQL), connection pooling, and query token styles. The compat.escript is a legacy tool for handling Erlang OTP version compatibility (pre-17 vs 17+), though it is currently marked as not needing to be run.

priv · high confidence

The application has been renamed from sigma\_sql to sql\_bridge, replacing the legacy emysql-based implementation with new adapter modules (sql\_bridge\_epgsql and sql\_bridge\_mysql\_otp) that support PostgreSQL and MySQL respectively. This change introduces a unified adapter interface, adds support for database transactions, and integrates the erlias library for module aliasing. The old db.erl module and sigma\_sql.app.src have been removed in favor of the new sql\_bridge.app.src which declares dependencies on epgsql, mysql, poolboy, and epgsql\_decimal.

src · high confidence

This release upgrades the MySQL and PostgreSQL bridges to use mainline mysql-otp and epgsql drivers, replacing previous forks and requiring migration of customizations to epgsql codecs. It introduces a new primary key generator with functions to inspect table keys and auto-increment status, fixes a critical transaction bug in the MySQL bridge, and resolves dialyzer errors to ensure full Hex compliance.

(repo-wide) · high confidence

The include directory now provides standardized type definitions for common Erlang data structures (dict, queue, gb\_trees) in compat.hrl to ensure consistent behavior across versions, alongside new SQL logging and placeholder creation macros in records.hrl.

include · high confidence

Added MySQL test database schema and user setup scripts; Added PostgreSQL test database provisioning and schema setup; Added database provisioning script for local and CI test environments.

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

• CAI 57 → 63 (+5.2)
• Rubric changed (rubric-2026.09.12 → rubric-2026.09.18) — scores are not directly comparable.

• Code Health 93 → 93 (+0.0)
• Architecture 100 → 100 (+0.0)
• Maturity 39 → 39 (+0.0)
• Readiness 52 → 72 (+19.7)
• Security 97 → 98 (+0.8)

• Documentation: no installation or build instructions (README.md)
• Documentation: no usage examples (README.md)
• No automated tests
• No tests found
• Test reliability not included

• Banned license: mysql
• Medium CVE: EEF-[CVE redacted] (rebar.lock)
• Unbounded dependency requirement: b64fast
• Unbounded dependency requirement: epgsql
• Unbounded dependency requirement: epgsql_decimal
• Unbounded dependency requirement: erlias
• Unbounded dependency requirement: mysql
• Unbounded dependency requirement: poolboy

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

choptastic/sql_bridge was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.