Hacker News Reader

KwisaksHaderachon PlanetScale Insights: Advanced query monitoring

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.

KwisaksHaderachon LumoSQL

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

KwisaksHaderachon A project with a single 11,000-line code file

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

KwisaksHaderachon A project with a single 11,000-line code file

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

KwisaksHaderachon Vim Color Schemes

Does dark themes lets your focus more than light themes?

KwisaksHaderachon A database for 2022

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.

KwisaksHaderachon The shape of data

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.

KwisaksHaderachon Generics can make your Go code slower

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

KwisaksHaderachon GraphQL is now available on Supabase

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

KwisaksHaderachon Sorbet: Stripe's Type Checker for Ruby

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.

KwisaksHaderachon It’s fine, Rewind: Revert a migration without losing data

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

KwisaksHaderachon SPAs Were a Mistake

JS frameworks with a small footprint are suitable for this.

KwisaksHaderachon Russian Offensive Campaign Assessment, Feb 26, 2022

A billion dollar in weapons also helps.

KwisaksHaderachon Show HN: EdgeDB 1.0

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.

KwisaksHaderachon Back-end languages are coming to the front-end

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.

KwisaksHaderachon Back-end languages are coming to the front-end

You are looking for Golang ;)

KwisaksHaderachon Back-end languages are coming to the front-end

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.

KwisaksHaderachon Racket 8.4

https://shenlanguage.org has static typing.

KwisaksHaderachon Postgres constraints for newbies

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.

KwisaksHaderachon Netflix will falter

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

KwisaksHaderachon Single dependency stacks

What's the crunchy tool for this?

KwisaksHaderachon Single dependency stacks

Many can even get away with less: sqlite.

One less process to worry about.