News for hackers. Stuff that matters.

A comment on Parrot – type-safe SQL in Gleam, supports SQlite, PostgreSQL and MySQL.

Re:Parrot – type-safe SQL in Gleam, supports SQlite, Postgre... by johtso on Sunday October 05, 2025 @06:40AM (#45480511)
sqlc always seemed like a really neat concept to me. I love the idea of being able to write my queries as raw SQL in separate files, would make everything so much more interoperable with other tools. Having your queries defined as strings inside some other programming language always struck me as not so awesome.

I'd love to see something like this for Typescript and Effect's SQL integration with schemas.

[ Parent | on HN ]
Re:Parrot – type-safe SQL in Gleam, supports SQlite, Postgre... by denysonique on Sunday October 05, 2025 @07:17AM (#45480648)
https://github.com/adelsz/pgtyped
[ Parent | on HN ]
Re:Parrot – type-safe SQL in Gleam, supports SQlite, Postgre... by LudwigNagasena on Sunday October 05, 2025 @08:33AM (#45481038)
SQL is barely parametrizable, so, in my opinion, the DX is much worse than using a query builder and not much better than simply using strings.
[ Parent | on HN ]
Re:Parrot – type-safe SQL in Gleam, supports SQlite, Postgre... by danieldisu on Sunday October 05, 2025 @03:42PM (#45484557)
You just have to duplicate things a bit more, but with the help of LLMs building the queries is very simple and extending them even easier
[ Parent | on HN ]