crystal
Squirrel
crystal | Squirrel | |
---|---|---|
28 | 52 | |
12,420 | 6,540 | |
0.3% | 1.1% | |
9.9 | 2.4 | |
6 days ago | 15 days ago | |
TypeScript | Go | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
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.
crystal
-
Ask HN: What Underrated Open Source Project Deserves More Recognition?
I didn't see a v5 tag in order to know, and I have no idea what "utils/graphile" does for the project, but one will want to ensure they are aware of its licensing scheme https://github.com/graphile/crystal/blob/db8894c74eb0ec3fe96...
- v4.13.0
-
PostgREST – Serve a RESTful API from Any Postgres Database
I was about to say “but this one is!” and realized I had confused PostgREST with PostGraphile. If you’re interested in GraphQL, you can check out PostGraphile here: https://github.com/graphile/postgraphile
-
Best Orm that uses Graphql and Postgres
If you point is to abstract all the CRUD/GraphQL application, Go isn’t needed. You can go with PostgREST or Postgraphile.
- v4.12.12
-
Ask HN: Locally generate GraphQL schema and resolvers from DB
What do you mean locally? Hasura is OSS, and you can run it locally (you have autogenerated SQL statements) Here you can just use Nhost and its CLI;
Alternatives are https://github.com/graphile/postgraphile or dgraph as you mentioned. Hasura is working on support for sqlite, so you may have some blockers there, you can also look into the Prisma engine which has GQL as an intermediate (for resolvers, for example)
- v4.12.11
-
Supabase (YC S20) raises $80M Series B
I've personally found Postgraphile to be fantastic. Nicer to use than Hasura and fully OSS: https://github.com/graphile/postgraphile/
- v4.12.10
-
GraphQL is now available on Supabase
Hi all, this sounds very cool. How does pg_graphql compare to Postgraphile? https://github.com/graphile/postgraphile (besides I guess running in the DB with PLpgSQL instead of as a NodeJS server)
Did you think about integrating Postgraphile with the Supabase ecosystem or have specific limitations with it?
Thanks!
Squirrel
-
Building RESTful API with Hexagonal Architecture in Go
It uses Gin as the HTTP framework and PostgreSQL as the database with pgx as the driver and Squirrel as the query builder. It also utilizes Redis as the caching layer with go-redis as the client.
-
Working with postgres in GO.
I would add Squirrel to PGX https://github.com/Masterminds/squirrel
-
how to avoid writing dreadful SQL statements
I have written about this before, and my thoughts always settle on using a query builder. I've built a simple one, which works for what I need, but there are more feature complete ones out there such as squirrel. I've also written about how you can implement a simple CRUD library for database interactions using generics and query building to have that nice middle-ground between an ORM and query building.
-
How do I enable filters for the user without writing redundant SQL?
Now for the dynamic queries you have to be really careful to prevent SQL injections, there are bunch of different ways to do it but I typically recommend using a package such as squirrel that lets you do this easily, you use it to generate the plain SQL you need (and then use sqlx, database/sql, pgx or whatever you prefer) or use it directly querying the database directly.
-
Best sqlc alternative for dynamic queries?
Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel
-
Golang RESTAPI boilerplate repository
https://www.reddit.com/r/golang/comments/vq98ud/what_sql_library_are_you_using/ Jet havn't used but is one that looks promising! Otherwise I'm one of the purests, db/sql and https://github.com/Masterminds/squirrel
-
Why is Raw SQL preferred over ORM in go?
I think he means an sql builder like squirrel. This allows dynamic queries, but more important you can reuse function that build a where clause so you can get a count and query with that.
-
Does Go, has something similar to Laravel eloquent (ORM) ?
I'd rather suggest the use of tools more aligned with the core concepts of the language such as sqlx, which is an extension of the database/sql standard library. It allows you to use models/structs to map your tables but you have more control over the SQL statements you use to perform queries and the like. You can combine sqlx with Squirrel to build queries from composable parts.
-
Are there any decent ORMs in Golang?
But using a query builder, something like squirrel or (plug) bqb, allows you to actually write SQL (or something close to it) when you need it but also handles the nasty string building bits. Though I agree that ORMs are not always bad, especially for small projects with well-defined scope.
-
GORM
Plug for bqb as a query builder, but there's also squirrel which works pretty well too.
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
goqu - SQL builder and query library for golang
pg_graphql - GraphQL support for PostgreSQL
sqlx - general purpose extensions to golang's database/sql
starter - Opinionated SaaS quick-start with pre-built user account and organization system for full-stack application development in React, Node.js, GraphQL and PostgreSQL. Powered by PostGraphile, TypeScript, Apollo Client, Graphile Worker, Graphile Migrate, GraphQL Code Generator, Ant Design and Next.js
GORM - The fantastic ORM library for Golang, aims to be developer friendly
supabase - The open source Firebase alternative.
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
sqlc - Generate type-safe code from SQL
tensei - 🚀 Content management and distribution with a touch of elegance.
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.