Azure SQL API: Searchbox or Data Integration

Need help Database
1

Hi all,

I have a quite big database in azure SQL with procedures and lots of data. Therefore, I’m using the SQL connector to do a mix the native tables from Bubble and Azure SQL.
However, I’m facing a few challenges with that:

  1. Search box: Is there any way to use a native search box with the SQL connector? Challenges: The connector only allows 200 rows. If I add a parameter in the query to be COLUMN LIKE ‘%@PARAMETER%’, the page would need to be refresh to return the results. Any option to natively do that?
  2. In case I want to push/integrate all the data I have in Azure SQL. What would be the best practices? Is there any tool? Is this optimum?

Thanks in advance!
Luis

2

Luis,

  1. We built an advanced (paid) plugin to work with SQL data from a remote database. If you want to take a look the information is here: SQL Database Connector Pro Plugin | Bubble

Documentation on configuring the standard (free) Bubble plugin and our plugin here: Configure SQL Connector - SQL Database Connector Pro

  1. If you have a lot of data already in Azure I wouldn’t recommend pushing it over to Bubble unless there is a really specific use case for doing so, especially considering you have a lot of procedures as you mentioned.

In order to solve the search box you may want to consider sending a subset of the SQL data over to Bubble as a sort of “cache” search/query.

Let me know if you have further questions re:SQL

3

Thank you!

What is the difference between the Pro vs free?

What is the best way to send this data to bubble database so I can keep the dbs synchronised?!?