Hacker News: mikeklaas

New comment by mikeklaas in "On being tired"

mikeklaas — Sun, 14 Aug 2022 00:44:50 +0000

> Most weekends rather than recharging for the rest of the week, I end up more tired than I started.

As a parent, it's hard to remember that ending a weekend "recharged" is a common experience.

New comment by mikeklaas in "Things to know about databases"

mikeklaas — Mon, 27 Jun 2022 19:33:48 +0000

There are projects that use LSMTs as the storage engine for RDBMS' (like RocksDB); I'm not sure it's accurate to say "they can't be use as an RDMBS".

New comment by mikeklaas in "Oauth2 support for GMail"

mikeklaas — Wed, 18 May 2022 19:08:29 +0000

Development apps are exempt from the requirement. (They are also limited to 100 accounts)

New comment by mikeklaas in "Single dependency stacks"

mikeklaas — Wed, 09 Feb 2022 22:53:34 +0000

Multiple databases in postgres fundamentally share the same underlying infrastructure (i.e., WAL), and so do not offer much in terms of scalability or blast-radius protection compared to putting all tables in the same database.

New comment by mikeklaas in "Ask HN: What are the best-designed things you've ever used?"

mikeklaas — Sat, 27 Nov 2021 04:52:56 +0000

I'm surprised to see the Portal listed. We have one for letting the grandparents talk to the kids, and it is the most unreliable piece of technology I've owned. Constant connection issues and laggy UI.

New comment by mikeklaas in "Never update anything"

mikeklaas — Sat, 06 Nov 2021 00:10:03 +0000

whoa, do you have a link?

New comment by mikeklaas in "When “Foundation” Gets the Blockbuster Treatment, Asimov’s Vision Gets Lost"

mikeklaas — Tue, 02 Nov 2021 17:06:01 +0000

That's probably the worst book in the series.

New comment by mikeklaas in "A read query can write to disk: a Postgres story"

mikeklaas — Mon, 01 Nov 2021 14:08:43 +0000

> And it can't be adjusted on the fly, per query.

Sure it can:

   SET LOCAL work_mem = '256MB';
   SELECT * FROM …

New comment by mikeklaas in "Roblox has been down for days and it’s not because of Chipotle"

mikeklaas — Sun, 31 Oct 2021 21:22:33 +0000

I find it pretty odd to speculate that they are experiencing a very specific failure mode of a particular database. Do you even know whether they use Postgres?

New comment by mikeklaas in "1 Year of Coinbase as a mission focused company"

mikeklaas — Fri, 08 Oct 2021 20:21:49 +0000

Do you have a source for that?

New comment by mikeklaas in "Samoa Scraps Daylight Saving Time"

mikeklaas — Thu, 23 Sep 2021 19:43:57 +0000

The "good reason" is that considering 12am the "middle of the day" only makes sense if the typical sleeping window was 8pm to 4am (making midnight the "middle of the night").

New comment by mikeklaas in "Zero-downtime schema migrations in Postgres using views"

mikeklaas — Wed, 16 Jun 2021 21:21:06 +0000

Adding a NULL constraint isn't zero downtime since PG scans the whole table ensuring that the constraint is not violated.

New comment by mikeklaas in "Do you really need Redis? How to get away with just PostgreSQL"

mikeklaas — Mon, 14 Jun 2021 20:37:44 +0000

Perhaps I misinterpreted this part?

> I struggle to consider using it as a data store these days as well with other options on the table.

It sounds like you wouldn't use it for any purposes.

New comment by mikeklaas in "Do you really need Redis? How to get away with just PostgreSQL"

mikeklaas — Sat, 12 Jun 2021 20:39:48 +0000

What would you use redis for, if anything?

New comment by mikeklaas in "Logical replication and decoding for Cloud SQL for PostgreSQL"

mikeklaas — Sun, 06 Jun 2021 01:33:13 +0000

You can do something like:

   CREATE TABLE xx AS SELECT * FROM EXTERNAL_QUERY('postgres.db', 'SELECT * FROM my_table'));

New comment by mikeklaas in "Half a million lines of Go"

mikeklaas — Mon, 17 May 2021 05:39:36 +0000

You can catch and recover from panic()'s in go, too.

New comment by mikeklaas in "Asking rents in San Francisco continue to slip, but…"

mikeklaas — Mon, 26 Apr 2021 22:23:20 +0000

It's sensible in San Francisco because having an active renter makes a property worth significantly less.

Why? You basically cannot kick evict a renter or raise their rent.

New comment by mikeklaas in "School custodian refuses to download app that monitors location, got her fired"

mikeklaas — Tue, 13 Apr 2021 18:46:06 +0000

This is partially due to liability: if someone slips on a wet spill and hurts themselves, Whole Foods is liable if they haven't been taking reasonable measures to clean up such spills in a timely fashion (1/hour). Scanning is a way to later prove that such cleaning was happening.

New comment by mikeklaas in "Ask HN: Who is hiring? (February 2021)"

mikeklaas — Mon, 01 Feb 2021 20:04:41 +0000

Superhuman | iOS, Android, Fullstack engineer | REMOTE | Full-time

We build extremely fast, user-centric software. If that sounds different from the usual approach and appeals to you, get in touch.

San Francisco https://superhuman.com/jobs

New comment by mikeklaas in "Mealworms can compost styrofoam"

mikeklaas — Mon, 04 Jan 2021 06:09:42 +0000

Is it not the same thing as ubiquitous foam board insulation? https://www.homedepot.com/b/Building-Materials-Insulation-Fo...