Forum Academy Marketplace Showcase Pricing Features

Way to query my bubble database with SQL?

I’d like to use SQL to query my bubble database directly.

Can I do this using the SQL database connector? I’d need DB credentials.

Any other ideas that don’t involve writing Search fors. I mainly am needing to do this to validate the Search fors.

is this doable?

Updating my initial response… 2nd, mishav’s answer. There isn’t a plugin or eqv way to SQL query across tables using regular bubble tools. The GET will get you data from a single table. If you’re on dedicated, you can get read-access to your bubble database (logs not included). We’ve done this and use the data to feed our data warehouse.

Apart from the Data API and API workflow, there’s …

Any update on this topic ?

No. Still not doable, Bubble preserves their proprietary referential integrity by keeping users out of direct-querying the DB. Bubble aims to be low-code and zero-experience-needed, and SQL access to the backend DB isn’t on that menu.

A dedicated cluster, with requested read-only DB conn, is the only available remedy, or… you can build your apps SQL-first from the start, using purely the SQL Connector for all data object definitions and CRUD (which is my recommendation).

Thanks for your answer. Unfortunte though, especially if you want to plug SAAS tools on the database…

What specifically were you hoping to do and could it be done by replicating the data onto a SQL database?

Well, I had a couple things in mind :

Have you considered replicating your data to a SQL database. It might not give you all the capabilities you are hoping to achieve but it could be an alternative option that offers some of the functionality?

That’s something that could work for “read-only” replicates yes. Do you recommend something (plugin, good practice…) for keeping an external SQL database quite in sync with the bubble database?

Honestly the easiest solution is to use bubble’s Data API.

Yes. I have a solution for keeping an external SQL database in sync. I will post the details here, but I truthfully haven’t been using it very long and I want to make sure all of the “kinks” are worked out before I post it on the forum.

I have been able to transfer 1,000+ records reliably in under 10 seconds (without any recurring workflows) to an external database and dynamically generate the table schema from the Bubble Data Types.

3 Likes

Sounds like a great solution, I can’t wait for your post !

Looking forward to hearing about it!