gsvclass

6 ms·

1.
by gsvclass 4y ago
In GraphJin an automatic GraphQL to SQL compiler we use the gnomock library it startups a database instance (docker) then create the schema and tests data and finally our code connects to it and runs a series of tests. We run these across M
2.
by gsvclass 4y ago
This is more common that you would believe other issues i've seen are no `limit` on the query, fetching all the results and then sorting in your own app code, using wrong joins. Many of these happen while using ORMs as well. SQL is a c
3.
Show HN: Create REST APIs with just a simple GraphQL query.(github.com)
5 points by gsvclass 4y ago|0 comments
4.
by gsvclass 4y ago
It depends on how you use it. With GraphJin you use GraphQL to define your API and GraphJin auto compiles it into SQL and instantly gives you a REST and a GraphQL API endpoint to use it with. https://github.com/dosco/gr
5.
ReFi Movement: Helping People and the Planet(cryptogood.substack.com)
1 points by gsvclass 4y ago|0 comments
6.
by gsvclass 4y ago
It's has support for cursor_pagination for years now. You can even have multiple cursors per query.
7.
by gsvclass 4y ago
GraphQL takes security pretty seriously the way we think of GraphQL as a DSL for bulding APIs. The queries you issue in DEV are saved to an allow list and only those queries are compiled in production. Any other queries (or changes to exist
8.
by gsvclass 4y ago
GraphJin can be used within your own http handlers (REST) sort of like an ORM. Or you can use the @script directive to add a JS script to handle the before and after of the request. Here's an example of a relatively complex query that
9.
by gsvclass 4y ago
Author of GraphJin here, thanks for all the comments on here. It's a labour of love for me over several years. Today it's so useful to me and other that I'm probably going to work on it forever. GraphJin is used as the backen
10.
by gsvclass 4y ago
+1 to that additionally there is nothing like subscriptions, defer, async on the REST side of things. These are really great capabilities to have towards building snappy data rich apps.
11.
by gsvclass 4y ago
Author of GraphJin here, I agree Hasura is pretty great as well.
12.
by gsvclass 4y ago
I won't comment on GraphQL itself. But GraphJin builds an internal graph of your db relationships, etc and uses that to write a single efficient query. Even if you have a deeply nested query, insert or update it will only result in a s
13.
by gsvclass 4y ago
Also Cockroach just need to get it officially in.
14.
by gsvclass 4y ago
You can do this with GraphJin. We support adding custom resolvers currently we have an HTTP resolver built in which allows you to join your DB GraphQL query with a remote HTTP Rest endpoint. For example you want users from your db and their
15.
by gsvclass 4y ago
Happy you're sharing this on here, glad to have more options on the table. However I will say GraphJin is not complex to use nor does it have any boilerplate. It's feature rich and hence has knobs to help you tune it to your needs
16.
by gsvclass 4y ago
GraphJin DOES NOT hook GraphQL straight to a DB. It is a backend service which in DEV mode saves queries to an allow list and in production on queries from this list are allowed to be run. GraphQL does not mean clients are allowed to change
17.
by gsvclass 4y ago
Also GraphJin is the only one built in Go and therefore can be used as a library within your own Go app allowing you to use it while also adding any business logic you might need.
18.
by gsvclass 4y ago
GraphJin does auto db discovery and hence builds a relationship graph which it then uses to write out a single efficient sql query for any Graphql query or mutation even nested ones. As GraphJin improves and uses new capabilities of newer v
19.
by gsvclass 4y ago
I think folks have a hard time understanding the value until they use it themselves/
20.
by gsvclass 4y ago
No real issues have been closed cursor pagination has been working for years. This issue clear says "frederikhors closed this as completed on Mar 3, 2020" as in closed by the person who opened it.
21.
by gsvclass 4y ago
Cursor pagination works fine just ask for a cursor with any query and you can then pass that back with the next query to paginate. We don't support Relay atall.
22.
by gsvclass 4y ago
Also checkout GraphJin an automatic GraphQL to SQL service in Go. It's packed with features including support for GraphQL subscriptions, etc and can be used as a standalone service or a library. Also it's a pure OSS project not a
23.
by gsvclass 4y ago
At https://42papers.com/ we want to get more folks reading papers our focus in on surfacing papers from arXiv that our community would appreciate so we focus on trending papers, improving readability, etc
24.
by gsvclass 5y ago
https://42papers.com
25.
Secure Key Management in GraphJin the Instant GraphQL to SQL Service(old.reddit.com)
1 points by gsvclass 5y ago|0 comments
26.
by gsvclass 5y ago
If you're into GO then there is GraphJin which can be used a standalone service or a library. Works with Postgres, MySQL and MSSQL soon. https://github.com/dosco/graphjin
27.
by gsvclass 5y ago
And a search engine in Posgres instead of Elastic Search https://twitter.com/dosco/status/1400643969030127620
28.
by gsvclass 5y ago
And others like this thread on building a MongoDB like JSON database in Postgres in one line. https://twitter.com/dosco/status/1401413712842346501
29.
by gsvclass 5y ago
I just did a thread on the topic myself https://twitter.com/dosco/status/1402909104012623873
30.
GiveTrack: A Bitcoin Crowdfunding Platform for Nonprofits(cryptogood.substack.com)
1 points by gsvclass 5y ago|0 comments

More ›