How to show data from external DB

Need help Database
1

Hi,

I installed the SQL plugin, and created a successful connection to my MySQL database.

I also created a query that does a simple select:

image
image851×160 6.83 KB

Now, I want to show some rows from that query on the page.
So I created a RepeatingGroup, and chose “get_countries” as the Type of content:

image

I also created a text field in the RepeatingGroup and configured it as the country’s name (which is a field in my query):

image

After doing so and loading my preview, my RepeatingGroup is empty.
I also tried playing with the “Data Source” of the RepeatingGroup but couldn’t make it work.

I double check and my sql qurey returns a set of results - it’s not empty.

Any idea what I’m doing wrong?

2

Data source: “get data from an external api”

3

Thanks @cmarchan !!

4

Another question - Bubble only let us select data with maximum 200 rows.

I need to let my users choose their country from a list of 200+ countries - How can I do that?

Thanks

5

I am not sure I follow. Where/when does that 200 limit take place?

1 Like
6

The 200 row limit is only for data entries and applies only when you’re on the free plan. This doesn’t affect external APIs.

1 Like
7

Thanks @johnny

I upgraded my plan to paid - When I enter a new SQL query in the SQL plugin page I still get the following alert:

image

This is a simple select query from a table of 200+ countries - I want to let the use select a country from a list so it’s crucial to have more than 200 in this case.

Any idea what I can do?

Thanks

8

Hey there @fish,

How’s your WF for that setup? Are you using the “Get external API” action @cmarchan was talking about?

9

Hi @johnny ,

To answer your question - Yes, when I configured the repeating group, I chose external API and it works.

However, the 200 limit alert, appears on an earlier step - when I configure the SQL query inside the SQL plugin screen, see here:

image
image805×765 27.2 KB

If the “limit 0, 200” is not there, I get that alert I showed you above.

Any idea how to solve this?

Thanks