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
stephenafamo avatar

stephenafamo/bob

0
View on GitHub↗

Bob

This project is a database toolkit for Go that provides schema-to-object mapping, fluent query construction, and automated code generation. It functions as a framework for type-safe database access, enabling developers to interact with relational databases by generating models and interfaces directly from existing database schemas.

The toolkit distinguishes itself through a workflow that parses hand-written SQL files to generate type-safe functions, allowing for the integration of custom SQL while maintaining consistent result mapping. It supports modular customization through a plugin-based architecture and uses SQL-comment-based metadata to control the structure of generated code. Additionally, it simplifies development by automatically generating test data factories to streamline the setup of unit and integration tests.

Beyond core generation, the toolkit provides a comprehensive suite for managing the full lifecycle of database interactions. This includes fluent query building across multiple dialects, automated parameter sanitization to prevent SQL injection, and relational mapping that transforms flat query results into nested object structures. It also features lifecycle hooks for executing custom logic during database operations and supports incremental integration, allowing for partial adoption without requiring a full system migration.

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
bob.stephenafamo.com
↗

Features

  • ORM Code Generators - Inspects database schemas to produce type-safe models, query functions, and test data factories for Go applications.
  • Database Schema Code Generators - Inspects existing database schemas to produce type-safe code structures and interfaces that simplify data access and reduce boilerplate.
  • ORM Relationship Querying - The database toolkit fetches associated records automatically using preloading strategies and transforms flat query results into nested structures based on column naming conventions.
  • Fluent Query Construction - Provides a chainable interface for constructing complex SQL statements while ensuring syntax validity and type safety.
  • Type-Safe Query Construction - Constructs complex database queries using a fluent interface that ensures type safety and correct syntax.
  • Fluent Query Builders - Provides a chainable, fluent interface for constructing complex SQL statements with type safety.
  • SQL Query Builders - Provides a fluent interface for constructing type-safe SQL queries across multiple dialects with automated parameter binding.
  • Typesafe Query Executions - Maps query results directly into defined structures to eliminate manual row scanning while managing transactions and prepared statements.
  • Typesafe Query Generations - Analyzes hand-written SQL queries to generate reusable, type-safe functions that handle parameter binding and result mapping automatically.
  • Type-Safe Database Clients - Executes SQL queries and maps results directly into Go structures to eliminate manual row scanning.
  • Go Type Generators - Automates the creation of type-safe Go data structures directly from existing database schemas.
  • Schema-Driven Code Generators - Analyzes existing database structures to produce type-safe models and interfaces, eliminating manual boilerplate.
  • Database Lifecycle Hooks - Triggers custom logic automatically before or after database operations to maintain state and business rules.
  • Database Query Execution - Enables dynamic modification of queries before execution and provides flexible retrieval methods for single records, lists, or cursors.
  • Database Relationship Mappings - Maps associations between database tables to enable eager loading and recursive data retrieval through automated joins or secondary queries.
  • Database Transaction Management - Manages atomic database operations using interfaces that handle the transaction lifecycle and trigger associated hooks automatically.
  • Model Persistence - Inserts generated model instances into the database while automatically handling required relationships to ensure data integrity.
  • Object-Relational Mapping Frameworks - Transforms flat database result sets into nested object structures by interpreting table relationships.
  • SQL Comment Metadata - Allows developers to annotate query metadata using SQL comments to control code generation and structure resulting data objects.
  • Relational Mappings - Transforms flat database query results into nested structures by automatically interpreting relationships between tables.
  • Schema Mappers - Transforms relational database tables into structured Go objects while managing complex relationships.
  • SQL-to-Code Workflows - Parses hand-written SQL files to generate type-safe functions and automated test suites.
  • SQL Injection Prevention - Generates database-specific placeholders for user-provided values automatically to prevent SQL injection vulnerabilities during query execution.
  • Test Data Factories - Generates helper objects and mock data factories to simplify the setup and teardown of database-backed tests.
  • Compile-Time Type Validation - Validates database operations and parameter bindings at compile time to prevent runtime data access errors.
1,739 stars·108 forks·Go·MIT·35 views

Star history

Star history chart for stephenafamo/bobStar history chart for stephenafamo/bob

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Curated searches featuring Bob

Hand-picked collections where Bob appears.
  • Go ORM and Query Builders

Projects sharing features with Bob

These projects share indexed features with Bob. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • aarondl/sqlboileraarondl avatar

    aarondl/sqlboiler

    6,989View on GitHub↗

    sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed structures and query helpers. It functions as a schema-driven code generator, transforming database tables and relationships into executable Go source code. The project distinguishes itself through a type-safe query builder that uses chainable modifiers to construct SQL statements, eliminating the need for raw string concatenation. It utilizes customizable text templates to generate source code, allowing for the aliasing of schema entities and the creation of custom templates

    Godatabasegogolang
    View on GitHub↗6,989
  • doctrine/dbaldoctrine avatar

    doctrine/dbal

    9,699View on GitHub↗

    This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between

    PHPdatabaseibm-db2mariadb
    View on GitHub↗9,699
  • sqlalchemy/sqlalchemysqlalchemy avatar

    sqlalchemy/sqlalchemy

    11,612View on GitHub↗

    SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a

    Pythonpythonsqlsqlalchemy
    View on GitHub↗11,612
  • doctrine/ormdoctrine avatar

    doctrine/orm

    10,172View on GitHub↗

    Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

    PHPhacktoberfest
    View on GitHub↗10,172
Compare all 30 related projects→

Frequently asked questions

What does stephenafamo/bob do?

This project is a database toolkit for Go that provides schema-to-object mapping, fluent query construction, and automated code generation. It functions as a framework for type-safe database access, enabling developers to interact with relational databases by generating models and interfaces directly from existing database schemas.

What are the main features of stephenafamo/bob?

The main features of stephenafamo/bob are: ORM Code Generators, Database Schema Code Generators, ORM Relationship Querying, Fluent Query Construction, Type-Safe Query Construction, Fluent Query Builders, SQL Query Builders, Typesafe Query Executions.

Which projects share features with stephenafamo/bob?

Projects with overlapping indexed features include: aarondl/sqlboiler — sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed… doctrine/dbal — This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting… sqlalchemy/sqlalchemy — SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for… doctrine/orm — Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It… diesel-rs/diesel — This project is a type-safe database toolkit and object-relational mapper designed to enforce structural consistency… uptrace/bun — Bun is a type-safe object relational mapper for Go that prioritizes SQL-first query construction and result mapping.…