SQLGateway
jet
| SQLGateway | jet | |
|---|---|---|
| 6 | 26 | |
| 52 | 2,067 | |
| - | - | |
| 10.0 | 8.1 | |
| about 1 year ago | 25 days ago | |
| Go | Go | |
| - | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
SQLGateway
-
Connect()- a new API for creating TCP sockets from Cloudflare Workers
Super excited for this! I had made https://github.com/danthegoodman1/SQLGateway as a result of not having this capability.
One issue I see is the cost of constantly opening and closing a TCP connection for something like the postgres example. Postgres specifically has quite a high cost for each connection. Pgbouncer helps, but this could still be pretty consequential at the concurrency that workers can offer.
Maybe in the future we could create local pools that can be shared across executions, similar to how AWS Lambda does it now?
- SQLGateway – Access SQL Databases over HTTP
- SQLGateway Early Access - Access SQL databases over HTTP for Workers ⛅️
- SQLGateway - Access SQL databases over HTTP - Written in Go 💙
- SQLGateway Early Access - Access SQL databases over HTTP - Written in Go 💙
jet
-
Open-sourcing SQX, a way to build flexible database models in Go
We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
https://github.com/go-jet/jet
-
The "preferred" way of mapping SQL results in Golang is honestly, subjectively, awful, how to deal with this
Check go-jet https://github.com/go-jet/jet
- Comparing database/sql, GORM, sqlx, and sqlc
-
goscanql - conveniently reading joined SQL data into structs
https://github.com/go-jet/jet does a similar thing.
-
Does Go, has something similar to Laravel eloquent (ORM) ?
Try go-jet, it generates the models based on the schema, provides typed column names.
-
Any mid sized / big open source code base in golang that makes use of SQL DBs?
I have tried doing that, but was unable to get it to work. I posted about it in a discussion here: https://github.com/go-jet/jet/discussions/215
-
Automatic CRUD code generetor?
Jet might be what you're looking for - https://github.com/go-jet/jet
- How to Work with SQL Databases in Go
-
ORM or no ORM (and which ones)?
Use sql builder https://github.com/go-jet/jet.
- GitHub - go-jet/jet: Type safe SQL builder with code generation and automatic query result data mapping
What are some alternatives?
dtm - 此仓库应常青藤爸爸要求，已停止维护，请移步 https://github.com/dtm-labs/dtf
sqlc - Generate type-safe code from SQL
Olric - Distributed in-memory object store. It can be used as an embedded Go library and a language-independent service.
goqu - SQL builder and query library for golang
gnomock - Test your code without writing mocks with ephemeral Docker containers 📦 Setup popular services with just a couple lines of code ⏱️ No bash, no yaml, only code 💻
SQLBoiler - Generate a Go ORM tailored to your database schema.
migrate - Database migrations. CLI and Golang library.
pgcapture - A scalable Netflix DBLog implementation for PostgreSQL
go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.
GORM - The fantastic ORM library for Golang, aims to be developer friendly
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
xo - Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server