SaaSHub helps you find the best software and product alternatives Learn more →
Pg_ivm Alternatives
Similar projects and alternatives to pg_ivm
-
-
materialize
The data warehouse for operational workloads. (by MaterializeInc)
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
dbt-core
dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
-
postgres-operator
Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
-
risingwave
Scalable Postgres for stream processing, analytics, and management. KsqlDB and Apache Flink alternative. 🚀 10x more productive. 🚀 10x more cost-efficient.
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
orioledb
OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
-
readyset
Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
-
-
-
prawn-stack
A pageview counter using the AWS free tier, Postgres, Node and React
-
-
-
rum
RUM access method - inverted index with additional information in posting lists (by postgrespro)
-
-
pg_plan_guarantee
Postgres Query Optimizer Extension that guarantees your desired plan will not change
-
ora2pg
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
pg_ivm reviews and mentions
- Postgres is eating the database world
- Features I'd Like in PostgreSQL
-
Materialized View: SQL Queries on Steroids
There’s awesome work being done on incremental view maintenance in postgres:
-
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...
-
PostgreSQL 15 Released!
However, you might be interested in the pg_ivm extension.
- The Next Generation of Materialize
- PostgreSQL Views and Materialized Views and How They Influenced TimescaleDB
-
How we made data aggregation on PostgreSQL better and faster
Interesting. I check back on the wiki page every couple of years to see what progress is being made.
The basic idea seems to be to track the primary keys of the base tables in the incremental view and then use triggers to update those rows when source rows are updated.
The meat of the project is over here for anyone that’s interested - in particular this section about the limitations is pretty interesting (and expected).
https://github.com/sraoss/pg_ivm/#supported-view-definitions...
-
A note from our sponsor - SaaSHub
www.saashub.com | 17 Apr 2024
Stats
sraoss/pg_ivm is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.
The primary programming language of pg_ivm is C.