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

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/node
#Postgresql #Database #MySQL #ORM #TypeScript

Our great sponsors
  • Appwrite - The Open Source Firebase alternative introduces iOS support
  • ONLYOFFICE ONLYOFFICE Docs — document collaboration in your environment
  • CodiumAI - TestGPT | Generating meaningful tests for busy devs
  • Sonar - Write Clean JavaScript Code. Always.
  • InfluxDB - Access the most powerful time series database as a service
Our great sponsors

  • TypeORM

    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

    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.

  • Appwrite

    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!

  • lucid

    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

    Generates models for TypeORM from existing database.

  • slonik

    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

    Lightweight SQL query builder

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

  • JDBI

    jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integration

    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.

  • ONLYOFFICE

    ONLYOFFICE Docs — document collaboration in your environment. Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises

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