Stuck On Node database management. Should I use a different ORM? Should I use raw SQL?

• TypeORM

  156 33,287 9.0 TypeScript

  ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

  

I wonder why you think TypeORM is not on active development. There is it's github page: https://github.com/typeorm/typeorm/graphs/contributors In moment when I write the message there was 17 pull requests merged only in last 7 days. It has best typings support in my experience (as it was designed for it from the beginning) and build-in query builder (sequelize lacks both). It's not ideal, but it's abstraction over something. Like every abstraction, it's tradeoff, you got something, you lost something.

• Prisma

  442 37,151 9.9 TypeScript

  Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

  

Hey, Mahmoud from Prisma here 👋🏼Super sorry to hear that you've been running into issues :/The best place to ask questions is in our [Slack community](https://slack.prisma.io) and [GitHub discussions](https://github.com/prisma/prisma/discussions). We'd love to know more about your use case and help in any way we can.Prisma definitely has all the traits you're looking for in an ORM.

• SurveyJS

  surveyjs.io sponsored

  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.

  

• lucid

  8 980 9.0 TypeScript

  AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)

  

Adonisjs Lucid is pretty solid in all regards. https://docs.adonisjs.com/guides/database/introduction

• typeorm-model-generator

  1 1,408 0.0 TypeScript

  Discontinued Generates models for TypeORM from existing database.

• slonik

  71 4,381 9.2 TypeScript

  A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

I like postgraphile for clients and slonik for services.

• sqliterally

  1 260 0.0 JavaScript

  Lightweight SQL query builder

You can use something like sqliterally to compose your SQL, and maybe make it a bit cleaner.

• JDBI

  27 1,901 9.4 Java

  The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.

  

Ideally I'd like to use something like https://jdbi.org/ - ORM which only does conversion from rows to objects, no other magic. But I don't think it exists for node.

• InfluxDB

  www.influxdata.com sponsored

  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.

  

Suggest a related project