thanks for manuals as Iâm finishing the tutorials on yt I got one main question - on the beginning we created a local db for the project itself. So just for my understanding - I can first create everything locally - develop the complete app and then âpushâ my local db to cloud db and my project files to the cloud server ?
You got it! Develop locally, then push to cloud when desired.
Some types of development work , like setting up OAuth to Google for mobile clients, will necessitate creating a Cloud development instance for development, but other than some small use cases like that you can development the majority of your app locally and not have to worry about paying for hosting until youâre ready.
You should have everything on the same hosting provider. Not sure what you mean by Oracle, but typically you will have a web server (e.g. node.js with Express) and a database server.
All applications, whether using no-code/low code tools or regular coding, typically have a configuration file which defines the database and how the application server will connect to it. In Wappler, it is defining/writing those connections for you within the Database Manager.
Technically all of that is ultimately written into files that are initially stored on your local machine in db.json and project.json under the .wappler directory.
He refers to using the Oracle Free Tier to host and take advantage of the free stuffâŠwhich is quite a lot
@x1Guru you would just point your server to the IP of the database server. It can be in the same machine or network. Or miles away. No magic. Itâs just how networking happens
One last question - can I develop my app (and learn) for now on the edu license and then when I will be ready to commercialize my project - swap to wappler pro license? Or thatâs against the licensing?
@x1Guru, do not have your database in a different data center/hosting provider from your application server. You are introducing latency and will impact performance long-term.
Iâm going for Frankfurt 1 for the Digital Ocean - Iâm not sure yet If i Can setup Oracle there - but this is one of the main location in EU for most of the digital services so I assume Oracle has one farm there as well
Oh ok. I saw you in the create cluster page and I thought you already sold your house, car, and dog to pay for stuff you donât need.
Just start building. The conversation about hosting is for another day. Maybe in a few months. You are not going to learn anything from oracle or digital ocean that you need to know right now. It might just confuse you.
Just rest knowing that Wappler already does the heavy lifting for deploying your apps and it might be even easier due to more features they add between today and the moment of your first deployment
Oracle is a company, as well as a database and, now, a cloud provider. So, itâs semantics, but something important to understand and differentiate between them when talking about âOracleâ. Are you asking about Oracle databases or Oracle as a cloud provider?
Ultimately, you are going to build an app. That app is going to need to be hosted somewhere. Whether thatâs with Oracle, Digital Ocean, Amazon Web Services, or some other cloud provider it doesnât matter. The main recommendation is to use one of them for all parts of your infrastructure. There are times when you could deviate from this recommendation, but I wouldnât for most development unless you really know what youâre doing.
Once you decide on a host, then there are going to be a few different servers you will most likely setup. Those include:
A web/application server
If youâre using node.js in Wappler, then this will usually consist of a Linux server like Ubuntu. On that Ubuntu server you will have node.js (application server), Express (web server), and possibly some other components).
A database server
The most common database servers to use with Wappler are MySQL, Postgres, or MariaDB. You are not limited to these, but I would recommend one of them. This is also where Iâm confused as to if youâre asking about the Oracle database type as an option on Digital Ocean. Oracle and MS SQL databases are typically used by enterprise-sized customers as they both require licensing with costs that are usually prohibitive to smaller companies.
You could have any number of additional parts to your infrastructure. From load balancers that sit in front of multiple application/web servers to caching-type servers and CDNs like Redis or DigitalOceans Spaces CDN that help improve performance. I wouldnât worry about these for now, but just know that they are possible and Wappler can even help with some of them.
It should work as the logic is implemented at database level. But I havenât tested as I donât have the need. I use dedicated services to perform full text search. I donât use DB.