0
TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen) (lemmy.ml)
submitted 2 weeks ago by to c/programming@programming.dev
7 comments fedilink hide all child comments
 

I created this new library that parses Postgres SQL inside TypeScript’s type system. You write a SQL string and the compiler infers the row and parameter types. It needs no codegen and no database connection.

const q = sql(`SELECT u.id, u.email, p.title
               FROM users u LEFT JOIN posts p ON p.author_id = u.id
               WHERE u.id = ${sql.param(7)}`);
// { id: number; email: string; title: string | null }

sql("SELECT nme FROM users");
// error: column "nme" does not exist
  • Handles joins, CTEs, subqueries, window functions, INSERT/UPDATE/DELETE … RETURNING
  • Runs on pg or postgres.js, and can reuse your existing Kysely, Drizzle or Prisma schema
  • Requires TypeScript 7

https://github.com/ismailkarsli/typesql

Feedback welcome, especially queries that don’t type-check but should.

you are viewing a single comment's thread
view the rest of the comments
[–] 3 points 2 weeks ago (1 child)

See, this is the problem with vibe-coded projects and LLMs in general. They are fundamentally atomizing.

I can only speak for myself, though anecdotally I would guess this is not an uncommon position, when I say that this isn't fun. To build a community around a project you need people to be excited about the project and to be willing put free time into it because of that.

Vibecoding an app removes all the parts that made building a project fun and leaves behind only the shitty ones; the ones you specifically highlighted, the project management ones.

Maybe you got into software because you really love Agile and Gantt charts but, for a lot of people, the appeal was the craft. Open source was awesome because they can build things with like-minded people in a way that is tactile and interactive. Not unlike woodworking or metalworking hobbyists. LLMs take that part and light it on fire.

Sure, the bot can churn out fully functioning code for me. But I'm not excited about it, and I'm certainly not excited about someone else's.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] [S] 1 point 3 days ago

    So what you want me to do? I did not create AI. I’m doing software for 7 years now and I’m not happy where the sector is going too. But what I can do?

    I could not build this project in a week if there was no AI and likely wouldn’t even bother without it because it is pretty complicated.

    I’m still pretty enthusiastic about it. I do enjoy when I see the results. I’m trying to share something and make my life easier. So what? I should rewrite it by hand because that is more valuable?

    I really don’t know what you want me to do.

  • permalink
  • fedilink
  • source
  • parent