Sqlc Alternatives
Similar projects and alternatives to sqlc
-
-
-
-
-
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)
-
-
-
-
Scout APM
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
-
pggen
Generate type-safe Go for any Postgres query. If Postgres can run the query, pggen can generate code for it.
-
-
-
-
Seaweed File System
SeaweedFS is a fast distributed storage system for blobs, objects, files, and data lake, for billions of files! Blob store has O(1) disk seek, local tiering, cloud tiering. Filer supports Cloud Drive, cross-DC active-active replication, Kubernetes, POSIX FUSE mount, S3 API, Hadoop, WebDAV, encryption, Erasure Coding.
-
-
-
upper.io/db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
-
-
jet
Type safe SQL builder with code generation and automatic query result data mapping (by go-jet)
-
sqlgen
Go tool for generating sql scanners, sql statements and other helper functions
-
-
Reviews and mentions
- Compile SQL to type-safe Go
-
We Went All in on Sqlc/Pgx for Postgres and Go
Can you provide some resources about the lack of support for joins in sqlc? Because I wasn't able to find in official documentation and actually there's a discussion on github containing queries with join statements: https://github.com/kyleconroy/sqlc/issues/213
I stumbled across this library a few months ago and also really liked the approach. Unfortunately I had to drop it temporarily due to this issue (https://github.com/kyleconroy/sqlc/pull/983)... which I now see is solved. Taking another look. :)
I was really really excited when I saw the title because I've been having a lot of difficulties with other Go SQL libraries, but the caveats section gives me pause.
Needing to use arrays for the IN use case (see https://github.com/kyleconroy/sqlc/issues/216) and the bulk insert case feel like large divergences from what "idiomatic SQL" looks like. It means that you have to adjust how you write your queries. And that can be intimidating for new developers.
The conditional insert case also just doesn't look particularly elegant and the SQL query is pretty large.
sqlc also just doesn't look like it could help with very dynamic queries I need to generate - I work on a team that owns a little domain-specific search engine. The conditional approach could in theory with here, but it's not good for the query planner: https://use-the-index-luke.com/sql/where-clause/obfuscation/...
Thanks a lot for this great project. I looked in the issues for Sqlite support and saw the merge of PR to "Add three new experimental engines, including SQLite" [0] and there's major architecture changes involved. That merge was 1.5 yr ago though, and I am curious what the plans are to take that further.
-
Write an SQL query builder in 150 lines of Python
Doing it the other way around make more sense, i.e. write SQL to generate code. See https://github.com/kyleconroy/sqlc, why aren't more people following this approach?
-
Show HN: Typed Postgres CRUD Queries
If you are into Golang, also well worth checking out sqlc. It parses your migrations to generate typed structs and query funcs
- Ask HN: Companies of one, what is your tech stack (2021)?
-
JOOQ library equivalent for Go?
Dev site: https://sqlc.dev/
-
Yes or No on ORMs???
https://sqlc.dev instead
-
Has anybody moved from Django (python) to any of the Go backend frameworks?
You can get the static type benefit of an ORM without the ORM in Go if you use https://sqlc.dev.
- Top Go ORMs
- Fighting boilerplate with code generation
- Code Generation
Stats
kyleconroy/sqlc is an open source project licensed under MIT License which is an OSI approved license.
Popular Comparisons
Are you hiring? Post a new remote job listing for free.