HNHacker News
TopNewBestAskShowJobs

jordanthoms

2,885 karma · joined March 14, 2012

jordan@thoms.nz

Co-founder, Kami - kamiapp.com

submissionscomments
jordanthoms··on New Features Coming in PostgreSQL 10
Will DDL replication for the logical replication be landing in 10 or later?

We have some use cases where logical replication would be very helpful, but keeping the schema in sync manually seems like a pain - will there be a documented workaround if DDL replication doesn't make it in?

jordanthoms··on Milk that lasts for months
One of the nice things being back in New Zealand is the quality of the milk here - maybe it's just because I grew up drinking it, but it tastes vastly better to me. It has a much fuller flavour than anything I found in California - could be because all the cows here are grass-fed?

UHT is available here but for most people it's emergency use only.

jordanthoms··on VPNs are not the solution to a policy problem
The ISP can still read the SNI information to see which sites are being used, so there's not so much value in encrypting the DNS.
jordanthoms··on Startup Serves Up Chicken Produced From Cells in Lab
Chicken breast and many other meats have a much higher ratio of protein compared to carbs and fat than tofu, beans, etc.
jordanthoms··on PostgreSQL Parallel Query v2
Is it significant when you are talking about​ analytical queries which are running for minutes or hours? Seems like it wouldn't be a huge amount of code to JIT compared to the payoff?
jordanthoms··on How to Scale PostgreSQL on AWS: Learnings from Citus Cloud
That looks like a great suggestion, thanks! It looks like we'd need to break out our JSON data into columns (our events table is basically just an event name, time, user id, and then a jsonb column) and rewrite our queries, but it seems more suitable than anything else I've seen so far.

We've been getting good results with some tweaks to our Postgres indexing (partial indexes on event names makes a huge difference) and that'll be even more practical when we can move to logical replication, so will be sticking with that for now.

