Hacker News: KwisaksHaderach

New comment by KwisaksHaderach in "PlanetScale Insights: Advanced query monitoring"

KwisaksHaderach — Thu, 26 May 2022 17:04:04 +0000

PiTR is like the primary reason for us using a managed DB, it's indeed a weird and fatal omission from a managed DB offering.

New comment by KwisaksHaderach in "LumoSQL"

KwisaksHaderach — Tue, 05 Apr 2022 15:23:18 +0000

Aside, anyone used the java sqlite driver https://github.com/xerial/sqlite-jdbc in production (webapp with multiple users)? Has the driver been reliable?

New comment by KwisaksHaderach in "A project with a single 11,000-line code file"

KwisaksHaderach — Mon, 04 Apr 2022 05:39:27 +0000

See also Bellard's QuickJS (54k lines) https://raw.githubusercontent.com/bellard/quickjs/master/qui...

New comment by KwisaksHaderach in "A project with a single 11,000-line code file"

KwisaksHaderach — Mon, 04 Apr 2022 05:35:02 +0000

This application must be really really simple ;), so no database?

New comment by KwisaksHaderach in "Vim Color Schemes"

KwisaksHaderach — Sat, 02 Apr 2022 05:42:48 +0000

Does dark themes lets your focus more than light themes?

New comment by KwisaksHaderach in "A database for 2022"

KwisaksHaderach — Fri, 01 Apr 2022 22:41:22 +0000

The obvious candidates were MySQL (or one of its renamed variants given who bought it) or PostgreSQL, but several of us on the team have operational experience running these databases and didn’t enjoy the prospect of wrestling with the ops overhead of making live replication work and behave well. Other databases like CockroachDB looked very tempting, but we had zero experience with it. And we didn’t want to lock ourselves into a cloud provider with a managed product like Spanner.

What about managed mysql/posgresql? no lock-in and installing them locally is trivial.

New comment by KwisaksHaderach in "The shape of data"

KwisaksHaderach — Thu, 31 Mar 2022 01:20:00 +0000

Clojure really is probably one of the best languages for application programming out there, and pairs beautifully with Java when you need to go some levels lower.

New comment by KwisaksHaderach in "Generics can make your Go code slower"

KwisaksHaderach — Wed, 30 Mar 2022 21:50:03 +0000

Doesn't sound unrealistic if you have a mix load of IO and raw processing.

New comment by KwisaksHaderach in "GraphQL is now available on Supabase"

KwisaksHaderach — Wed, 30 Mar 2022 05:09:36 +0000

Are there any plans to provide a Java client for EdgeDB?

New comment by KwisaksHaderach in "Sorbet: Stripe's Type Checker for Ruby"

KwisaksHaderach — Wed, 30 Mar 2022 04:35:19 +0000

Remember, this are devs that worked on codebases that have millions lines of Ruby code (Stripe) and most probably have to handle loads of state in the application layer, so their context/anecdata might be different for your friends. I prefer dynamically typed languages for most stuff but at the scale of Stripe I would also like to have a type checker.

New comment by KwisaksHaderach in "It’s fine, Rewind: Revert a migration without losing data"

KwisaksHaderach — Thu, 24 Mar 2022 16:32:15 +0000

Does planetscale doesn't have PITR? couldn't find anything in the docs.

New comment by KwisaksHaderach in "SPAs Were a Mistake"

KwisaksHaderach — Thu, 03 Mar 2022 00:21:23 +0000

JS frameworks with a small footprint are suitable for this.

New comment by KwisaksHaderach in "Russian Offensive Campaign Assessment, Feb 26, 2022"

KwisaksHaderach — Sun, 27 Feb 2022 02:20:26 +0000

A billion dollar in weapons also helps.

New comment by KwisaksHaderach in "Show HN: EdgeDB 1.0"

KwisaksHaderach — Thu, 10 Feb 2022 19:46:08 +0000

EdgeDB is built on an extension of the relational data model that we call the graph-relational model. This model completely eliminates the object-relational impedance mismatch while retaining the solid basis of and performance of the classic relational model.

I don't see how can they retain the performance of the relational model when using graphs on top of PG unless they are using PG as storage k/v layer only.

New comment by KwisaksHaderach in "Back-end languages are coming to the front-end"

KwisaksHaderach — Thu, 10 Feb 2022 17:35:34 +0000

Workers threads spawn a new JS VM( which implies a new GC) for each worker! We tried it and the gains from parallelism stopped when there were half as many workers as CPUs.

New comment by KwisaksHaderach in "Back-end languages are coming to the front-end"

KwisaksHaderach — Thu, 10 Feb 2022 17:09:54 +0000

You are looking for Golang ;)

New comment by KwisaksHaderach in "Back-end languages are coming to the front-end"

KwisaksHaderach — Thu, 10 Feb 2022 17:00:17 +0000

It's fantastic for I/O-heavy 'server'-type code

I have found nodejs frustrating for CRUD APIs, the is 'fantastic for heavy I/O' while true ends up guiding you to complex microservices(or trying to use a external services for everything) because you don't want to slow down the event loop as you add more and more cpu processing to your app.

New comment by KwisaksHaderach in "Racket 8.4"

KwisaksHaderach — Thu, 10 Feb 2022 01:05:21 +0000

https://shenlanguage.org has static typing.

New comment by KwisaksHaderach in "Postgres constraints for newbies"

KwisaksHaderach — Thu, 10 Feb 2022 00:25:58 +0000

The article is about the basic constraints you mentioned, FKs, PK/unique, check constraints. I agree with keeping the database as dumb as possible with only those, heck even dropping those (except for PKs) at the beginning gives you more agility.

New comment by KwisaksHaderach in "Netflix will falter"

KwisaksHaderach — Wed, 09 Feb 2022 22:15:06 +0000

Netflix is the instagram of the tv streaming services, 95% of the content is crap and they are creating lots of it.