prawn-stack
graphjin
prawn-stack | graphjin | |
---|---|---|
4 | 61 | |
6 | 2,836 | |
- | - | |
4.5 | 5.5 | |
5 months ago | 8 days ago | |
TypeScript | Go | |
- | 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.
prawn-stack
-
PostgreSQL Views and Materialized Views and How They Influenced TimescaleDB
I wanted incremental refresh in Postgres as well and found that you can manage your own table to get something close.
Basically you create a regular table in place of a materialised one, only aggregate data newer than what's currently in the table then store the new aggregates in table. Repeat this an interval.
https://github.com/cadbox1/prawn-stack/blob/master/src/backe...
I use this to show page view data aggregated by hour without calculating it on each request using Lambda
https://prawn.cadell.dev/
- A modern page view counter to see unpopular my project is. Powered by a PRAwN stack (Postgres, React, AWS and Node) in the free tier deployed using CDK.
- Show HN: A modern page view counter to see how unpopular my project is
-
The Architecture of a One-Man SaaS
I don't have the startup part yet but here's my one-person stack with Postgres, Node and React deployed on AWS with CDK using RDS, Lambda, S3 and Cloudfront. It's 100% in the free tier.
https://github.com/cadbox1/prawn-stack
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?
pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
node-pg-migrate - Node.js database migration management for Postgresql
graphql-go - GraphQL server with a focus on ease of use
litestream - Streaming replication for SQLite.
gqlgen - go generate based graphql server library
LetsShip - Let's learn devops by shipping a final product in .NET 5
asciinema - Platform for hosting and sharing terminal session recordings
diagrams - :art: Diagram as Code for prototyping cloud system architectures
graphql-benchmarks - GraphQL benchmarks using the-benchmarker framework.
kubernetes-the-hard-way - Bootstrap Kubernetes the hard way. No scripts.