LetsShip
graphjin
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.
LetsShip
-
.NET 6 is now in Ubuntu 22.04
I have two DigitalOcean sites on the same VPS just serving from kestrel behind an nginx reverse proxy and then one site on a Hetzner VPS where I was playing around with k3s.
For digitalocean I followed this post which is probably way out of date now https://www.hanselman.com/blog/publishing-an-aspnet-core-web...
For the k3s site the source is here https://github.com/EliotJones/LetsShip/blob/main/kubernetes/... though worth noting I have set up LetsEncrypt incorrectly but that's my lack of k3s understanding.
-
We need to have a talk about making life easier for newcomers to .NET
This - https://github.com/EliotJones/LetsShip - hopefully gets you some of the way, it uses VS on Windows for development but I can't imagine the experience in Rider or VS Code for Linux is too disimilar. Individual steps here https://github.com/EliotJones/LetsShip/tree/main/docs/posts
I need to complete the full guide at some point but the end result is an application deployed on Linux with both a web app and independently scalable crawling services with zero downtime deployments. Hosted site here: https://pricefalcon.me/
For a simpler deployment without k3s, this guide is the one I originally followed for my trends site and should still work for .NET 6. https://www.hanselman.com/blog/publishing-an-aspnet-core-web...
-
Synchronizing access to a pool of resources
One example here https://github.com/EliotJones/LetsShip/blob/main/src/PriceFalcon.JobRunner/Worker.cs#L111 where I have several agent applications each of which may start up to 5 jobs, a job can take a couple of minutes to execute and while running the same request twice isn't the end of the world I'd prefer to avoid it. I use FOR UPDATE when selecting to take an update lock on the row in postgres (similar functionality hopefully exists for your DB).
-
New Core MVC App with jQuery in 2021?
I just build out a new MVP site for the purposes of a tutorial with .NET 5 and jQuery with some slightly complex front-end requirements (an interactive iFrame that validates user selections server-side on click) and though it may need to move to an SPA if it got more complex for now jQuery is fine (though assuming IE support is not needed I could have probably just used raw JS instead). https://github.com/EliotJones/LetsShip
-
The Architecture of a One-Man SaaS
I've done a complete 180 on this too, I realised I was reacting from my default position of hostility to new concepts rather than an honest appraisal. I am writing it up at the moment but I've been working on a 1 person SAAS MVP tutorial [0] and though I've definitely misconfigured something having the ability to go from git push to deployed to production with 0 downtime inside of 5 minutes with no manual steps is such a nice flow, versus my previous attempts of SCP and faffing around with services.
[0]: https://github.com/EliotJones/LetsShip
graphjin
- [Golang] Super Graph GraphQL au compilateur SQL renommé GraphJin et prend maintenant en charge MySQL
-
Does Go, has something similar to Laravel eloquent (ORM) ?
This one looks interesting if you like GraphQL… https://graphjin.com
-
Looking for library recommendations: Django -> Golang port
You're right. Django made a ton of tables, and it's pretty insightful to think about all the stuff it's trying to consider and a nightmare to migrate that framework. Django might have simplified some stuff, but it's still too opaque for my taste and the overall end goals of the project. Currently, I'm testing using graphjin (it doesn't have the best documentation, but it does boast an SQL generation capability that I philosophically think is the best way to do things).
-
Advice on ORMs with REST/GraphQL & Hasura/PostGraphile implementation
Checkout GraphJin it's an automatic GraphQL to SQL compiler, you write your database queries in GraphQL instead of SQL and it compiles them into efficient SQL on the fly. Works as a library in GO and NodeJS. https://github.com/dosco/graphjin
-
Ask HN: How do you test SQL?
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 Mysql, Postgres and a few other DB's. Gnomock supports a wide range of them. Right now we don't take down the db for every test only between test runs but its fast enough that we could. This whole thing runs of a simple `go test -v .` command and we run it on every commit using a githook. https://github.com/dosco/graphjin/blob/master/tests/dbint_te...
- Should I use GraphQL for a public facing API (in place of a REST API)?
- GraphJin 2.0 - A new kind of ORM for GO
-
Multiple subscriptions fom apollo aclient.
This was a bug in GraphJin it has since been fixed. The issue was that you were trying to have multiple subscriptions over a single websocket this did not work (it should) and now it does. https://github.com/dosco/graphjin/commit/43e619b2ff392dd42b99a4d56074a041a54b0e1c
-
Is graphql-request a good tool for only client side api? Share your feedbacks. Thanks 🙏
Not exactly GraphQL is just a format to define what data you want back from someplace. You can use it in a browser app to request data from a backend GraphQL server or you can use it as an ORM within your backend app to fetch data from a database using a library like GraphJin. https://github.com/dosco/graphjin
- Graphjin.js - An easy-to-use, zero dependency Node.js library to build APIs quickly
What are some alternatives?
prawn-stack - A pageview counter using the AWS free tier, Postgres, Node and React
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
centos-stream
graphql-go - GraphQL server with a focus on ease of use
app-engine-cloud-run-
gqlgen - go generate based graphql server library
diagrams - :art: Diagram as Code for prototyping cloud system architectures
asciinema - Platform for hosting and sharing terminal session recordings
node-pg-migrate - Node.js database migration management for PostgreSQL
graphql-benchmarks - GraphQL benchmarks using the-benchmarker framework.
litestream - Streaming replication for SQLite.