What is the Most Affordable and User-Friendly Database to Use with Pipedream?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Quick question: What is the cheapest and easiest database to work with with Pipedream. I was using google sheets but it is a bit clunky. Any ideas. Needs to be simple and cheap like airtable.com etc

2

I recommend taking a look at Notion. The UI is so good and simple while using our built-in actions work so well with databases.

3

The only thing that is missing is webhooks if you need triggers

4

Supabase has a free plan for 500mb of storage, and it works out of the box with the Pipedream Postgres app:

5

I’m also using Notion. Works very robust over the last months, but as I miss webhooks for triggers.

6

Pierce, can you execute SQL on your Supabase db via API?

7

Yup, you can use REST or SQL directly to interact with Supabase: REST API | Supabase Docs

8

All really useful… Thank you… Will do some research based on this

9

What about bigquery compared to Supabase?

10

I would think that bigquery is more designed for larger datasets, so you sacrifice speed of queries at the cost of lower storage costs

11

Thanks for sharing !