{"repo":"stephenafamo/bob","free":true,"listed":false,"github":"https://github.com/stephenafamo/bob","clone":"git clone https://github.com/stephenafamo/bob.git","description":"SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite","language":"Go","stars":1772,"topics":["golang","mysql","query-builder","sql","postgres","postgresql","psql","sqlite","sqlite3","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"Bob: Go SQL Access Toolkit Links - [Documentation][docs] - [Reference][reference] About Bob is a set of Go packages and tools to work with SQL databases. Bob's philosophy centres around the following: 1. Correctness : Things should work correctly. Follow specifications as closely as possible. 2. Convenience (not magic): Bob provides convenient ways to perform actions, it does not add unexplainable magic, or needless abstraction. 3. Cooperation : Bob should work well with other tools and packages as much as possible, especially the standard library. Bob can be progressively adopted from raw SQL query strings, to fully typed queries with models and factories generated for your database. Components of Bob Bob consists of several components that build on each other for the full experience. 1. Query Builder 1. SQL Executor for convenient scanning of results 1. Models for convenient database queries 1. Code generation of Models and Factories from your database schema 1. Code generation of Queries similar to sqlc . Check out [the documentation][docs] for more information. Support Queries Models ORM Gen Factory Gen Query Gen ------------- ------- ------ ------- ----------- --------- Postgres ✅ ✅ ✅ ✅ ✅ MySQL/MariaDB ✅ ✅ ✅ ✅ ✅ SQLite ✅ ✅ ✅ ✅ ✅ Comparisons 1. Bob vs GORM 1. Bob vs Ent 1. Bob vs SQLBoiler 1. Bob vs Jet [docs]: https://bob.stephenafamo.com/docs [reference]: https://pkg.go.dev/github.com/stephenafamo/bob The layers of Bob Layer 1: The query builder - Similar to squirrel Th","default_branch":null,"files":null,"tree":[],"storefront":"/r/stephenafamo","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/stephenafamo/bob/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}