pg_ivm
contour
pg_ivm | contour | |
---|---|---|
19 | 5 | |
774 | 3,640 | |
9.9% | 1.0% | |
6.3 | 9.7 | |
about 1 month ago | 1 day ago | |
C | Go | |
GNU General Public License v3.0 or later | 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.
pg_ivm
- Postgres is eating the database world
-
What Is Incremental View Maintenance (IVM)?
FTA, because I don't like Jeopardy questions in headlines:
“Incremental View Maintenance (IVM) provides a method for keeping materialized views current by calculating and applying only the incremental changes, as opposed to the complete recomputation of contents performed by the REFRESH MATERIALIZED VIEW command.”
Article shows using the pg_ivm Postgres extension available here: https://github.com/sraoss/pg_ivm
- Pg_ivm: Incremental View Maintenance as a Postgres Extension
- Anyone have experience with incremental materialized views in postgres?
- Incremental View Maintenance for PostgreSQL
-
a temporary-ish table vs materialize view?
There is an extension that provides some limited incremental MVIEW refresh: https://github.com/sraoss/pg_ivm
- Features I'd Like in PostgreSQL
- IVM (Incremental View Maintenance) Implementation as a PostgreSQL Extension
-
Materialized View: SQL Queries on Steroids
There’s awesome work being done on incremental view maintenance in postgres:
https://github.com/sraoss/pg_ivm
-
Should I replace all db select query REST APIs with a single generic router ?
It makes sense to perform managed denormalization - use a materialized view or automatically refresh a table or foreign server (via FDW) using common triggers (like pg_ivm does). And it's fine to add a TTL to it and use as a read store... update on user login and make a partial index just for that. And that's how you could get CQRS...
contour
-
Istio moved to CNCF Graduation stage
have you tried Contour yet?
https://projectcontour.io
-
How to prevent import cycle error in this scenario
E.G. Dave Cheneys Contour https://github.com/projectcontour/contour
-
libvirt-k8s-provisioner - Ansible and terraform to build a cluster from scratch in less than 10 minutes ok KVM - Updated for 1.26
nginx-ingress-controller, haproxy-ingress-controller or contour-ingress-controller for ingress management.
-
Should I replace all db select query REST APIs with a single generic router ?
Practically, it makes more sense to adopt GRPC services and publish them using REST/GraphQL bridges/gateways, respective API Gateways (I prefer Contour). Those have some AAA requirements and limitations on their own, and shape the design for everything else, including observability and service delivery (i.e. blue green vs canary).
- Thoughts about my Waitgroup alternative?
What are some alternatives?
prawn-stack - A pageview counter using the AWS free tier, Postgres, Node and React
iTerm2 - iTerm2 is a terminal emulator for Mac OS X that does amazing things.
materialize - The data warehouse for operational workloads.
kitty - Cross-platform, fast, feature-rich, GPU based terminal
pg_hint_plan - Extension adding support for optimizer hints in PostgreSQL
libsixel - A SIXEL encoder/decoder implementation derived from kmiya's sixel (https://github.com/saitoha/sixel).
pg_jsonschema - PostgreSQL extension providing JSON Schema validation
harfbuzz - HarfBuzz text shaping engine
OpenLogReplicator - Open Source Oracle database CDC
yaft - yet another framebuffer terminal
risingwave - Cloud-native SQL stream processing, analytics, and management. KsqlDB and Apache Flink alternative. 🚀 10x more productive. 🚀 10x more cost-efficient.
darktile - :waning_crescent_moon: Darktile is a GPU rendered terminal emulator designed for tiling window managers.