Re: VFP - web app interchange format?

Author: Ted Roche

Posted: 2014-02-23 at 16:33:22

Tom and Alan:

Thanks for the replies. Good answers.

The web side with definitely be a Linux machine, likely Postgres, and

probably Ruby on Rails. An app like that speaks JSON and XML just fine, and

can even do the encoding/decoding if it makes more sense to do that

server-side. So, if we pick XML for the VFP interface, it's fairly simple

to support a second JSON interface later on. The VFP client will be the

first pass, first-years budget, but the client would really like to get

into smaller smart devices (tablets, phones) if that makes sense (cost

reliability, ease of development on native platform, etc.)

So, the VFP app is really a single-function app: collect specific order

data. (and the auxilliary functions of up- and down-load.) It collects some

specific metrics, runs a custom pricing module, spits out an estimate and

closes the sale.

I'm tempted by the simplicity of CursorToXML() and XMLToCursor() since

their built-in, know about encoding, and can produce valid XML. The VFP can

read the files in, and generate them out with no 3rd party dependency. The

web app would provide a secure up-and down-load.

It will be wordier than JSON since attributes or properties will be

repeated for each row, but the quantity of data is limited to to a day's

work, so that's likely never more than 40 or 50 rows, so I don't think the

bandwidth consumed should be a big concern.

On Sun, Feb 23, 2014 at 3:33 PM, Alan Bourke <alanpbourke@fastmail.fm>wrote:

> I would advocate using JSON over XML.

--

Ted Roche

Ted Roche & Associates, LLC

http://www.tedroche.com

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CACW6n4vamh3Nk3d8Pzx1TX-Q08uEOHcjOrYNRedicBYsqU47Ng@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Ted Roche