A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Knex's TypeScript support is very weak. Type inference gets disabled in rather complex queries - even in simple joins. I want to have a strong type safety for response objects of my queries. My project size is "small-to-mid". Possible solutions in my mind:
A type-safe typescript SQL query builder
If you like knex checkout kysely. It's basically knex built on typescript https://github.com/koskimas/kysely
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
pgTyped - Typesafe SQL in TypeScript
If you would like to use raw SQL, pgtyped looks rather interesting although it only supports postgres. https://github.com/adelsz/pgtyped
Closest library/setup/configuration to JOOQ?
5 projects | reddit.com/r/node | 22 Apr 2022
Node.js Database migrations
2 projects | reddit.com/r/learnprogramming | 27 Mar 2022
I used Typeorm in one of our projects and I have nothing but regrets
4 projects | reddit.com/r/node | 2 Oct 2021
Slonik – TypeSafe PostgreSQL client for Node.js
2 projects | reddit.com/r/node | 14 Jun 2021
Contributing to the No Object Relational Mapping Project (NORM) for PostgreSQL
5 projects | reddit.com/r/PostgreSQL | 10 Mar 2021