[Newbie] Cloud database on VB6

[jpbro]

Olaf's solution is very interesting and valuable. There are a number of ways to avoid SQL-Injection mentioned by DEXWERX.

All the same, how to develop 'Cloud-App' or 'Internet-App' easily and securely is still a big problem for VB6.

Could Olaf's vbRichClient5 provide a complete-fast-secure solution to develop 'Cloud-App' or 'Internet-App' for VB6 programmers?

Depending on your definition of cloud, you certainly can do this with vbRichClient5 as a key component. I don't know about the scalability aspect - my application typically would have less than 100 users at a time as most companies I work with want their own "private" cloud system, so I don't think you'll be making the next Facebook with this approach, but hey maybe

What I have in my system is a service running under Windows or Linux/Wine (RC5 classes work quite nicely under Wine) that acts as a broker between my user's database(s) (SQLite as shipped with RC5) and my users' machines. The user machines can have a native Windows client installed that communicates over an encrypted channel across the Internet to the server (using built-in RC5 RPC classes), and I also have a web interface that runs in the users' browsers. The browser connects to a normal web server (I use nginx), and the NGINX web server connects back to an custom FCGI server implementation. The FCGI server connects back to my RC5 service and the FCGI servier handles the translation of browser requests to RC5 RPC calls and back to HTTP responses (such as HTML, AJAX, etc...). Finally, NGINX handles all of the stuff between the FCGI server and the browser (in particular stuff like SSL, load balancing, etc...)

I posted a small demo of my FCGI implementation a while back, but there was no interest so it hasn't been updated in a while and has some known bugs unfortunately. Here's the link if you are interested: http://www.vbforums.com/showthread.p...FastCGI-Server

Lastly, you can see a demo of my web interface below. NOTE There is music in the video, so turn your volume down if that would be bothersome! At the back end it's all SQLite databases with RC5 handling the data connections. The FCGI server builds dynamic HTML from the data it gets from the RC5 RPC service and serves it back to NGINX, which serves it back to the browser. Works quite nicely (if a bit Rube Goldberg-ish) if I do say so myself

[Carlos Rocha]

This is really impressive Jason, congratulations - I won't tell anybody about your musical taste

[dreammanor]

Depending on your definition of cloud, you certainly can do this with vbRichClient5 as a key component. I don't know about the scalability aspect - my application typically would have less than 100 users at a time as most companies I work with want their own "private" cloud system, so I don't think you'll be making the next Facebook with this approach, but hey maybe

What I have in my system is a service running under Windows or Linux/Wine (RC5 classes work quite nicely under Wine) that acts as a broker between my user's database(s) (SQLite as shipped with RC5) and my users' machines. The user machines can have a native Windows client installed that communicates over an encrypted channel across the Internet to the server (using built-in RC5 RPC classes), and I also have a web interface that runs in the users' browsers. The browser connects to a normal web server (I use nginx), and the NGINX web server connects back to an custom FCGI server implementation. The FCGI server connects back to my RC5 service and the FCGI servier handles the translation of browser requests to RC5 RPC calls and back to HTTP responses (such as HTML, AJAX, etc...). Finally, NGINX handles all of the stuff between the FCGI server and the browser (in particular stuff like SSL, load balancing, etc...)

I posted a small demo of my FCGI implementation a while back, but there was no interest so it hasn't been updated in a while and has some known bugs unfortunately. Here's the link if you are interested: http://www.vbforums.com/showthread.p...FastCGI-Server

Lastly, you can see a demo of my web interface below. NOTE There is music in the video, so turn your volume down if that would be bothersome! At the back end it's all SQLite databases with RC5 handling the data connections. The FCGI server builds dynamic HTML from the data it gets from the RC5 RPC service and serves it back to NGINX, which serves it back to the browser. Works quite nicely (if a bit Rube Goldberg-ish) if I do say so myself

Thanks jpbro. Your Project Nomad Teaser is wonderful and I'll take some time to learn your FastCGI-Server.