HN user

ramarnat

78 karma
Posts7
Comments14
View on HN

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)

Updates to H-1B 2 years ago

That's more than what you would need if you were hiring for a prevailing wage position.

Updates to H-1B 2 years ago

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.

Updates to H-1B 2 years ago

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.

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.

http://www.full360.com/2013/02/14/aws-redshift-full360-first...

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

Loading the data, including parsing the xml and converting it to json was about 50,000 records per hour on a c1.medium aws instance.

Just transforming the data from one json format to another and loading to a new couchdb is much faster - about 200,000 records per hour. The server does trip over sometimes on the bulk load, and requires a restart. This happens once every 600-700k records

Reading the data is extremely quick, While creating the views on an existing database is slow, once created, accessing the data is very fast using the keys in the views