postgres-websockets

PostgreSQL + Websockets (by diogob)
Add to my DEV experience Web
Source Code
hackage.haskell.org
Suggest alternative
Edit details
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
Sponsored

Postgres-websockets Alternatives

Similar projects and alternatives to postgres-websockets

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better postgres-websockets alternative or higher similarity.
Suggest an alternative to postgres-websockets

postgres-websockets reviews and mentions

Posts with mentions or reviews of postgres-websockets. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-29.
  • PostgREST – Serve a RESTful API from Any Postgres Database
    22 projects | news.ycombinator.com | 29 Dec 2022
    At work, we've finally replaced a large part of a custom (mostly-)web backend with PostgREST recently, and that's quite a relief: considerably less code to maintain in that project now, and that was a rather awkward code. Something akin to PostgREST's "Embedding with Top-level Filtering" [1] had to be provided for all the tables, with OpenAPI schema and a typed API (Haskell + Servant); I avoided manually writing it all down, but at the cost of poking framework internals, and maintainability suffered. It was particularly annoying that the code doesn't really do anything useful, except for standing between a database and an HTTP client, and simply mimics the database anyway. Whenever a change had to be introduced, it was introduced into the database, the backend, and the frontend simultaneously, so it wasn't even useful for some kind of compatibility.

    Now PostgREST handles all that, and only a few less trivial endpoints are handled by a custom backend (including streaming, which I'm considering replacing with postgrest-websocket [2] at some point).

    During the switch to PostgREST, the encountered minor issues were those with inherited tables (had to set a bunch of computed/virtual columns [3] in order to "embed" those), and with a bug on filtering using such relations (turned out it was an already-fixed regression [4], so an update helped). Also a couple of helper stored procedures (to use via /rpc/) for updates in multiple tables at once (many-to-many relationships, to edit entities along with their relationships, using fewer requests) were added (though the old custom backend didn't have that), the security policies were set from the beginning, the frontend was rewritten (which allowed to finally switch without adding more work), so it was only left to cleanup the backend.

    Not using views, since as mentioned above, database changes usually correspond to frontend changes, and the API doesn't have to be that stable yet.

    Happy with it so far.

    [1] https://postgrest.org/en/stable/api.html#embedding-with-top-...

    [2] https://github.com/diogob/postgres-websockets

    [3] https://postgrest.org/en/stable/api.html#computed-virtual-co...

    [4] https://github.com/PostgREST/postgrest/issues/2530

Stats

Basic postgres-websockets repo stats
1
338
7.2
5 months ago

diogob/postgres-websockets is an open source project licensed under BSD 3-clause "New" or "Revised" License which is an OSI approved license.

The primary programming language of postgres-websockets is Haskell.

Popular Comparisons

  1. postgres-websockets VS postgrest
  2. postgres-websockets VS graphql-api
  3. postgres-websockets VS graphql
  4. postgres-websockets VS gc-monitoring-wai
  5. postgres-websockets VS simpleconfig
  6. postgres-websockets VS raml
  7. postgres-websockets VS scotty
  8. postgres-websockets VS duplo
  9. postgres-websockets VS android-lint-summary
  10. postgres-websockets VS yaml

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com