awesome video bro! should be nice if you do a tutorial showing how to build a multitenancy (share based) application like having a multiple databases, for example one for each business/enterprise, and doing a request and responses using horse framework.
Thanks! 😃 To do what your asking personally I would just setup a (TCP server) or (web socket server utilizing web sockets), on the server I would have for example 2 Databases say like Tenant1DB and Tenant2DB and quite possibly a 3rd DB for logins which could also be used to allow the server to know which Tenant the logged in user belongs to ect... ect... at this point it would be a simple matter of basic TCP communication back and forth. Clients sending data to the server... >> Server receives the data and saves what it needs to the server hosted Database files accordingly. To make things quick I would use a SQlite database, if written correctly you can make these extremely private and also encrypt the entire database file itself so that only your app can even access the thing "when it needs to... nothing to exploit via sql queries because only the server app can make those in the first place" Here is a video I did on SQLite databases in Delphi: ua-cam.com/video/2cmGdM4CbT4/v-deo.html Now as for Transport protocol you can use pretty much anything you want protocol wise as long as it fits your situation getting data to the server and from the server, personally I would recommend web sockets or any socket framework which can handle a lot of clients, since you say "Business/Enterprise" would be involved. For some tutorials on TCP and websockets have a look at these tutorials I made: TMS Websockets: ua-cam.com/video/e7wjOgnGMJY/v-deo.html (PAID) IPWorks Sockets ua-cam.com/video/t_jykzyf5nU/v-deo.html (These are also available for .NET applications as well) (PAID) NetCom7 Sockets (VERY Good choice and works Cross platform): ua-cam.com/video/nTFDiRje7cU/v-deo.html (FREE) INDY Sockets ua-cam.com/video/b46OT2daq_k/v-deo.html (Free) DZSockets ua-cam.com/video/vUnPBdVzFeI/v-deo.html (FREE) Basic Winsock Wrappers ua-cam.com/video/Nuasl8xfCmA/v-deo.html (FREE) and ICS Sockets from this video however I would not recommend ICS sockets for large scale projects the author himself has stated even his threading server is only good for about a few thousand connections and depending on the size of the business / Enterprise that may not suit your needs. Now also you have many choices on how you would like to display your client / server for example you could write 2 apps which are Cross platform using FMX Firemonkey OR you could even write the server up as a live web application using many of the different web frameworks that Delphi has: UniGUI: (My personal Fave) TMS Web Core IntraWeb (VCL for the Web) Delphi MVC Framework RAD Server (EMS) Horse For Delphi (not the same horse framework as C# and the .NET framework its different) 😉 WiRL DataSnap Brook Framework Delphi Web Broker Elevate Web Builder (EWB) Kitto Smart Mobile Studio mORMot (I have herd really good things about this framework seems well updated and maintained) If you choose to make your server web based then users would not need a client app because their browsers would then become the client based application when they visit your web servers URL. after you have done some research and decided on what you want to do if you still need assistance or a tutorial made up on how this could be easily done let me know.
awesome video bro!
should be nice if you do a tutorial showing how to build a multitenancy (share based) application
like having a multiple databases, for example one for each business/enterprise, and doing a request and responses using horse framework.
Thanks! 😃 To do what your asking personally I would just setup a (TCP server) or (web socket server utilizing web sockets), on the server I would have for example 2 Databases say like Tenant1DB and Tenant2DB and quite possibly a 3rd DB for logins which could also be used to allow the server to know which Tenant the logged in user belongs to ect... ect... at this point it would be a simple matter of basic TCP communication back and forth. Clients sending data to the server... >> Server receives the data and saves what it needs to the server hosted Database files accordingly.
To make things quick I would use a SQlite database, if written correctly you can make these extremely private and also encrypt the entire database file itself so that only your app can even access the thing "when it needs to... nothing to exploit via sql queries because only the server app can make those in the first place"
Here is a video I did on SQLite databases in Delphi: ua-cam.com/video/2cmGdM4CbT4/v-deo.html
Now as for Transport protocol you can use pretty much anything you want protocol wise as long as it fits your situation getting data to the server and from the server, personally I would recommend web sockets or any socket framework which can handle a lot of clients, since you say "Business/Enterprise" would be involved.
For some tutorials on TCP and websockets have a look at these tutorials I made:
TMS Websockets: ua-cam.com/video/e7wjOgnGMJY/v-deo.html (PAID)
IPWorks Sockets ua-cam.com/video/t_jykzyf5nU/v-deo.html (These are also available for .NET applications as well) (PAID)
NetCom7 Sockets (VERY Good choice and works Cross platform): ua-cam.com/video/nTFDiRje7cU/v-deo.html (FREE)
INDY Sockets ua-cam.com/video/b46OT2daq_k/v-deo.html (Free)
DZSockets ua-cam.com/video/vUnPBdVzFeI/v-deo.html (FREE)
Basic Winsock Wrappers ua-cam.com/video/Nuasl8xfCmA/v-deo.html (FREE)
and ICS Sockets from this video however I would not recommend ICS sockets for large scale projects the author himself has stated even his threading server is only good for about a few thousand connections and depending on the size of the business / Enterprise that may not suit your needs.
Now also you have many choices on how you would like to display your client / server for example you could write 2 apps which are Cross platform using FMX Firemonkey OR you could even write the server up as a live web application using many of the different web frameworks that Delphi has:
UniGUI: (My personal Fave)
TMS Web Core
IntraWeb (VCL for the Web)
Delphi MVC Framework
RAD Server (EMS)
Horse For Delphi (not the same horse framework as C# and the .NET framework its different) 😉
WiRL
DataSnap
Brook Framework
Delphi Web Broker
Elevate Web Builder (EWB)
Kitto
Smart Mobile Studio
mORMot (I have herd really good things about this framework seems well updated and maintained)
If you choose to make your server web based then users would not need a client app because their browsers would then become the client based application when they visit your web servers URL.
after you have done some research and decided on what you want to do if you still need assistance or a tutorial made up on how this could be easily done let me know.