How you are dealing with sql in rescript?

[v_m_v]

Hi there. I’ve got a good opportunity to use rescript as a full-stack solution; the only missing thing is type-safe SQL or working ORM. There is no Prisma generator, so maybe some type-safe SQL solution? Any advice?

[zth]

Shameless self plug, but I’ve built pgtyped-rescript (a ReScript fork of pgtyped) which I use in a lot of projects: pgtyped-rescript/RESCRIPT.md at rescript · zth/pgtyped-rescript · GitHub

Let’s you write SQL code inline in a type safe way (types are generated from the SQL and your DB):

let query = %sql.one(`
  SELECT * FROM books WHERE id = :id!
`)

let res = await client->query({id: 1})

// Typed according to the SQL 1query
Console.log(res)

[fham]

There are some things:

[ANN] SQL query builder

Hey, I’m not a big fan of orms, but unfortunately I have to use it in so many projects. So I started to write some typesafe query builders in typescript for different databases a long time ago. Well, now I’m using rescript in many private projects but I was missing something like kysely or drizzle which I can use in rescript directly. So again… I started to work on my own library. I’ve tried several different approaches, and I’ve mentioned one or the other in a different context here in the…

[ANN] Type safe PostgreSQL in ReScript through pgtyped-rescript

Introducing pgtyped-rescript - type safe SQL in ReScript. I’ve recently spent some time porting pgtyped to emit ReScript instead of TypeScript. This means you can write (Posgres)SQL queries in SQL, and execute those queries with full type safety through ReScript. Here’s a readme that shows examples and how to get started. And here’s a quick example of how it looks: books.sql /* @name findBookById */ SELECT * FROM books WHERE id = :id!; pgtyped-rescript will generate a books__sql.res file f…

[ANN] rescript-edgedb - Use EdgeDB with full type safety in ReScript

Happy to announce rescript-edgedb - use EdgeDB in ReScript, with full type safety! This is what it looks like: [image] [image] Read more in the repository: GitHub - zth/rescript-edgedb: Use EdgeDB fully type safe in ReScript. Embed EdgeQL right in your ReScript source code. Preventing overfetching is built in The CLI for rescript-edgedb also ships with a command to detect unused selections in any of your EdgeQL queries in your app (powered by reanalyze by @cristianoc ). It essentially eli…

and I think @joshderochervlk had some prisma bindings?

[jderochervlk]

@fham

and I think @joshderochervlk had some prisma bindings?

No, I have some other library bindings I’ve worked on but nothing in this space. @zth is the expert for these

[sprkv5]

Because I needed to work with a range of databases and other folks in my team were sql devs, I used knex.js with custom bindings for an internal app. It let me use sql for querying and having ReScript helped with some runtime safety.

[v_m_v]

I’ve also thought about it. It looks like something easy to use and quite universal.