Realtime
Infrastructure
realtime database middleware
SHOW HN2020
How HN took it
3 positive, 3 neutral or asking, 0 mixed, 4 critical, out of 10 comments about the project. Thread score +0.03.
Privacy: 1 for, 2 againstIdea: 2 for, 0 againstExecution: 0 for, 2 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Good idea with real utility, Postgres as realtime backend
From 2 comments
This is a great idea, lovely to see something with so much potential utility being turned into a functional product.
1_over_n on HNI know I’m late to the party, but I’ve recently come around to the idea of using apps that sit in front of Postgres to provide an API for free. This seems like an amazing…
shadowsun7 on HN
Objections
Exposing the database connection string or public database is a security risk
From 2 comments
> For the BYO - all we need is the database connection string. Then this means that the database should be publicly accessible. Many would not accept this from a security…
ahachete on HNGreat. May you ellaborate on the BYO concept? How do you bring it? Or you will just ask Postgres owners to install an agent which will then connect from customers' premises to…
ahachete on HN
Managed Postgres providers may not expose WAL or logical decoding
From 1 comment
As far as I am aware none of popular managed PostgreSQL providers provide access to WAL
sheerun on HN
Requests
Application-level access control per user, like Firebase security rules
From 3 comments
Ah, okay! My question more on the lines of application level access control. As in how to ensure one user can only modify certain data in a table? For example assuming a social…
jatins on HNYea, I'd be really interested in this. Part of using Firebase Realtime DB was that you can use Firebase Auth with it for access control and set rules on the database based on it.
mildmustard on HNInteresting project! One question: Does this have any access control built in? Otherwise, anyone could change anything in database from browser.
jatins on HN
Filtering on subscriptions for specific queries
From 1 comment
I got around the 8000 byte limit by sending multiple notifications in this NPM package: https://github.com/numtel/pg-live-select/blob/master/lib/trigger.tpl.sql#L42 Reading the…
numtel on HN
Questions
How does the hosted service connect to a user's database (BYO connection)?
From 2 comments
Just a quick precision, if I'm not mistaken: this project is not decoding the (version, architecture dependent) WAL stream as it seems to be implied by…
ahachete on HNGreat. May you ellaborate on the BYO concept? How do you bring it? Or you will just ask Postgres owners to install an agent which will then connect from customers' premises to…
ahachete on HN
Alternatives named
PostgREST
From 2 comments
I know I’m late to the party, but I’ve recently come around to the idea of using apps that sit in front of Postgres to provide an API for free. This seems like an amazing…
shadowsun7 on HNI really love PostgREST. This was my early approach to realtime, using PostgREST for CRUD operations: https://paul.copplest.one/blog/nimbus-tech-2019-04.html#tech-stack Not much…
kiwicopple on HN
Firebase Firestore / Realtime Database
From 2 comments
Hey HN, this is an Elixir server (Phoenix) that allows you to listen to changes in your database via websockets. Basically the Phoenix server 1. listens to PostgreSQL's native…
kiwicopple on HNYea, I'd be really interested in this. Part of using Firebase Realtime DB was that you can use Firebase Auth with it for access control and set rules on the database based on it.
mildmustard on HN
pg-live-select
From 1 comment
I got around the 8000 byte limit by sending multiple notifications in this NPM package: https://github.com/numtel/pg-live-select/blob/master/lib/trigger.tpl.sql#L42 Reading the…
numtel on HN