Viewing profile — stephen

> tracking the table ... isn't reliable without [trigger] or [orm] We use sequences, which is neither of those, and has been very reliable for us. I included the disclaimer that yo…

I haven't had time to try it, but I thought running PG on a copy-on-write filesystem with a specific "clone template" incantation would get you instant clones? Probably doable in a…

We do similar, although lean into our strict "every table as a sequence" and "all FKs are deferred" conventions and only issue DELETEs for tables that actually were inserted by the…

I get why folks use tmux/herdr, but I already use i3wm/Hyprland for window/workspace management, and want to have "shared first class windows" instead of dual binds of "super-based…

Disclaimer I just edited this into my OP comment, but "generating boilerplate INSERTs" is not the main reason I use ORMs -- it's business rule enforcement. I.e. regardless of how e…

You're right, that has been another "pro ORM" pitch that has gone awry and, taken to the extreme, is wrong imo. My nuanced articulation is "you don't have to write the _boilerplate…

Fair point, both "pro ORM" and "anti ORM" camps are prone to extreme stances. I definitely don't agree with the "all queries must be executed through the ORM", and think that dogma…

I'm admittedly an ORM apologist [1], but a few of his points articulated as "deal breakers" aren't that bad imo: - "the pernicious use of foreign keys [...] links between classes a…

Right! That's why I think this is an exciting development. I assume everyone is downvoting me for "liking LLM slop", but really I just like the competition that "this is possible!"…

You're already using a new runtime with tsgo -- it's golang at build time -- but still running Node in prod, so the same could work here. :-) Agreed I would not want all Typescript…

Amazing. This is what the Typescript team should have done instead of rewriting to golang -- innovate the runtime.

"beyond a junior level" -- I doubt this will change your mind, but this post is from the author of Tachyons, a "pre-Tailwinds" competitor that didn't get the same traction: https:/…

Per "how to handle dynamic queries", it's admittedly pretty different b/c we're an ORM ( https://joist-orm.io/ ) that "fetches entities" instead of adhoc SQL queries, but our patte…

Hello! Yeah, I totally get Dagger is more "hey client please create a DAG via RPC calls", but just making something up in 30 seconds, like this is what I had in mind: https://gist.…

Right, my point is that this: https://docs.dagger.io/cookbook/services?sdk=typescript Still looks like "a circa-2000s Java builder API" and doesn't look like pleasant / declarative…

I thought Dagger had/has a lot of potential to be "AWS-CDK for CI pipelines". I.e. declaratively setup a web of CI / deployment tasks, based on docker, with a code-first DSL, inste…

Thanks for the reply! That all makes sense! As a potential user, I'd probably be thinking through things like: if I have a ~small-fleet of 10 ECS tasks serving my REST/API endpoint…

Can you description the deployment setup, somewhere in the docs/maybe with a diagram? I get this is a backend library, which is great, but like does it use postgres replication slo…

These two suggestions are fine, but I don't think they make fixtures really that much better--they're still a morass of technical debt & should be avoided at all costs. The article…

I still use my index finger; I've just gotten used to moving my hand ~slightly over from j to the nub. I would definitely prefer their trackpoint module be "flipped upside down" so…

The UHK80 has a trackpoint module that works great!

Everyone's definition of "production quality" is different :-), but Joist is a "mikro-ish" (more so ActiveRecord-ish) ORM that has a few killer features: https://joist-orm.io/ Alwa…

Great to hear you're using postgres.js in prod/large deployments! That sort of real-world-driven usage/improvements/roadmap imo leads to the best results for open source projects. …

Oh hello! Very happy to hear from you, and even happier to be wrong about your "AWOL-ness" (since I want to ship postgres.js to prod). :-) My assumption was just from, afaict, the …

I really want to use pipelining for our "em.flush" of sending all INSERTs & UPDATEs to the db as part of a transaction, b/c my initial prototyping showed a 3-6x increase: https://j…