jordanthoms··on How to Scale PostgreSQL on AWS: Learnings from Citus Cloud
Any plans to take Citus in more of a data-warehousey, complex queries direction over time? We are starting to hit test limits of Postgres 9.6 and would like to move to a columnar store, but Redshift is hosted-only, Teradata looks expensive, Greenplum looks old.
jordanthoms··on New Zealand Will Give You a Free Trip If You Agree to a Job Interview
Prices have dropped massively in the last year or so as there are more flights and airlines doing AKL<->SFO now
jordanthoms··on Miller v5.0.0: Autodetected line-endings, in-place mode, user-defined functions
This is great - Now I just need to somehow remember this program when I next have a need for it...
jordanthoms··on High-Memory Instances and $5 Linodes
That's just... ugh. Who thought ordinal numbers were a good idea for plan ids / instance types? Seems part of what you are paying extra for with AWS/GCP etc is competent engineering.
jordanthoms··on Ask HN: Which developers do you closely follow?
I also have to point to his filmmaking work in the genre of dystopian horror: https://youtu.be/BpsMkLaEiOY
jordanthoms··on Tom Wheeler Resigns from the FCC
NZ used to have expensive and slow internet (we don't have much TV cable here, so it was all ADSL), but it's gotten a lot better in the last few years. Currently I have 1000mbit down / 500mbit up fiber with unlimited data for $130nz/month (90usd).

The model does work pretty well.

jordanthoms··on PostGraphQL: PostgreSQL meets GraphQL
The amount of code needed to verify that only the proper fields and records are included for a particular response taking into account the user's permissions etc is often not so different from the code needed to retrieve just that data in the first place.

There is an issue here where as you give more sophisticated querying capabilities to the client, you need to have correspondingly more sophisticated validation of those queries on the server, which offsets some of the gain.

jordanthoms··on Cloudy Gamer: Playing Overwatch on Azure's New Monster GPU Instances
It's not uncommon for screens to have input latencies in the 50-100ms range - John Carmack tweeted "I can send an IP packet to Europe faster than I can send a pixel to the screen. How f’d up is that?". [0]

Given that people are generally happy to accept that kind of latency for a frame getting from their GPU to photons, I don't see why an extra ~10ms of latency getting a frame back and forth from a local datacenter would be a dealbreaker except for the most demanding scenarios. It does require that the datacenter is close to the user though.

[0] - https://twitter.com/id_aa_carmack/status/193480622533120001 & http://superuser.com/a/419167

jordanthoms··on Google Compute Engine reporting issues
This issue is resolved for us now.
jordanthoms··on Google Compute Engine reporting issues
Yeah, the rate of multi zone failures is concerning. Was planning on moving our primary API behind the GCP load balancer but will have to reevaluate that.
jordanthoms··on Google Compute Engine reporting issues
We're seeing this issue for our sites behind the L7 load balancer, this is also causing the site for the stackdriver monitoring to be down: https://app.google.stackdriver.com
jordanthoms··on Ask HN: What do you use for Log Management?
Previously used logentries and papertrail, but they became expensive as our log volumes got larger and flexibility was missing.

Now we use self-hosted ELK (elasticsearch, logstash, & kibana) and I'm not itching to go back to any of the hosted services. It's not as good as something like papertrail for tailing log streams live (although that isn't very useful at larger scale) and the UI of Kibana does take a bit of getting used to though.

jordanthoms··on RethinkDB is shutting down
This is sad - Was planning on moving from Postgres to Rethink as our plan once we start to hit scalability limits / needing to shard. I guess we will see how the open source efforts go.
jordanthoms··on Amazon’s Ambition to Compete Directly with UPS and FedEx
This. I'm pretty sure there is a huge problem with USPS workers fraudulently scanning items as delivered (to meet Amazon's SLA) and then actually delivering them a week later. I'm surprised Amazon hasn't done anything about it yet.
jordanthoms··on Kubernetes – The Hard Way
Of course - following the first law of technical documentation, the amount written about it is inversely proportional to the complexity of the problem.

Seriously though, it is getting a bit silly how almost every single kubernetes demo involving persistent data just uses emptyDir or hostPath and we are all supposed to pretend that those are a production-ready solution that won't lose data. AFAIK the PersistentVolumeClaim and StorageClass stuff will be the solution for this?

jordanthoms··on Git Undo
If that's what you want, you can just use Dropbox itself to store code and use one of the several deployment tools which can pull code from it (e.g. cloudcannon).

It quickly falls apart though as you don't have a proper history, reverts, or branching - it's OK for static sites but a disaster for anything more than that.

jordanthoms··on Taking the final wrapper off of Android 7.0 Nougat
Android's starting to head down this road in a better way - add more restrictions to prevent poorly written apps from draining your battery, but allow a override in settings to 'disable battery optimizations' for that app so the user still has control.
jordanthoms··on Otto joins Uber
The US already has the best freight railways in the world [0] and one of the highest rates of rail utilization (44%), with the lowest costs on a PPP basis. The last thing that would help is the government getting involved in them again.

0 - http://www.economist.com/node/16636101

jordanthoms··on Scaling Rails to 125,000 Requests per Minute on Heroku
This is great. The multi-tenant dyno issues certainly matches our experience - we would consistently get request timeouts when under load (even if scaled up) until we moved to the single-tenant dynos. With the random routing, if even one of your dynos has a busy neighbour you _will_ be timing out on some of your requests.
jordanthoms··on Building fast.com
Try https://github.com/apenwarr/blip - built by google fiber guys for exactly this.
jordanthoms··on DeepMind AI Reduces Google Data Centre Cooling Bill by 40%
With the caveat that you end up sounding like a politician
jordanthoms··on Santa Monica convicts its first Airbnb host under tough home-sharing laws
That's a great example of how policies backfire - the 'renter-friendly' laws make it incredibly unattractive to rent places and reduce supply, hurting renters.
jordanthoms··on Neglected channels could add Wi-Fi capacity
Unfortunately that only works if the other APs are using the exact same channel, rather than an adjacent-but-overlapping one. It'd be great if consumer routers would only allow use of channel 1, 6, or 11, to avoid the usual situation where there is APs on every single channel interfering with each other rather than co-operating.
jordanthoms··on Why we challenge Microsoft’s battery test
It's great to see battery efficiency becoming something browser vendors fight over (even if it does come with a side of the usual benchmark gaming). Hopefully it shames Google into improving Chrome's battery performance.
← PreviousPage 7 of 27Next →