Thanks, Option B was sounding great until we got to the licenses and the learning curve for maintaining your own host.
I might just be better off doing what I'm doing and biting the bullet and learning how to get my data into mysql reliably as that is my bottleneck (all data files come from a spreadsheet, that I load into open office calc and save as a dbf and then I add the longitude, latitude in VFP and create the SQL Insert statement (i find different types of garbage and what happens now is when I find a problem that I haven't run across before, I need to repeat the process and update my VFP code that creates the sql statment) What I'm doing is creating one of these google maps for all major job occupations (google BLS OES) The links work - if not, you can find it here http://keepamericaatwork.com/give-me-a-map-for-2014-showing-all-h-1b-applications-in-america/ ) - 11 – Management Occupations Map <http://keepamericaatwork.com/map_11.html> - 13 – Business and Financial Operations Occupations Map <http://keepamericaatwork.com/map_13.html> - 15 – Computer and Mathematical Occupations (lot of data, wait for it to load) - WA, OR, CA, ID, UT, CO, NV, & AZ Map <http://keepamericaatwork.com/map_computer_westcoast.html> - MT, WY, ND, SD, MN, IA, WI & IL Map <http://keepamericaatwork.com/map_computer_northwest.html> - NM, KS, TX, OK, MO, AR, LA & NB Map <http://keepamericaatwork.com/map_computer_southcentral.html> - MS, AL, GA, FL, SC, NC, TN & KY Map <http://keepamericaatwork.com/map_computer_southeast.html> - ME, NH, VT, NY, NJ, CT, PA & MA Map <http://keepamericaatwork.com/map_computer_northeast.html> - MD, DE, IN, MI, OH, WV, VA & RI Map <http://keepamericaatwork.com/map_computer_remaining.html> - 17 – Architecture and Engineering Map <http://keepamericaatwork.com/map_17.html> - 19 – Life, Physical and Social Science Map <http://keepamericaatwork.com/map_19.html> - 21 - Community and Social Service Organizations Map <http://keepamericaatwork.com/map_21.html> - 23 – Legal Occupations Map <http://keepamericaatwork.com/map_23.html> - 25 – Education, Training & Library <http://keepamericaatwork.com/map_25.html> - 27 – Arts, Design, Media, Sports & Entertainment <http://keepamericaatwork.com/map_27.html> - 29 – Healthcare Practitioners and Technical <http://keepamericaatwork.com/map_29.html> - 31 – Healthcare Support <http://keepamericaatwork.com/map_31.html> - 33 – Protective Services <http://keepamericaatwork.com/map_33.html> - 35 – Food Preparation and Serving Related <http://keepamericaatwork.com/map_35.html> - 37 – Building and Ground Cleaning and Maintenance <http://keepamericaatwork.com/map_37.html> - 39 – Personal Care and Service <http://keepamericaatwork.com/map_39.html> I have about 10 more left to do on this before I'm finished. I also am doing it on a company basis - Infosys <http://keepamericaatwork.com/map_infosys.html> - Microsoft <http://keepamericaatwork.com/map_microsoft.html> - IBM <http://keepamericaatwork.com/map_ibm.html> - Google <http://keepamericaatwork.com/map_google.html> - Baltimore <http://keepamericaatwork.com/map_baltimore.html> - WIPRO <http://keepamericaatwork.com/map_wipro.html> After I finish all of these, and I'm probably looking at months, I want to do a per job type map using numbers like these that I found on BLS OES, and ultimately I need to make it data driven as right now, I simply change the SQL select statement and the map remains the same, although I give it a different name for each map (not the way I would normally do it, but it is what it is for now.) 31-0000Healthcare Support Occupations <http://www.bls.gov/oes/current/oes310000.htm>major3,924,3900.4%29.598$12.54 $13.61$28,3000.2%31-1010Nursing, Psychiatric, and Home Health Aidesbroad 2,361,9100.5%17.814$11.22$11.87$24,7000.3%31-1011Home Health Aides <http://www.bls.gov/oes/current/oes311011.htm>detail806,7101.2%6.084$10.10 $10.60$22,0500.4%31-1013Psychiatric Aides <http://www.bls.gov/oes/current/oes311013.htm>detail75,3402.1%0.568$12.08 $12.98$26,9901.2%31-1014Nursing Assistants <http://www.bls.gov/oes/current/oes311014.htm>detail1,427,8300.5%10.769 $11.97$12.51$26,0200.2%31-1015Orderlies <http://www.bls.gov/oes/current/oes311015.htm>detail52,0302.4%0.392$11.75 $12.66$26,3400.6%31-2000Occupational Therapy and Physical Therapist Assistants and Aidesminor160,4301.2%1.210$20.80$21.19$44,0800.6%31-2010Occupational Therapy Assistants and Aidesbroad39,1602.4%0.295$24.16$23.75$49,3901.3% 31-2011Occupational Therapy Assistants <http://www.bls.gov/oes/current/oes312011.htm>detail30,4502.0%0.230$26.57 $26.56$55,2500.8%31-2012Occupational Therapy Aides <http://www.bls.gov/oes/current/oes312012.htm>detail8,7108.2%0.066$12.67 $13.90$28,9002.5%31-2020Physical Therapist Assistants and Aidesbroad121,270 1.2%0.915$19.43$20.37$42,3600.5%31-2021Physical Therapist Assistants <http://www.bls.gov/oes/current/oes312021.htm>detail72,6401.4%0.548$25.65 $25.63$53,3200.5%31-2022Physical Therapist Aides <http://www.bls.gov/oes/current/oes312022.htm>detail48,6302.0%0.367$11.69 $12.50$25,9900.6%31-9000Other Healthcare Support Occupationsminor1,402,060 0.5%10.574$14.92$15.66$32,5700.2%31-9011Massage Therapists <http://www.bls.gov/oes/current/oes319011.htm>detail79,0403.0%0.596$17.27 $19.42$40,4001.1%31-9090Miscellaneous Healthcare Support Occupationsbroad 1,323,0100.5%9.978$14.83$15.44$32,1100.2%31-9091Dental Assistants <http://www.bls.gov/oes/current/oes319091.htm>detail309,5400.9%2.335$16.78 $17.13$35,6400.4%31-9092Medical Assistants <http://www.bls.gov/oes/current/oes319092.htm>detail571,6900.8%4.312$14.24 $14.80$30,7800.3%31-9093Medical Equipment Preparers <http://www.bls.gov/oes/current/oes319093.htm>detail51,3001.5%0.387$15.25 $16.02$33,3200.4%31-9094Medical Transcriptionists <http://www.bls.gov/oes/current/oes319094.htm>detail68,3502.0%0.516$16.63 $16.95$35,2600.5%31-9095Pharmacy Aides <http://www.bls.gov/oes/current/oes319095.htm>detail42,2503.9%0.319$10.85 $11.78$24,5100.9%31-9096Veterinary Assistants and Laboratory Animal Caretakers <http://www.bls.gov/oes/current/oes319096.htm>detail71,8002.3% 0.542$11.32$12.07$25,1100.7%31-9097Phlebotomists <http://www.bls.gov/oes/current/oes319097.htm>detail108,2101.6%0.816$14.50 $15.10$31,4100.4%31-9099Healthcare Support Workers, All Other <http://www.bls.gov/oes/current/oes319099.htm>detail99,8801.9%0.753$16.42 $16.80$34,9500.4% On Thu, Jan 29, 2015 at 9:13 AM, Kevin Cully <kcu...@cullytechnologies.com> wrote: > Hello Virgil, > > I think there are three ways to go to keep this on the cheap: [A] VPS [B] > Vultr.com or [C] Brute force VFP > > [A] For inexpensive VFP and Windows hosting, there are many companies that > provide Virtual Private Server (VPS) support. They typically start at $25 > per month. This will get you a Windows Server with IIS and you can load VFP > executables where you can run West-Wind or AFP or something in between. The > downside is that it truly is a "shared" server so performance will suffer > as the load grows by other users being added to that server. Basically, > your site can slow down because other people are hogging the CPU and other > resources. > > [B] I recently stumbled upon a company called Vultr.com. They offer server > hosting but what makes them different is that you can upload a Windows > Server ISO and create your own Windows + VFP solution. I've used them for > Linux hosting and the performance on their "All SSD" server farm is > amazing. Prices start at $5 per month, but you'd need your own license of > a Windows server, and you would need to install and maintain your own > firewall, patches etc. You are on your own with this configuration and > that'd be pretty scary to me for a Windows solution. > > [C] I'm not really clear on what your end result is but what about using > VFP locally on your PC or laptop to crank out HTML or PHP pages? You can > then programmatically FTP (curl or Sweet Potato's FTP FLL) to upload those > files to a cheap Linux hosting. For searching, you can embed the Google > search of your site. The downside is that the site is pretty 'static' but > the price is right. > > I'll cheat and throw in an option [D] here and suggest that you download a > free copy of Xojo from http://xojo.com. You can get started building web > applications that are very much like building a VFP desktop application and > use a very VFP application mindset. If you decide to deploy the application > (build an app using the "alone alone" target for Linux) that is when you > would need to purchase a license. Write both your VFP app and the Xojo app > to access the same MySQL databases. I've tested deploying a Xojo app to > Vultr.com and DigitalOcean.com for their starting $5 per month cost and it > seems to work well for the short time I was testing it. > > Good luck, > Kevin > > CULLY Technologies, LLC > 678-929-7762 > http://cullytechnologies.com > http://cully.biz > > On 01/29/2015 09:35 AM, Virgil Bierschwale wrote: > >> Does something like that exist? >> >> I need to add data files from 02 till 15 for my maps and I'm running into >> lots of garbage in the data which consumes an enormous amount of time >> because of my inexperience with mysql, php, etc. and I could do it in >> seconds using vfp. >> >> I have found that I can enable a remote host (as long as it is on the >> internet, static ip, etc) >> >> What I'm thinking about is moving the data to a vfp host, doing all my >> preprocessing there and then doing a insert into the mysql table, or maybe >> even doing it all on a vfp box/host. >> >> Normally time would not be an issue but I'm getting more and more demands >> for my maps from various organizations and after being without work for so >> long, I like demand. >> >> Now if I can just figure out how to monetize it <g> >> >> Thanks, >> >> Virgil >> >> >> --- StripMime Report -- processed MIME parts --- >> multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> [excessive quoting removed by server] _______________________________________________ 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/capuy6voavnyc373v8_jk1gqgeaevgusdoxjg+21y0dh6ftg...@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.
