https://github.com/go-jet/jet
cockroachdb code-completion code-generator codegenerator database datamapper golang mariadb mysql postgres postgresql sql sql-builder sql-queries sql-query sql-query-builder sqlbuilder sqlite typesafe typesafety
Score: 16.755158076394586
Last synced: about 16 hours ago
JSON representation
Repository metadata:
Type safe SQL builder with code generation and automatic query result data mapping
- Host: GitHub
- URL: https://github.com/go-jet/jet
- Owner: go-jet
- License: apache-2.0
- Created: 2019-03-02T11:06:23.000Z (almost 7 years ago)
- Default Branch: master
- Last Pushed: 2026-01-29T21:03:07.000Z (5 days ago)
- Last Synced: 2026-01-31T00:02:52.836Z (4 days ago)
- Topics: cockroachdb, code-completion, code-generator, codegenerator, database, datamapper, golang, mariadb, mysql, postgres, postgresql, sql, sql-builder, sql-queries, sql-query, sql-query-builder, sqlbuilder, sqlite, typesafe, typesafety
- Language: Go
- Homepage:
- Size: 7.03 MB
- Stars: 3,558
- Watchers: 23
- Forks: 174
- Open Issues: 52
-
Metadata Files:
- Readme: README.md
- Funding: .github/FUNDING.yml
- License: LICENSE
- Notice: NOTICE
-
Funding:
- Ko fi: gojetdev
- Custom: mempool.space/address/bc1qtjhxe8mqx0yzff2l0f6stjpjj92kgwr0a53wxv, etherscan.io/address/0xe98e4535C744c617e8E45828B63fDFf9367E3574
Owner metadata:
- Name:
- Login: go-jet
- Email:
- Kind: user
- Description:
- Website:
- Location:
- Twitter:
- Company:
- Icon url: https://avatars.githubusercontent.com/u/47941548?v=4
- Repositories: 2
- Last Synced at: 2023-03-06T12:49:50.933Z
- Profile URL: https://github.com/go-jet
GitHub Events
Total
- Create event: 33
- Delete event: 18
- Discussion event: 1
- Fork event: 46
- Gollum event: 55
- Issue comment event: 322
- Issues event: 94
- Pull request event: 92
- Pull request review comment event: 70
- Pull request review event: 69
- Push event: 95
- Release event: 3
- Watch event: 803
- Total: 1701
Last Year
- Create event: 25
- Delete event: 13
- Discussion event: 1
- Fork event: 32
- Gollum event: 22
- Issue comment event: 183
- Issues event: 56
- Pull request event: 63
- Pull request review comment event: 51
- Pull request review event: 50
- Push event: 73
- Release event: 2
- Watch event: 510
- Total: 1081
Committers metadata
Last synced: about 20 hours ago
Total Commits: 712
Total Committers: 54
Avg Commits per committer: 13.185
Development Distribution Score (DDS): 0.24
Commits in past year: 90
Committers in past year: 15
Avg Commits per committer in past year: 6.0
Development Distribution Score (DDS) in past year: 0.433
| Name | Commits | |
|---|---|---|
| go-jet | z****b@p****m | 541 |
| dependabot[bot] | 4****] | 25 |
| Samir Faci | s****r@e****t | 13 |
| Jay | m****e@b****z | 12 |
| Jamius Siam | j****@s****m | 9 |
| Yosyp Buchma | j****a@g****m | 8 |
| Carson Krueger | c****e@g****m | 6 |
| Volker Lieber | 4****r | 6 |
| Cedric L'homme | p****c@l****m | 5 |
| SanjaiyKumar | s****i@g****m | 5 |
| David Racine | r****7@g****m | 4 |
| Josh Kaplinsky | 3****y | 4 |
| Marco Ronchese | 8****j | 4 |
| Karl Blomster | k****r@y****m | 3 |
| Mike Nelson | m****e@r****m | 3 |
| SanjaiyKumar | s****n@r****m | 3 |
| formica2 | s****1@b****u | 3 |
| k4n4ry | y****y@g****m | 3 |
| mlaflamm | m****e@g****m | 3 |
| Joonas Haapsaari | j****i@g****m | 3 |
| Branislav Lazic | b****1@h****m | 3 |
| Mathieu Kooiman | m****n@m****m | 3 |
| charlie | c****e@p****e | 2 |
| Nikita Konin | n****n@o****u | 2 |
| Andrei-hub11 | a****4@g****m | 2 |
| DevDevious | D****s | 2 |
| Mukundan Kidambi | m****i@g****m | 2 |
| S T E P H E N | 4****x | 2 |
| vetcher | v****r@n****u | 2 |
| fourdim | f****m@f****m | 2 |
| and 24 more... | ||
Issue and Pull Request metadata
Last synced: 6 days ago
Total issues: 186
Total pull requests: 207
Average time to close issues: 3 months
Average time to close pull requests: about 1 month
Total issue authors: 140
Total pull request authors: 49
Average comments per issue: 3.25
Average comments per pull request: 1.98
Merged pull request: 125
Bot issues: 0
Bot pull requests: 89
Past year issues: 32
Past year pull requests: 62
Past year average time to close issues: 13 days
Past year average time to close pull requests: 10 days
Past year issue authors: 28
Past year pull request authors: 18
Past year average comments per issue: 1.56
Past year average comments per pull request: 1.68
Past year merged pull request: 40
Past year bot issues: 0
Past year bot pull requests: 21
Top Issue Authors
- kblomster (7)
- CmpHDL (7)
- safaci2000 (7)
- yofriadi (4)
- masterkidan (3)
- veqryn (3)
- aunjaffery (3)
- go-jet (3)
- cgruber (2)
- mickeyreiss (2)
- wexder (2)
- canuran (2)
- galexrt (2)
- yz89122 (2)
- developer2346 (2)
Top Pull Request Authors
- dependabot[bot] (89)
- go-jet (25)
- safaci2000 (10)
- jamius19 (4)
- jupp0r (3)
- realbucksavage (3)
- BranislavLazic (3)
- sirmackan (3)
- josephbuchma (3)
- Sanjaiy (3)
- kblomster (3)
- houten11 (2)
- mispp (2)
- mathieuk (2)
- BillBuilt (2)
Top Issue Labels
- missing feature (89)
- bug (67)
- good first issue (10)
- enhancement (4)
- question (1)
Top Pull Request Labels
- dependencies (89)
- go (17)
Package metadata
- Total packages: 8
-
Total downloads:
- homebrew: 39 last-month
- Total dependent packages: 41 (may contain duplicates)
- Total dependent repositories: 17 (may contain duplicates)
- Total versions: 41
proxy.golang.org: github.com/go-jet/jet/v2
Package jet is a complete solution for efficient and high performance database access, consisting of type-safe SQL builder with code generation and automatic query result data mapping. Jet currently supports PostgreSQL, MySQL, MariaDB and SQLite. Future releases will add support for additional databases. Use the command bellow to add jet as a dependency into go.mod project: Jet generator can be installed in one of the following ways: (Go1.16+) Install jet generator using go install: go install github.com/go-jet/jet/v2/cmd/jet@latest Install jet generator to GOPATH/bin folder: cd $GOPATH/src/ && GO111MODULE=off go get -u github.com/go-jet/jet/cmd/jet Install jet generator into specific folder: git clone https://github.com/go-jet/jet.git cd jet && go build -o dir_path ./cmd/jet Make sure that the destination folder is added to the PATH environment variable. Jet requires already defined database schema(with tables, enums etc), so that jet generator can generate SQL Builder and Model files. File generation is very fast, and can be added as every pre-build step. Sample command: Before we can write SQL queries in Go, we need to import generated SQL builder and model types: To write postgres SQL queries we import: Then we can write the SQL query: Now we can run the statement and store the result into desired destination: We can print a statement to see SQL query and arguments sent to postgres server: Output: If we print destination as json, we'll get: Detail info about all statements, features and use cases can be found at project wiki page - https://github.com/go-jet/jet/wiki.
- Homepage: https://github.com/go-jet/jet
- Documentation: https://pkg.go.dev/github.com/go-jet/jet/v2#section-documentation
- Licenses: Apache-2.0, BSD-3-Clause, MIT
- Latest release: v2.14.1 (published 13 days ago)
- Last Synced: 2026-02-02T13:34:05.523Z (1 day ago)
- Versions: 21
- Dependent Packages: 37
- Dependent Repositories: 13
-
Rankings:
- Dependent packages count: 1.276%
- Dependent repos count: 1.51%
- Average: 1.925%
- Stargazers count: 1.952%
- Forks count: 2.961%
proxy.golang.org: github.com/go-jet/jet
Package jet is a framework for writing type-safe SQL queries in Go, with ability to easily convert database query result into desired arbitrary object structure. Use the bellow command to install jet Install jet generator to GOPATH bin folder. This will allow generating jet files from the command line. *Make sure GOPATH bin folder is added to the PATH environment variable. Jet requires already defined database schema(with tables, enums etc), so that jet generator can generate SQL Builder and Model files. File generation is very fast, and can be added as every pre-build step. Sample command: Then next step is to import generated SQL Builder and Model files and write SQL queries in Go: To write SQL queries for PostgreSQL import: To write SQL queries for MySQL and MariaDB import: *Dot import is used so that Go code resemble as much as native SQL. Dot import is not mandatory. Write SQL: Store result into desired destination: Detail info about all features and use cases can be found at project wiki page - https://github.com/go-jet/jet/wiki.
- Homepage: https://github.com/go-jet/jet
- Documentation: https://pkg.go.dev/github.com/go-jet/jet#section-documentation
- Licenses: Apache-2.0, BSD-3-Clause, MIT
- Latest release: v2.3.0+incompatible (published over 5 years ago)
- Last Synced: 2026-01-27T04:40:43.368Z (8 days ago)
- Versions: 7
- Dependent Packages: 4
- Dependent Repositories: 3
-
Rankings:
- Stargazers count: 1.964%
- Average: 2.669%
- Dependent packages count: 2.839%
- Dependent repos count: 2.905%
- Forks count: 2.967%
formulae.brew.sh: jet
Type safe SQL builder with code generation and auto query result data mapping
- Homepage: https://github.com/go-jet/jet
- Licenses: Apache-2.0
- Latest release: 2.14.1 (published 8 days ago)
- Last Synced: 2026-01-27T04:44:19.016Z (8 days ago)
- Versions: 8
- Dependent Packages: 0
- Dependent Repositories: 1
- Downloads: 39 Last month
-
Rankings:
- Stargazers count: 14.705%
- Dependent packages count: 19.416%
- Forks count: 20.188%
- Dependent repos count: 29.525%
- Average: 30.436%
- Downloads: 68.347%
nixpkgs-23.11: go-jet
Type safe SQL builder with code generation and automatic query result data mapping
- Homepage: https://github.com/go-jet/jet
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/tools/go-jet/default.nix#L48
- Licenses: Apache-2.0
- Latest release: 2.10.1 (published 2 days ago)
- Last Synced: 2026-02-02T04:04:44.394Z (2 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
nixpkgs-23.05: go-jet
Type safe SQL builder with code generation and automatic query result data mapping
- Homepage: https://github.com/go-jet/jet
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/tools/go-jet/default.nix#L48
- Licenses: Apache-2.0
- Latest release: 2.10.0 (published 9 days ago)
- Last Synced: 2026-01-26T03:40:15.264Z (9 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
nixpkgs-unstable: go-jet
Type safe SQL builder with code generation and automatic query result data mapping
- Homepage: https://github.com/go-jet/jet
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/by-name/go/go-jet/package.nix#L52
- Licenses: Apache-2.0
- Latest release: 2.14.1 (published 9 days ago)
- Last Synced: 2026-02-02T09:52:19.731Z (2 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
nixpkgs-24.11: go-jet
Type safe SQL builder with code generation and automatic query result data mapping
- Homepage: https://github.com/go-jet/jet
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/by-name/go/go-jet/package.nix#L52
- Licenses: Apache-2.0
- Latest release: 2.12.0 (published 3 days ago)
- Last Synced: 2026-02-01T15:12:38.964Z (3 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
nixpkgs-24.05: go-jet
Type safe SQL builder with code generation and automatic query result data mapping
- Homepage: https://github.com/go-jet/jet
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/tools/go-jet/default.nix#L52
- Licenses: Apache-2.0
- Latest release: 2.11.1 (published 2 days ago)
- Last Synced: 2026-02-01T21:56:13.331Z (2 days ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
Dependencies
- actions/checkout v3 composite
- github/codeql-action/analyze v2 composite
- github/codeql-action/autobuild v2 composite
- github/codeql-action/init v2 composite
- github.com/go-sql-driver/mysql v1.7.0
- github.com/google/go-cmp v0.5.9
- github.com/google/uuid v1.3.0
- github.com/jackc/pgconn v1.13.0
- github.com/jackc/pgx/v4 v4.17.2
- github.com/lib/pq v1.10.7
- github.com/mattn/go-sqlite3 v1.14.16
- github.com/pkg/profile v1.7.0
- github.com/shopspring/decimal v1.3.1
- github.com/stretchr/testify v1.8.1
- github.com/volatiletech/null/v8 v8.1.2
- gopkg.in/guregu/null.v4 v4.0.0
- 186 dependencies