jmoiron/sqlx

Features

• Row-to-Struct Mappers - Uses Go reflection to automatically match database column names to struct fields via custom tags or naming conventions.
• Database Boilerplate Reductions - Reduces repetitive code for error handling and row iteration when working with the standard database/sql package.
• Column Mappings - Offers a customizable naming strategy for matching database column names to struct fields.
• Query Parameter Filters - Converts named SQL parameters into driver-specific placeholders to simplify variable binding.
• Database Query Execution - Binds query parameters using named placeholders derived from map keys or struct fields.
• Named Parameter Bindings - Resolves named placeholders by mapping keys from maps or struct fields to positional arguments required by the driver.
• Query Parameterization - Handles dynamic list expansion and named parameters to simplify variable binding across different database drivers.
• Query Result Fetching - Executes queries and scans output directly into a single destination or slice to reduce manual iteration.
• Query Translators - Translates generic parameter markers into driver-specific symbols to ensure SQL compatibility across different database engines.
• Database API Extensions - Wraps standard database/sql types to provide shorthand methods for scanning rows into slices and structs.
• Connection Establishment - Implements a streamlined process to establish a database connection and immediately verify it via a ping.
• Data Type Mappings - Supports scanner and valuer interfaces to bridge custom application data types with standard database drivers.
• Database Connectivity - Provides mechanisms to open database connections and verify connectivity using context for timeout and cancellation control.
• Database Error Handling - Provides shorthand methods that reduce repetitive boilerplate code when checking for common database errors.
• Dynamic Placeholder Expansion - Converts sets of values into comma-separated placeholders for dynamic search queries.
• Generic Row Scanning - Returns row data as a generic map of column names to values when the database schema is unknown.
• Prepared Statements - Creates prepared statements using a specific context to manage the preparation phase of database operations.
• Named - Replaces named placeholders in SQL statements with struct or map fields and executes within a provided context.
• Placeholder Rebinders - Provides a utility to translate generic parameter markers into driver-specific symbols to ensure SQL compatibility across different database engines.
• Externalized SQL Files - Enables the execution of SQL statements read directly from external files on the filesystem.
• SQL Script Execution - Provides the ability to read SQL statements from the filesystem and execute them as a transaction or batch.
• Database Tools - Extension for standard database/sql package.
• Databases and Storage - Extensions for the standard database/sql library.
• Persistence Frameworks - Extension library for Go's standard database/sql package.
• General Utilities - Extensions for the standard database/sql package.
• General Utility Libraries - Extensions for the standard database/sql package.

Star history