FoxPro Programming
Using AWS data stores from VFP
Gravatar is a globally recognized avatar based on your email address. Using AWS data stores from VFP
  Michael Hogan (Ideate Hosting)
  All
  Jan 14, 2019 @ 11:58am

I need to move some tables to a database server with a larger capacity. My apps are running on an AWS cloud server (which is very fast) and I know I can throw a new VM instance out there running PostGres, MySQL or MS SQL - but if I can avoid managing another VM by using one of the AWS Databases, I'd like to do so.

Any experience with any of these from VFP?

  • RDS
  • DynamoDB
  • ElastiCache
  • Neptune
  • Amazon Redshift
  • Amazon DocumentDB
Gravatar is a globally recognized avatar based on your email address. re: Using AWS data stores from VFP
  Michael Hogan (Ideate Hosting)
  Michael Hogan (Ideate Hosting)
  Jan 14, 2019 @ 12:55pm

Actually, it appears than Amazon Aurora works using either MySQL or PostgresSQL drivers - so this might be a good way to go...

Gravatar is a globally recognized avatar based on your email address. re: Using AWS data stores from VFP
  Rick Strahl
  Michael Hogan (Ideate Hosting)
  Jan 14, 2019 @ 05:06pm

Anything that in some way shape or form you can connect to with an ODBC driver should work from FoxPro.

Anything that doesn't you'll have to create an interface that provides the API interactions, or use raw REST API calls to make that happen. It's not too hard to build but perf of those kinds of interfaces is unlikely to be fast enough.

I built a MongoDb interface a long while back and that worked well, but it had a bit of overhead because of the intermediate JSON parsing interface that's required to move the data back and forth. Still it's pretty cool that that did work...

+++ Rick ---

© 1996-2024