Is anyone here using AWS on the backend of their VFP app? Searching the ProFox archives, I noticed this recent thread in the past year: https://leafe.com/archives/full_thread/508558
Currently I use a MySQL (MariaDB) database from my ISP but wondered about AWS since we use that at my corporate daytime gig.
I don't think that you can just stand up your data there in AWS. I believe that you must expose it via an API. You pass in params to your method and it spits out data in XML or json.
On Mon, Oct 23, 2017 at 2:16 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Is anyone here using AWS on the backend of their VFP app? Searching the ProFox archives, I noticed this recent thread in the past year: https://leafe.com/archives/full_thread/508558
Currently I use a MySQL (MariaDB) database from my ISP but wondered about AWS since we use that at my corporate daytime gig.
[excessive quoting removed by server]
On 2017-10-23 16:49, Stephen Russell wrote:
I don't think that you can just stand up your data there in AWS. I believe that you must expose it via an API. You pass in params to your method and it spits out data in XML or json.
Now to be very clear, I'm not talking about using DBFs -- I'm talking about backends like SQL Server, MySQL, Oracle, etc.....from a VFP app.
I know SQL Server Azure can be accessed from on premises just using its published URL and the standard port however you do need to whitelist the IP addresses that can connect. I imagine the other database servers are similar.
On 2017-10-24 02:19, Alan Bourke wrote:
I know SQL Server Azure can be accessed from on premises just using its published URL and the standard port however you do need to whitelist the IP addresses that can connect. I imagine the other database servers are similar.
Yeah, my ISP can whitelist certain IP addresses too. Been that way for over a decade and a half with MySQL, as I recall. That wasn't possible with SQL Server (before AWS) if I heard correctly.
Hi Michael
Yes you can! I don't know which of your presidents said that, but it applies here I guess.
As I said in that post, I am an old programmer with very little patience to read an enormous amount of information. But my son, currently working for a US company as a software engineer enlightened me and helped me set it up.
I opened an account in AWS, and for a year I shall be able to use their services for free. In AWS you have something they call RDS, which is basically what I was looking for: a SQL Server as a service, meaning all I need is to instance a SQL Server and work from anywhere accessing all of the databases. And I will just pay for what I use and for the time I use it. it has to do with hours per month, or number of clicks or whatever, but it will amount to no more that 50 bucks, for what I gather.
They have MySQL also as a service I believe, but since I only deal with SQL Server, I would not know how good that is.
But the important thing here is you do not need to get a VM with a SQL engine inside, which is the case with Google Cloud Computing. You can get one though, through a different service they call EC2 and EC3, but that is too much for my limited purposes. (I have small clients, with few stores to operate, so I do not need too much complexity)
In my case, I simply create a ODBC connection string and use it in my VFP app, accessing the AWS SQL Server with as much ease as I can access the LAN server.
BTW, because in my country sometimes we have problems with the internet service, I implemented a special routine that will access a local server as well. In case there is a connection failure, the stores work locally and then, when the service is restored, the routine updates the cloud server with all the transactions missed. No big deal there.
I know I could set up a replication paradigm, but then it costs more money and my stingy clients do not like to pay too much.
I hope it helps
Regards
Rafael Copquin
El 23/10/2017 a las 20:28, mbsoftwaresolutions@mbsoftwaresolutions.com escribió:
On 2017-10-23 16:49, Stephen Russell wrote:
I don't think that you can just stand up your data there in AWS. I believe that you must expose it via an API. You pass in params to your method and it spits out data in XML or json.
Now to be very clear, I'm not talking about using DBFs -- I'm talking about backends like SQL Server, MySQL, Oracle, etc.....from a VFP app.
[excessive quoting removed by server]
On 2017-10-24 07:59, Rafael Copquin wrote:
Hi Michael
Yes you can! I don't know which of your presidents said that, but it applies here I guess.
As I said in that post, I am an old programmer with very little patience to read an enormous amount of information. But my son, currently working for a US company as a software engineer enlightened me and helped me set it up.
I opened an account in AWS, and for a year I shall be able to use their services for free. In AWS you have something they call RDS, which is basically what I was looking for: a SQL Server as a service, meaning all I need is to instance a SQL Server and work from anywhere accessing all of the databases. And I will just pay for what I use and for the time I use it. it has to do with hours per month, or number of clicks or whatever, but it will amount to no more that 50 bucks, for what I gather.
They have MySQL also as a service I believe, but since I only deal with SQL Server, I would not know how good that is.
But the important thing here is you do not need to get a VM with a SQL engine inside, which is the case with Google Cloud Computing. You can get one though, through a different service they call EC2 and EC3, but that is too much for my limited purposes. (I have small clients, with few stores to operate, so I do not need too much complexity)
In my case, I simply create a ODBC connection string and use it in my VFP app, accessing the AWS SQL Server with as much ease as I can access the LAN server.
BTW, because in my country sometimes we have problems with the internet service, I implemented a special routine that will access a local server as well. In case there is a connection failure, the stores work locally and then, when the service is restored, the routine updates the cloud server with all the transactions missed. No big deal there.
I know I could set up a replication paradigm, but then it costs more money and my stingy clients do not like to pay too much.
I hope it helps
Regards
Rafael Copquin
Thanks, Rafael! This sounds exactly like what I was talking about. Currently, my ISP hosts my MySQL (MariaDB) databases and I just use a simple SQLSTRINGCONNECT handle to work with it, as though it were on the local LAN. Costwise I think he's great for what I'm doing, but you know how the buzzwords sell magazines so to speak and if I could use a database on AWS that would allow me to market "using the AWS Cloud" as well. That brings credibility.
Glad it's this easy. It should be!
From a security POV placing your database in the DMZ is not as secure as it
is behind that firewall. When you place your systems in the Cloud that is a benefit you define for yourself.
http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html
It is your customer's data and you should make it as secure as possible, right? Have you ever hired white hat hackers to test your vulnerability? Some of our customers demand this before they sign trading partner contracts with us.
On Tue, Oct 24, 2017 at 9:35 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 07:59, Rafael Copquin wrote:
Hi Michael
Yes you can! I don't know which of your presidents said that, but it applies here I guess.
As I said in that post, I am an old programmer with very little patience to read an enormous amount of information. But my son, currently working for a US company as a software engineer enlightened me and helped me set it up.
I opened an account in AWS, and for a year I shall be able to use their services for free. In AWS you have something they call RDS, which is basically what I was looking for: a SQL Server as a service, meaning all I need is to instance a SQL Server and work from anywhere accessing all of the databases. And I will just pay for what I use and for the time I use it. it has to do with hours per month, or number of clicks or whatever, but it will amount to no more that 50 bucks, for what I gather.
They have MySQL also as a service I believe, but since I only deal with SQL Server, I would not know how good that is.
But the important thing here is you do not need to get a VM with a SQL engine inside, which is the case with Google Cloud Computing. You can get one though, through a different service they call EC2 and EC3, but that is too much for my limited purposes. (I have small clients, with few stores to operate, so I do not need too much complexity)
In my case, I simply create a ODBC connection string and use it in my VFP app, accessing the AWS SQL Server with as much ease as I can access the LAN server.
BTW, because in my country sometimes we have problems with the internet service, I implemented a special routine that will access a local server as well. In case there is a connection failure, the stores work locally and then, when the service is restored, the routine updates the cloud server with all the transactions missed. No big deal there.
I know I could set up a replication paradigm, but then it costs more money and my stingy clients do not like to pay too much.
I hope it helps
Regards
Rafael Copquin
Thanks, Rafael! This sounds exactly like what I was talking about. Currently, my ISP hosts my MySQL (MariaDB) databases and I just use a simple SQLSTRINGCONNECT handle to work with it, as though it were on the local LAN. Costwise I think he's great for what I'm doing, but you know how the buzzwords sell magazines so to speak and if I could use a database on AWS that would allow me to market "using the AWS Cloud" as well. That brings credibility.
Glad it's this easy. It should be!
[excessive quoting removed by server]
You're absolutely right Stephen. I will not contest that.
Amazon does have a complete security scheme, but as I said before, my clients are not that fuzzy. They are small and very glad that they can be "on line" all the time, checking availability of products in any of their branches, etc., etc. And the HO staff being able to update prices, see how sales are developing, etc, etc.
If comes to security issues I would probably contract a AWS VPN or whatever is needed, but for now, I'm OK with what I've got.
Rafael
El 24/10/2017 a las 11:49, Stephen Russell escribió:
From a security POV placing your database in the DMZ is not as secure as it
is behind that firewall. When you place your systems in the Cloud that is a benefit you define for yourself.
http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html
It is your customer's data and you should make it as secure as possible, right? Have you ever hired white hat hackers to test your vulnerability? Some of our customers demand this before they sign trading partner contracts with us.
On Tue, Oct 24, 2017 at 9:35 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 07:59, Rafael Copquin wrote:
Hi Michael
Yes you can! I don't know which of your presidents said that, but it applies here I guess.
As I said in that post, I am an old programmer with very little patience to read an enormous amount of information. But my son, currently working for a US company as a software engineer enlightened me and helped me set it up.
I opened an account in AWS, and for a year I shall be able to use their services for free. In AWS you have something they call RDS, which is basically what I was looking for: a SQL Server as a service, meaning all I need is to instance a SQL Server and work from anywhere accessing all of the databases. And I will just pay for what I use and for the time I use it. it has to do with hours per month, or number of clicks or whatever, but it will amount to no more that 50 bucks, for what I gather.
They have MySQL also as a service I believe, but since I only deal with SQL Server, I would not know how good that is.
But the important thing here is you do not need to get a VM with a SQL engine inside, which is the case with Google Cloud Computing. You can get one though, through a different service they call EC2 and EC3, but that is too much for my limited purposes. (I have small clients, with few stores to operate, so I do not need too much complexity)
In my case, I simply create a ODBC connection string and use it in my VFP app, accessing the AWS SQL Server with as much ease as I can access the LAN server.
BTW, because in my country sometimes we have problems with the internet service, I implemented a special routine that will access a local server as well. In case there is a connection failure, the stores work locally and then, when the service is restored, the routine updates the cloud server with all the transactions missed. No big deal there.
I know I could set up a replication paradigm, but then it costs more money and my stingy clients do not like to pay too much.
I hope it helps
Regards
Rafael Copquin
Thanks, Rafael! This sounds exactly like what I was talking about. Currently, my ISP hosts my MySQL (MariaDB) databases and I just use a simple SQLSTRINGCONNECT handle to work with it, as though it were on the local LAN. Costwise I think he's great for what I'm doing, but you know how the buzzwords sell magazines so to speak and if I could use a database on AWS that would allow me to market "using the AWS Cloud" as well. That brings credibility.
Glad it's this easy. It should be!
[excessive quoting removed by server]
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as secure as it
is behind that firewall. When you place your systems in the Cloud that is a benefit you define for yourself.
http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html
It is your customer's data and you should make it as secure as possible, right? Have you ever hired white hat hackers to test your vulnerability? Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers? I found this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&oe=utf-8
I don't have access to that information. Sorry.
On Tue, Oct 24, 2017 at 10:33 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as secure as
it
is behind that firewall. When you place your systems in the Cloud that is a benefit you define for yourself.
http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html
It is your customer's data and you should make it as secure as possible, right? Have you ever hired white hat hackers to test your vulnerability? Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers? I found this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&oe=utf-8
[excessive quoting removed by server]
Please excuse my ignorance, but what is AWS?
Laurie
On 24 October 2017 at 17:26, Stephen Russell srussell705@gmail.com wrote:
I don't have access to that information. Sorry.
On Tue, Oct 24, 2017 at 10:33 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as secure as
it
is behind that firewall. When you place your systems in the Cloud that
is
a benefit you define for yourself.
http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html
It is your customer's data and you should make it as secure as possible, right? Have you ever hired white hat hackers to test your
vulnerability?
Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers? I
found
this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&
oe=utf-8
[excessive quoting removed by server]
Amazon Web Services (*AWS*) is a comprehensive, evolving *cloud* computing platform provided by Amazon.com. Web services are sometimes called *cloud*services or remote computing services. The first *AWS* offerings were launched in 2006 to provide online services for websites and client-side applications.
Or Amazon Cloud.
On Tue, Oct 24, 2017 at 1:35 PM, Laurie Alvey trukker41@gmail.com wrote:
Please excuse my ignorance, but what is AWS?
Laurie
On 24 October 2017 at 17:26, Stephen Russell srussell705@gmail.com wrote:
I don't have access to that information. Sorry.
On Tue, Oct 24, 2017 at 10:33 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as secure
as
it
is behind that firewall. When you place your systems in the Cloud
that
is
a benefit you define for yourself.
VPC_Security.html
It is your customer's data and you should make it as secure as
possible,
right? Have you ever hired white hat hackers to test your
vulnerability?
Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers? I
found
this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&
oe=utf-8
[excessive quoting removed by server]
Stephen,
Thanks. I thought that WS was web services but didn't make the "A".
Laurie.
On 24 October 2017 at 19:39, Stephen Russell srussell705@gmail.com wrote:
Amazon Web Services (*AWS*) is a comprehensive, evolving *cloud* computing platform provided by Amazon.com. Web services are sometimes called *cloud*services or remote computing services. The first *AWS* offerings were launched in 2006 to provide online services for websites and client-side applications.
Or Amazon Cloud.
On Tue, Oct 24, 2017 at 1:35 PM, Laurie Alvey trukker41@gmail.com wrote:
Please excuse my ignorance, but what is AWS?
Laurie
On 24 October 2017 at 17:26, Stephen Russell srussell705@gmail.com wrote:
I don't have access to that information. Sorry.
On Tue, Oct 24, 2017 at 10:33 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as
secure
as
it
is behind that firewall. When you place your systems in the Cloud
that
is
a benefit you define for yourself.
VPC_Security.html
It is your customer's data and you should make it as secure as
possible,
right? Have you ever hired white hat hackers to test your
vulnerability?
Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers? I
found
this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&
oe=utf-8
[excessive quoting removed by server]
I didn't know that AWS allowed you to leave exposed data on their environment. I guess you do what your customers want over the long haul even when you know that you shouldn't. It has been a long time since I have dealt with cloud anything. Suddenly we are talking about flipping to the cloud for next year and I am afraid that our vendor is not experienced enough to do it for us yet.
On Tue, Oct 24, 2017 at 9:41 PM, Laurie Alvey trukker41@gmail.com wrote:
Stephen,
Thanks. I thought that WS was web services but didn't make the "A".
Laurie.
On 24 October 2017 at 19:39, Stephen Russell srussell705@gmail.com wrote:
Amazon Web Services (*AWS*) is a comprehensive, evolving *cloud*
computing
platform provided by Amazon.com. Web services are sometimes called *cloud*services or remote computing services. The first *AWS* offerings were launched in 2006 to provide online services for websites and client-side
applications.
Or Amazon Cloud.
On Tue, Oct 24, 2017 at 1:35 PM, Laurie Alvey trukker41@gmail.com
wrote:
Please excuse my ignorance, but what is AWS?
Laurie
On 24 October 2017 at 17:26, Stephen Russell srussell705@gmail.com wrote:
I don't have access to that information. Sorry.
On Tue, Oct 24, 2017 at 10:33 AM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-10-24 10:49, Stephen Russell wrote:
From a security POV placing your database in the DMZ is not as
secure
as
> it > is behind that firewall. When you place your systems in the Cloud
that
is
a benefit you define for yourself.
VPC_Security.html
It is your customer's data and you should make it as secure as
possible,
right? Have you ever hired white hat hackers to test your
vulnerability?
Some of our customers demand this before they sign trading partner contracts with us.
Thanks for that link! Got any links for those white hat hackers?
I
found
this: https://www.google.com/search?q=white+hat+hackers&ie=utf-8&
oe=utf-8
[excessive quoting removed by server]
-
Alan Bourke -
Laurie Alvey -
mbsoftwaresolutions＠mbsoftwaresolutions.com -
Rafael Copquin -
Rafael Copquin -
Stephen Russell