Advice for a newbie -

Need help Database
1

After loads of research I am starting my first Bubble project. For the past year I’ve been serving 22 retail shops using Appsheet, but Appsheet is not scalable and flexible enough to move forward.

I just need a bit of advice from experienced Bubblers to help me start of in the right direction.
Here is my use case:

I receive daily Client/Product imports from an external provider in MySQL, just a single table. A single client have multiple products. The table have the following fields:

  • Client Code*
  • Name*
  • Surname*
  • Phone*
  • Address*
  • Product Name
  • Product Type
  • Product Qty
  • Repeats

Typically a client will have 3-15 products, but the fields marked with a * is repeated in the table for each product for that client.

My plan is to use Parabola to move the data from MySQL to Bubble and to split the data into two tables (in order to create a one-to-many relationship) during the import process.

Can this be done using Bubble only, do I need Parabola to achieve what I described above?

2

You can connect to mysql without the need of 3rd party
https://manual.bubble.io/core-resources/bubble-made-plugins/sql-database-connector

3

Thank you, if I link the mySQL table to Bubble, can I then do the following using Bubble server side processes:

  • Create a Unique ID that’ll link each item to the client
  • Create unique clients in a Clients table (essentially creating a unique list of clients in the Bubble clients table) ?
  • Move all the items to an Items table ?

My aim is to only use the Bubble Database, the MySQL Table will only be used to populate the Client and Item tables on a daily basis.

4

I never used the mysql plugin before but what you want to do should be doable
each item created in the Bubble DB will be assigned a unique ID automatically and moving items also can be achieved using backend workflows

5

Perfect, thank you

6

I am trying to link the MySQL DB to Bubble but the connection times out. I am getting this error:
"Connection issue: SQL Database Connector issue: Connection attempt failed: connect ETIMEDOUT"

7

On this forum you need to ask questions, not just pose statements.

You need to also give details in order to get help. Your other replies were good.

As for the SQL connector, I guarantee you are just doing something wrong, because it works perfectly.

Send details and we can try to help!

8

connect ETIMEDOUT this error keeps popping up each time I try to connect bubble with mysql. What is the solution?

9

Please can you help out with this error “connect ETIMEDOUT”