Turn Notion into a UI for Postgres

Posted by vinarun on Monday April 03, 2023 @02:47PM
from the self-post dept.

Saw this product hunt post that helps customer service teams who use Notion view and change customer service data in Postgres, without leaving Notion. Sharing in case it's helpful

https://www.producthunt.com/posts/portal-b96e3e18-f1d7-4c75-bf65-330bf5df4962

( 5 comments | 8 points | on HN )

Re:Turn Notion into a UI for Postgres by MuffinFlavored on Monday April 03, 2023 @03:41PM (#35430088)

What is visual/interactive performance like? I'm guessing (without having used it yet) it's not possible to accidentally try to list 1,000,00 rows in the Notion HTML/JS/CSS UI and crash your browser?

Some questions aloud from my brain while I try to research the answers:

Is the data syncing done with PUB/SUB or some kind of "cron-like" job (so the data can be out of sync for like, up to 5 minutes between database -> notion?)

Is the data pulled fresh from the database anytime the Notion page is loaded? I don't think so.

[ Parent | on HN ]

Re:Turn Notion into a UI for Postgres by vinarun on Tuesday April 04, 2023 @01:32PM (#35443148)

There are limitations by notion on what can be viewed to thousands of records, but you can use a query to pull a filtered view of data in Notion. It's not just a 1:1 mapping but changes in Notion will persist through data in the database that is joined

It's really a way for teams such as customer service who may have their CS ops in Notion to view & change customer data in your data store without adding to an engineer's backlog

[ Parent | on HN ]

Re:Turn Notion into a UI for Postgres by MuffinFlavored on Monday April 03, 2023 @03:48PM (#35430210)

looks like it is using https://www.usebracket.com/pricing which I found from your "about" here https://news.ycombinator.com/user?id=vinarun so it's kind of like self-promotion, which is fine? i am just pretty sure the vibe here on hackernews is you should be upfront on who you are in relation to the product/why you are posting it instead of being like "look what i randomly stumbled upon with no affiliation"

not that i care, just for others

[ Parent | on HN ]

Re:Turn Notion into a UI for Postgres by nullsub on Tuesday April 04, 2023 @05:11AM (#35436995)

is this the right URL for Portal?

https://withportal.dev/

I'm getting a DNS lookup error

[ Parent | on HN ]

Re:Turn Notion into a UI for Postgres by vinarun on Tuesday April 04, 2023 @01:30PM (#35443113)

looks like it's working now!

[ Parent | on HN ]