pgcapture
jet
| pgcapture | jet | |
|---|---|---|
| 3 | 28 | |
| 213 | 2,353 | |
| 8.9% | - | |
| 6.7 | 7.8 | |
| 5 days ago | 6 days ago | |
| Go | Go | |
| Apache License 2.0 | 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.
pgcapture
- Pgcapture – CDC Framework for PostgreSQL in Golang
-
Concurrency mutex patterns general question
Use Change Data Capture techniques to synchronize your replicas. This tool may help you if you are using PostgreSQL https://github.com/rueian/pgcapture
- A Scalable Netflix DBLog (A Change Data Capture) Implementation for PostgreSQL
jet
-
Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go
Jet can automatically load joined objects into embedded Go structs: https://github.com/go-jet/jet/wiki/Query-Result-Mapping-(QRM...
Depending on what you are doing there might be some duplication that you could remove by creating hash lookups as in this post, but I would reach for Jet first.
sqlc supports embedding but not embedded slices?
-
Use Rails
"I can make a JS or Go program perform the same way. In fact the exact same thing happened in my shop with Go/Gorm. The key question is: how do you compute the 5mb of JSON? The devil is in those details. We changed the way we computed ours, and the issue was gone."
The problem is ActiveRecord in my case. The data layout is not great (lots of joins through relationships, I thik 12 tables or so). What do you use (except raw sql) in Ruby if you cannot use ActiveRecord? I actually reimplemented the same API endpoint in Go using https://github.com/go-jet/jet and measured 10MB of allocations and essentially zero overhead over queries itself, a 50x speedup.
-
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
What are some alternatives?
transfer - Database replication platform that leverages change data capture. Stream production data from databases to your data warehouse (Snowflake, BigQuery, Redshift) in real-time.
sqlc - Generate type-safe code from SQL
go-deadlock - Online deadlock detection in go (golang)
goqu - SQL builder and query library for golang
pgjobs - Go and PostgreSQL job queue blueprint
SQLBoiler - Generate a Go ORM tailored to your database schema.
imsy - simple incremental pull of immutable large files
migrate - Database migrations. CLI and Golang library.
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