Leaving Bubble for more traditional development?

chammer · 2020-12-02T22:46:27.113Z

1 - Speed, not necessarily with Bubble itself, but some of our tools use plugins. We have >1k users simultaneously try to use the same tool, which causes timeout issues from some plugins.
2 - Interactivity. I’m in edtech which has a lot of student-student and student-teacher interactions, all simultaneously. So when one person makes a data change, this needs to update in real time for the other users (like a websocket). This update time (via do a search for…) isn’t consistent, sometimes a second, sometimes 10, sometimes requires a page refresh.

Let me know what you think. Thanks!

J805 · 2020-12-02T22:49:45.297Z

Just FYI: https://manual.bubble.io/the-bubble-fundamentals/application-ownership

“Bubble apps can only be run on the Bubble platform; there’s no way of exporting your application as code. If you decide to move off the Bubble platform, you’ll have to rebuild the application logic, although we can help you export the design. We’ll do our best to help you leave if you want to.”

Also:

Bubble was having issues with this the other day. Data wasn’t being updated on the page instantly like it was before. They fixed it within a few hours though. So this should not require a page refresh anymore. Just wondering if this bug was just on Monday or not?

PS.

@nocodeventure has a good point, if something is running slow, there are so many other ways to access data. You may need to just re-structure your data or, just simply, access it differently.

Hope that helps!

@j805 www.NoCodeMinute.com

For All Your No-Code Education Needs:

One-on-One Tutoring
eLearning Hub
Video Tutorials
No-Code Classes

chammer · 2020-12-02T22:58:38.173Z

Thanks @nocodeventure and @J805 - I appreciate it. I’ll take a look and see how I can restructure our database.

J805 · 2020-12-02T23:02:17.595Z

No problem. I have learned a lot about optimizing data and workflows over the years. It makes a huge difference. There are a few resources to check for optimizing your project:

Forum Post: Performance Q&A guide

Manual: https://manual.bubble.io/architecture-optimization-and-limits-of-the-bubble-engine/performance-and-scaling

chammer · 2020-12-02T23:05:49.041Z

Thanks for your help, and providing links!

J805 · 2020-12-02T23:10:00.864Z

No problem!

cmarchan · 2020-12-03T03:03:08.054Z

Another option after you exhaust all dB and logic improvements, is to explore a dedicated plan with the Bubble folks @emmanuel . They are there to help apps scale with them. It is the foundation of their business model

chammer · 2020-12-03T03:26:41.991Z

Thanks I’ll check into it

Jici · 2020-12-03T03:32:21.718Z

And I will add this suggestion to the list: don’t hesitate to communicate with plugin author to check if there’s not an option to help you with speed or timed out issue. Don’t forget that a plugin is created using JS and if you replicate this in traditionnal dev, you may just face the same issue. So in most case, there’s some fix to applied to make it work for you

chad · 2020-12-03T08:48:09.592Z

Can you explain this a bit more… how do you not ever do a search?

nocodeventure · 2020-12-03T09:19:10.653Z

Relational database scheme

oracle.com

What is a relational database?

Learn the definition of a relational database and how it can help your business.

gaimed · 2020-12-03T09:36:38.986Z

We added pusher.js to solve nr 2 (websockets). And we have events that trigger and do stuff realtime.

chad · 2020-12-03T19:02:38.030Z

Thanks I understand relational databases.
I was just wondering what that looked like in bubble.
Are you using joining tables then having a path from the current user

Example current users things, things1, things2, field?

As opposed to having current user saved in things2 and doing a search
Example do a search for things 2 where user = current user.
I would have thought the second example was a better method as your not loading unnessesary things haha

nocodeventure · 2020-12-03T19:17:32.091Z

chad:

Example current users things, things1, things2, field?

Yep, but you will also need to connect back to User on each thing, that way you can do a lot of cool stuff with the data.

cmarchan · 2020-12-03T19:37:05.136Z

So … if I understand correctly … in your apps any “thing” has a user single record to it other than the “created by”.

… If so … it is difficult for me to visualize different types of apps where all things in the dB can have this setup. … Well … that is just me!

boston85719 · 2020-12-03T19:43:54.851Z

Do you find doing a search for a user becomes very slow? I was under the assumption that when creating a relation on one thing of another type, when searching for that one thing all the data from the other type is having to be loaded as well.

So for example, if the user has a related list of jobs and the jobs type has a list of images, when you search for the user, the list of jobs is getting loaded as well as the list of images on each job in the list.

I was doing some tests a while back for performance in terms of utilizing related data types or doing a search…for some instances it was faster to do the search than to rely on the related data types.

The reason for the test was I found loading a list of users became slow when I related a data type of ‘analytics’…trying to fetch the analytics by doing a search for analytics constrained by a text field of the users unique id fetched the analytics just as fast as using a related data type of and doing current users list of analytics; the end result was when I searched for a user it was faster as there was no related data type of analytics.

boston85719 · 2020-12-03T19:49:05.025Z

I’d be very interested in checking out the course if part of it is demonstrating the different methods and the differences in performance…that will make it really beneficial in understanding some best practices.

cmarchan · 2020-12-03T21:29:13.963Z

Will look forward to it! Thanks for sharing.

chammer · 2020-12-04T00:11:16.656Z

Thank you

chammer · 2020-12-04T00:14:06.899Z

Ohhh now we’re on to something…Thank you!