Hacker News Reader

Seems like it generates TS types, but doesn’t help with data access? i.e. not trying to compete with tools that generate full data access layers, like Prisma https://www.prisma.io/ ?

If so, out of curiosity, what’s the use case for generating just the types? How are you actually getting data to/from the DB?

View on HN

I think the comment I made above in in regards to our db crud updates might help answer that!

But short answer is we just use node-postgres. If the get/update/delete/insert is a simple fields/table/where we use a helper function. If it's more complex we write custom SQL and use the following approach:

database.query<DB.User & DB.Pet>(` SELECT * FROM "pet" LEFT JOIN user on pet.owner = user.id `)

Ah cool, makes sense :)

Reply on news.ycombinator.com