Viewing profile — clarkdave

As a British millennial, I got it at school, I guess sometime in the 90s. Still have the scar

> It's not like there is a mirror datacenter just two blocks away Isn't that exactly what Availability Zones are for? They're physically separate[0] datacenters and each one contai…

Not sure about heat pumps, but in the UK at least there are a couple of companies that specialise in residential water cooled AC, e.g [0]. They use the cold water intake to cool do…

Kysely is excellent! Another library that complements it is pgTyped[0]. It compiles .sql files into functions with strongly typed parameters and return values [0] https://pgtyped.d…

Not sure if this is what you're getting at, but RabbitMQ is indeed pretty great at having thousands of queues, even on modest hardware, and can be used for per-tenant queues in thi…

I think the typescript-eslint plugin in particular has some high value eslint rules that complement TypeScript. For example, the no-floating-promise[0] rule catches some easily-mad…

Indeed! There is at least one other difference, which is that the presence of null characters will cause an error in `jsonb`, but not `json`: # select '{ "id": "\u0000" }'::json; -…

Indeed, the interchanges can be quite arduous, as it tends to be very deep, and usually quite a trek from the other lines in that station. This also means it can take a good chunk …

They just changed the versioning scheme; it used to be that e.g. 9.3 -> 9.4 was a major version (i.e. can't be upgraded in-place). Starting with PG 10 major versions are now 10 -> …

Power is needed for the full “smart toilet” experience, which can include a heated seat and warm water, and other less useful features like a self-opening toilet seat. It’s hard to…

From the interview (it's way down the page): > The most challenging thing is the absence of the specification. I had to infer everything just from test cases. > The second thing is…

I've tried a lot of different monitor setups for productivity - ranging from three 24" 4k displays to a single 49" ultrawide, and ultimately have found the best setup for me is dua…

Sorry, I just realised my comment was ambiguous. The apps claim not to support Firefox, and then I'd just close the app without trying with a spoofed UA - so it's not necessarily a…

The killer feature of containers for me is keeping Google isolated. I've degoogled my personal life but still have to use it for work (i.e. G-Suite SSO). I can force all those site…

Seconded! I started using this a few weeks ago after finding out about it on HN and it has been excellent. There's a small 1-2s delay while it loads and sanitizes the results but I…

I use `facebook@mydomain.com` instead, which is easy enough to do with catch-all aliases.

We used to use alpine because it was smaller (ferrying images in and out of AWS adds up) and the package management UX often felt better (the community and testing repos tend to ma…

The Synthetics pricing does seem unreasonably high. We were using Synthetics during beta alongside Pingdom - doing pretty much the same on both. Beta period ended and sales rep sai…

This looks great! I notice you mentioned Prettier in the post — do you have any plans to integrate sqlfmt with that? Prettier actually has a beta Postgres plugin, but progress on i…

Have you looked at Buildkite[0]? The management/pipeline part is hosted (like Travis), but you run the build agents on your own infrastructure (they run on pretty much everything, …

Shopify app dev here -- it seems to be incredibly widespread; we haven't received a single webhook from Shopify in over 10 minutes and all our inbound traffic from Shopify dropped …

We’ve been running Postgres on i3 instances with their attached SSDs. Performance is solid and it’s cheaper too. Having up to date replicas becomes crucial, along with incremental …

If you don’t mind converting the Excel file to CSV, csvkit[0], which is mentioned in the list, has a tool to pipe Excel into CSV for further processing by its sibling tools. It won…

Have you tried Bear - http://www.bear-writer.com - for notes? I've found it far more pleasant than Evernote, although it's Mac + iOS only (no web).

The new Kindle Oasis (2017) has this feature. It’s pretty good! Bit annoying to turn on though at about four taps, hidden away in the accessibility settings.