pgtyped VS KeystoneJS

There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql

There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped

To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build

ORMs suck, but raw SQL embedded in your code sucks too.

This might be good time to plug my TypeScript non-ORM: https://jawj.github.io/zapatos/.

I should say I also like what I've seen of https://kysely.dev/ and https://pgtyped.dev/.

Thank you for suggestions they helped me finding what I was looking for. I will either pick kysely or https://pgtyped.dev/, but first I will do some tests. Thanks!

Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?

I would instead rely on code generation like https://github.com/adelsz/pgtyped, because the embedded type-safe SQL will never fully cover all the features of vanilla SQL, for example Common Table Expression (CTE), window functions etc.

There's pgtyped, which I believe does almost the same as sqlc

https://github.com/adelsz/pgtyped

For Postgres there is https://github.com/adelsz/pgtyped, sounds pretty much like what you describe?

Avoiding the cost of learning EDSL that many Haskell DB libraries provide, I found out that only postgresql-typed and postgresql-simple allow to write only raw SQL queries easily. As I extensively use pgtyped for production Node.js application, I am thinking about using postgresql-typed. While I could find many resources for postgresql-simple, the same cannot be said try for postgresql-typed.

I would highly recommend trying out pgTyped if you want typesafe queries with postgres. It's fantastic!

Keystone 6: The GraphQL Behemoth

Also, there are lots of exciting web frameworks that use Prisma as their default ORM layer (like RedwoodJS which is built by the founder of GitHub, Amplication which recently raised $6.6M in seed funding, Wasp (YC W21) or KeystoneJS) which should give you some more validation that Prisma is being used in a lot production applications :)

KeystoneJS https://keystonejs.com

https://keystonejs.com/ is a nice smaller alternative.

Keystone.js is a content management system and framework for creating server-side applications that interact with a database. It is based on the Express platform for Node.js and uses MongoDB for data storage. It is an alternative to CMS for web developers who want to create a data-driven website, but do not want to move to the PHP platform or too large systems such as WordPress.

I have a website I've built in nextjs frontend using keystonejs as a cms written in node.

I have a working graphql server written in Keystone CMS and hosted on Heroku.

Even you can use WordPress through their API, I would recommend you to try KeystoneJsKeystone Js CMS, as others suggested before, there are several headless CMSs but Keystone is totally free, open source and self hosted, you can even deploy on vercel. take a look

The most ok alternative would probably be something like Keystone.