Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to?

This page summarizes the projects mentioned and recommended in the original post on /r/node

Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • kysely

    Discontinued A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)

  • I was historically a Knex and Objection.js user. I toyed around with Prisma for a while but share some of your concerns/annoyances. I've since moved to using Kysely (the author is the same guy who started Objection.js), and I've been having a great time with it.

  • kysely-codegen

    Generate Kysely type definitions from your database.

  • For what it's worth, I've been using kysely-codegen to generate the types based on the database schema and it's been working great for me.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo
  • ts-sql-query

    Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.

  • MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.

  • So I'm not going to count on people ever picking it up, just straight up. I mean like I look at things like this: https://github.com/mikro-orm/mikro-orm/blob/master/packages/core/src/unit-of-work/UnitOfWork.ts and I wonder how tf is anyone other than the original author going to be able to pick it up and understand what is going on in the codebase well enough to start maintaining it themselves.

  • postgres

    Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)

  • About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.

  • joist-orm

    a TypeScript ORM for Postgres

  • Ha, well, as you noted, I'm wary of even bothering to comment :-), but would be great if you checked out Joist: https://joist-orm.io/

  • Objection.js

    An SQL-friendly ORM for Node.js

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts