prawn-stack
app-engine-cloud-run-
| prawn-stack | app-engine-cloud-run- | |
|---|---|---|
| 4 | 1 | |
| 6 | - | |
| - | - | |
| 4.5 | - | |
| 5 months ago | - | |
| TypeScript | ||
| - | - |
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
app-engine-cloud-run-
-
The Architecture of a One-Man SaaS
If you haven't checked out App Engine in a while, you really should. Especially check out the App Engine "Flexible" editions, which make it really easy to run on App Engine withOUT getting locked in.
I run a NodeJS GraphQL server in App Engine Flexible, and it is basically just like running it in a Docker container. It's also pretty trivial to run in Google Cloud Run if I so desired, there is even a tool to assist: https://github.com/GoogleCloudPlatform/app-engine-cloud-run-...
What are some alternatives?
pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
LetsShip - Let's learn devops by shipping a final product in .NET 5
node-pg-migrate - Node.js database migration management for PostgreSQL
realworld - "The mother of all demo apps" — Exemplary fullstack Medium.com clone powered by React, Angular, Node, Django, and many more
litestream - Streaming replication for SQLite.
diagrams - :art: Diagram as Code for prototyping cloud system architectures
migrate-from-app-engine-to-cloud-run - Helper library and webpage to migrate from App Engine to Cloud Run
graphjin - GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks
migrate - Database migrations. CLI and Golang library.