SQL Engines / Supabase

I took a look at the road map and it says “data sync” is the next item in line. The pricing page says “SQL Engines” are coming soon. Is it possible to elaborate on this? I am trying to build my stack and I am looking for a tool I can combine with supabase. I am curious if this SQL engines data sync implies supabase tables. I am looking for a userfriendly ui for supabase. Can Baserow do this?

@bram could you please elaborate on the plans regarding the SQL engines data sync feature?

Hey @nocodegrant, the data sync feature allows you to keep a Baserow table in sync with an external source. At the moment, this is a one way sync where Baserow fetches the data from the data source and puts that in a Baserow table. You can choose to sync the two, and then it will update the table with the latest changes.

Next week we’ll be adding the first SQL engine, PostgreSQL. Here you can provide server hostname, username, table name, etc and then the table data will be visible in a Baserow table. I think Supabase uses PostgreSQL, so that could be compatible, although I haven’t tested that.

Once the table data is in, you can enhance the rows with formulas, AI capabilities, real-time collaboration, and everything else that Baserow supports.

Thanks for the reply! Yes, I think it would support Supabase then. Do you plan on a two way sync or supporting changes to the schema? If so, is there a timeline? NocoDB supports these two features, but I would prefer to use Baserow due to the improved UI and better overall product!

Hey @nocodegrant, I appreciate that you prefer to use Baserow. A two-way data sync is definitely something we want to implement, but it won’t be available short term. The release of next week will be a one-way data sync.

Do row limits include external data sources within the count? For example, if I’m on the Premium plan which has a limit of 50k rows. Will I be over my limit if I only have 10k rows in Baserow tables but I have 45k rows in a connected Supabase? Are they combined or does it only count the rows in Baserow tables?

Hey @nocodegrant, because it’s technically not a data source, but rather a data sync that copies your data into Baserow, the rows would be added to the total count. If you have 10k + 45k rows synced, then it would be 55k rows in total. This is because we want to offer all the available features and that can only be done if the data is in Baserow.