SQLite and NodeJS Performance in Wappler for Multi-User Applications

[mk]

Hello Wappler Community,

I have over 8 years of experience using Bubble. However, due to its various limitations, I decided to explore Wappler.io. I have minimal coding experience and have attempted to use Wappler at least 4 times in the past 3 years but ended up giving up each time because I felt it was too challenging.

This time, however, I am fully committed to learning Wappler.io because I see its many advantages, including the absence of platform lock-in, faster development capabilities, and the wonderful and supportive community that is always eager to share knowledge and guidance.

I have a couple of questions for the community and would greatly appreciate your advice:

1. When using SQLite with NodeJS in Wappler.io, how many concurrent users can it handle for writing to the same table? I’m building a Marketplace application with approximately 500 users accessing it daily. Any approximate number would be very helpful.
2. If I deploy a Web Application on a hosting server and develop another Web Application that needs to access the same SQLite database from a different domain, is it possible to perform operations like Read, Write, Update, and Delete on a table (e.g., user) from the other application? If so, how can I achieve this?

I truly appreciate any guidance you can provide.
Thank you so much in advance!

[kfawcett]

Why are you using SQLite instead of postgres or MySQL? Typically SQLite is used for mobile apps, not server apps.

I would recommend using postgres for server based apps with many concurrent users.

[kfawcett]

@mk

If I deploy a Web Application on a hosting server and develop another Web Application that needs to access the same SQLite database from a different domain, is it possible to perform operations like Read, Write, Update, and Delete on a table (e.g., user) from the other application? If so, how can I achieve this?

Yes, you will create Server Connect APIs to allow CRUD operations on you web app.

[mk]

@kfawcett

Why are you using SQLite instead of postgres or MySQL? Typically SQLite is used for mobile apps, not server apps.

I would recommend using postgres for server based apps with many concurrent users.

Thank you for your recommendation. I will give MySQL a try as you suggested. Initially, I faced issues with writing or inserting data into MySQL (I was using MAMP on macOS at the time). However, after switching to XAMPP for testing on my machine, I’m now able to submit forms and insert data successfully.

Thanks again for your advice.