Hi Fam.
Demo
It is with pleasure to release an updated Vehicle Expense Tracking WebApp (PocketBase) and also a new version using Secure Api Key MySQL REST API.
When developing webapps, one is faced with an option to use shared hosting / vps hosting. To make this process to be a smooth transition, we have released the same application, the Vehicle Expense Tracker WebApp.
Amongst other things:
Let me explain
1. In the MySQL REST API example, one uses the SDUIMySQLREST class for back-end access vs the PocketBase version one uses the SDUIPocketBase class. There is no other code change necessary except changing the class names.
2. In the MySQL REST API example, the connection string is " " vs the PocketBase being " "
3. One last thing is that the back-end on PocketBase and also on MySQL should match (database name, table names, schema)
This means that whenever one decides to move from VPS to shared hosting or vice versa, the transition will be smooth. In both cases, the back-end databases should just match in terms of the schema. For this example, the id fields on each table are NOT using auto-increment and the id values are generated in a unique fashion.
As you will note in this PocketBase demo, the functionality as demonstrated in the UI and screens is a 100% match.
How to run the Demo?
1. Download an unzip the SDVETPB file, you should see this:
2. Ensure that your firewall has port 8096 opened and that your extract to folder is not read only.
3. Double click the run_server_8096.bat file
If all goes well, your browser will be activated and a new tab will be opened, showing a Sign In prompt. Click Sign In.
Then you will be in.
How to get the Source Code?
You can get the source code for the PocketBase & also the Secure API Key MySQL REST API with a minimum certificate of appreciation.
Related Content
Demo
It is with pleasure to release an updated Vehicle Expense Tracking WebApp (PocketBase) and also a new version using Secure Api Key MySQL REST API.
When developing webapps, one is faced with an option to use shared hosting / vps hosting. To make this process to be a smooth transition, we have released the same application, the Vehicle Expense Tracker WebApp.
Amongst other things:
- This webapp helps you learn how to store images on the database as base64 strings.
- This webapp helps you learn how to use PocketBase, a SQLite Webserver that you can deploy on a VPS hosting
- This webapp helps you learn how to use MySQL REST API using a secure Api Key, this you can deploy shared hosting on top of HTTPS.
- This webapp also helps you learn how to view, load, relational data across your database and load this into select/combo boxes.
Let me explain
1. In the MySQL REST API example, one uses the SDUIMySQLREST class for back-end access vs the PocketBase version one uses the SDUIPocketBase class. There is no other code change necessary except changing the class names.
2. In the MySQL REST API example, the connection string is " " vs the PocketBase being " "
3. One last thing is that the back-end on PocketBase and also on MySQL should match (database name, table names, schema)
This means that whenever one decides to move from VPS to shared hosting or vice versa, the transition will be smooth. In both cases, the back-end databases should just match in terms of the schema. For this example, the id fields on each table are NOT using auto-increment and the id values are generated in a unique fashion.
As you will note in this PocketBase demo, the functionality as demonstrated in the UI and screens is a 100% match.
How to run the Demo?
1. Download an unzip the SDVETPB file, you should see this:
2. Ensure that your firewall has port 8096 opened and that your extract to folder is not read only.
3. Double click the run_server_8096.bat file
If all goes well, your browser will be activated and a new tab will be opened, showing a Sign In prompt. Click Sign In.
Then you will be in.
How to get the Source Code?
You can get the source code for the PocketBase & also the Secure API Key MySQL REST API with a minimum certificate of appreciation.
- Vehicle Expense Tracker PocketBase - $5
- Vehicle Expense Tracker Secure API Key MySQL REST API - $5
Pay SITHASO HOLDINGS (PTY) LTD using PayPal.Me
Go to paypal.me/anelembanga and type in the amount. Since it’s PayPal, it's easy and secure. Don’t have a PayPal account? No worries.
paypal.me
Related Content
[Web][SithasoDaisy] Revolutionize Your Ride: The Ultimate Vehicle Expense Tracker App using Api Key Secure MySQL REST API on top of HTTPS
Hi Fam Are you tired of scrambling through piles of receipts and scribbled notes just to keep track of your vehicle expenses? Say goodbye to the hassle and welcome the future of vehicle management with our cutting-edge Vehicle Expense Tracker App! Built with a secure API key authentication...
www.b4x.com