I am using pgboss myself, very decent, very simple. Had some issues with graphile back in the days, cant remember what exaclty, it probably did already overcome whatever I was struggling with!

So we need to create tools with very high flexibility, not-so-fantastic onboarding that take a long time to setup and hard to get right - so that AI can fix them? I would rather use Linear (as per example).

And then once The Anyone gets few more years of experience they revert back to the bulky one.

Dunno, every queue in every major library/project I saw is implemented like this. This is quite readable if you're familiar with js promises.

Maybe we can at least fix the headline here, on hacker news

I am using both prisma and kysely in the same codebase with a great success. The db schema is driven by SQL, not prisma. It is then introspected by both kysely and prisma, prisma is used in 95% of the places while kysely is used whenever performance is critical or when prisma doesn't support the SQL features we need.

any underlying negative consequences on letting prisma schema handle the underlynig model/migrations

I found out about stackzen yesterday, really like the RBAC/ABAC backed up into the models/codegen stuff, been thinking about just using that for our custom logic and maybe add RLS pg a la supabase but also codegen from the same .zmodel from zenstack model that generates prisma models/migrations have it generate RLS sql migrations code

thoughts??

also maybe postgres views to handle field/attribute level security since rows is mostly about whole columns

main goal is to secure the data at all the levels of the stack from db to api to app so there's no footguns in the future where someone with a pg user or modifying our clients can see data they shouldn't etc

Prisma doesn't cover plenty of SQL features. custom types, more complex indexes (like where clause). It is also a VC backed biznes, need to be ready to drop it at almost any time, SQL/postgres on the other hand is here to stay.

RLS is hard to work with, hard to debug, hard to reason about, cumbersome. It is however powerful.

Right! for RLS i found out about atlasgo, which lets you do Schemas as Code including RLS stuff,

so my mind went to leverage the .zmodel to generate not only the prisma schemas through it and the client api codegen sdk, but also the RLS stuff either with plain sql migrations or a specific framework for rls.

all in all this is probably too much and as long as the app-api level is secure with zenstack and i dont use pg directly anywhere else it should be 'safe' i just wanted to harden all the stack speaking of sorts... idk

what is stackzen? I googled it and found nothing

It's most probably ZenStack given the description: https://zenstack.dev/

yes sorry, typo, i meant ZenStack!

is it this? https://github.com/stacksjs/stacks

Nope sorry it was zenstack https://zenstack.dev/

Love Webstorm, but I am having constant problems with type hints. Typescript with a solid setup that over time stopped working well.

Same, but vs code doesn’t help me half as much as intellisense.

I often open code written in vs code and immediately spot a bunch of bugs

"The obsessive need for AI developers (...)" - Of product product/business people trying to fit into the "AI era". Developers, if given a chance, wouldn't probably built this.

As someone interested in the gaming sector but with a web dev/full stack experience this seems like an amazing offer. It is however a shame you are not disclosing the salary range. I am not willing spend several hours on the interviweing process just to get to know what you are offering.

What's missing from https://kysely.dev/?

Looks pretty good, but APIs look more stringly typed and APIs don't look natural, I prefer using SQL expressions with typed references.

The query builder also looks coupled to execution, litdb query builders and aren't coupled to a driver implementation, i.e. they're just used to generate SQL with parameters that could then be executed with any driver.

From this year's Iq:

Botany: Jacob White and Felipe Yamashita, for finding that certain plants imitate the leaf shape of nearby plastic plants and concluding that "plant vision" is plausible.

This somehow doesn't fit the Iq award in my mind.

They 'need' to fill slots not that the IN awards have become an annual media event (presumably yielding some profit) so they've taken to mocking perfectly legitimate research as long as it is in some way scatalogical or counterintuitive. I lost interest in the Ig Nobel prize as a result; they've gone from an intermittent amusement to a celebration of ignorance.

Incidentally the plant mimicry thing seems to be a defense against herbivorous mammals. It was previously theorized that the shape information was transmitted by symbiotic bacteria; the ability to imitate fake plants is a genuinely perplexing result imo.

The Ig Nobel has always been for serious science that sounds silly. Their website begins with

>The Ig Nobel Prizes honor achievements so surprising that they make people LAUGH, then THINK. The prizes are intended to celebrate the unusual, honor the imaginative — and spur people’s interest in science, medicine, and technology.

There goal has never been to mock the award winners.