Also great to bypass Netflix/Hulu/Disney geo or VPN restrictions. I run ZT on my travel Amazon firestick, connect to my home network, turn on use default gateway and all traffic goes via my home router.
Using a similar setup, a friend in Oz and I also share ZT networks, so either he or I can use them to watch content that is only available regionally. The traffic uses home IPs, so it won't get blocked or detected.
It just works.
(Disclosure: was part of the first angel round investment in ZT)
You'd still have to comply with the H1-B rules for the job you are petitioning for, like the duties you are performing, the salary requirements etc. And the legal costs of doing the petition.
Now, misuse could come if you are independently wealthy and can self fund, but at the end of the day if you are doing that in the US, the economy still benefits.
> In addition, for those individuals who obtained treaty country nationality through a financial investment, USCIS may require additional documentation to show that the applicant has been domiciled in the treaty country indicated in the application for a continuous period of at least 3 years at any point before applying for E-1 or E-2 classification.
Plus E-2 visa is a non-immigrant visa, so it doesn't give you any kind of special pathway to green card. Might as well apply for an EBx at the outset instead of fiddling with an E-2 visa.
You're missing several. Montenegro and Macedonia are definitely available, and I think also Panama.
> Might as well apply for an EBx at the outset instead of fiddling with an E-2 visa.
EB-5 has pre-country quotas, and for some countries the wait can be quite long (for China it's around 10 years). It also is veeerrrryyyyyy slow, even with the initial form processing taking _years_.
You're right on North Macedonia (which again needs $200k, so terrible value for the $ hence the low takers) but wrong on others. Montenegro suspended its CBI program and Panama never had one, only a residence visa which then you use to naturalize after 5 years (plus it technically doesn't permit dual citizenship although enforcement seems non-existent)
For EB-5, China and India have a waitlist but that's only in the 'unreserved' category. There are new EB-5 categories now that both reduce the investment amount required and processing can be done in a couple months now. If one really wants to immigrate and has the money, EB-5 is still the best choice by far.
EB-5 is a onetime payment for a green card (permanent residence). Prevailing wage must be paid every year and you have 60 days to leave when you the company stops paying you.
Yes, but the prevailing wage threshold would be lower than the investor visa, as will the commitments. The investor visa you have to show a plan, hire people etc.
Hi! We don't have plans to add Vertica yet. But if your team is willing to help or send PR we can reconsider!Feel free to reach out directly to me at vladimir@jitsu.com
Like others have mentioned, Postgres and Redshift are very different animals, Postgres is a row store and Redshift is a column store. On large data sets analytic queries that return a few columns will significantly outperform a row store DB.
We have found that Redshift is comparable to other columnar databases we work with, while we cannot publish any comparative benchmarks, we did put a blog post on what we found (link in another comment here)
While you could use Redshift as a source for OLAP, most OLAP tools will have their own data store. But if you are referring to ROLAP, then it can perform well if tuned properly for the star schema. This would include BI tools like Microstrategy and Mondrian with Jaspersoft.
The main issue with Redshift is the lack of multiple sort orders on a table. Take a look at our blog post on first impressions gleaned during the preview. Disclosure: we are one of a couple of systems integrator partners for Redshift.
more power to you - its always the most flexible if you are using the lowest common denominator tool. My point in the post (if you read it) is that since we do use AWS, and have code to manage its specifics (which we have to do in fog as well) by abstracting the cloud resources into CloudFormation, our recipes get more portable. YMMV.
Now that I have this up, I was hoping to be able to work with the usaspending.gov team to get a feed or extension to the api, that gives me the changed records since the last upload. Then update the aws snapshot with this. Do this on the same timeline that the usaspending.gov does it, monthly
Using a similar setup, a friend in Oz and I also share ZT networks, so either he or I can use them to watch content that is only available regionally. The traffic uses home IPs, so it won't get blocked or detected.
It just works.
(Disclosure: was part of the first angel round investment in ZT)