postgresql-contrib

By twosigma

Postgresql-contrib Alternatives

Similar projects and alternatives to postgresql-contrib

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better postgresql-contrib alternative or higher similarity.

postgresql-contrib reviews and mentions

Posts with mentions or reviews of postgresql-contrib. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-05-25.
  • PostgreSQL 16 Beta 1
    2 projects | news.ycombinator.com | 25 May 2023
    Then in the application I have hand-coded triggers to either update the view's materialization directly or to mark the view as needing a refresh. A background job can asynchronously refresh views as needed.

    I've also spent some time thinking about the AST form of view queries that PG stores and how one might automatically generate triggers on source tables that update the materialization or mark it as needing a refresh.

    As you note, many queries can be very difficult to transform into queries that compute incremental deltas. Moreover, even where it's possible to do that, the time it takes to execute the delta computation might be unacceptably long. For example, if you have a recursively nested grouping schema and you want to maintain a view of the expanded transitive closure of that data, then removing a large from from another might require thousands of row deletions from the materialized view, and that might make the transaction take much too long in a UI -- the obvious thing to do here is to say "sorry, that kind of update takes a while to propagate, but your transaction will complete quickly", so just mark the view as needing a refresh and refresh it asynchronously.

    [0] https://github.com/twosigma/postgresql-contrib/blob/master/m...

    2 projects | news.ycombinator.com | 25 May 2023
    You can use https://github.com/twosigma/postgresql-contrib/blob/master/m... and write triggers to update your views or mark them as needing asynchronous refreshes. It's not as automatic as what you'd like, but it's a lot better than having to keep waiting.
  • The Next Generation of Materialize
    9 projects | news.ycombinator.com | 3 Oct 2022
    I use PG with an alternative materialized views implementation[0] that is pure PlPgSQL and that exposes real tables that can be used to write to in triggers, and where the views can be marked stale too.

    This means hand-coding triggers to keep the materializations up to date, or else to mark them as out of date (because maybe some operations would be slow or hard to hand-code triggers for), but this works remarkably well.

    As a bonus, I get an update history table that can be used to generate updates to external systems.

    In principle one can get the AST for a VIEW's query from the PG catalog and use that generate triggers on the tables it queries to keep it up to date. In practice that's only trivial for some kinds of queries, and I've not written such a tool yet.

    [0] https://github.com/twosigma/postgresql-contrib/blob/master/m...

  • A note from our sponsor - SaaSHub
    www.saashub.com | 28 Mar 2024
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic postgresql-contrib repo stats
3
13
10.0
almost 6 years ago
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com