sorted by: new top controversial old
TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen) in c/programming@programming.dev
[–] [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
  • context
    • TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen) in c/programming@programming.dev
    TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen) in c/programming@programming.dev
    [–] [S] -4 points 2 weeks ago (2 children)

    It passes full PostgreSQL test suite. I'm trying to put it on a solid foundation.

    To be honest, I didn't have much faith in vibe-coded projects either, but my belief has grown stronger as I've seen more potential projects.

    Also, don't assume I'm completely unfamiliar with the code. I've done the planning, chosen the project structure, and reviewed a significant portion (though perhaps superficially) of what I considered important.

  • permalink
  • fedilink
  • source
  • parent
  • context
    • 0
    TypeSQL: write plain SQL strings, get exact TypeScript types (no codegen) (lemmy.ml)
     

    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.