Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn?

• Prisma

  442 37,076 9.9 TypeScript

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

  

I work at Prisma and we've built a new kind of ORM for Node.js. Prisma works differently compared to most traditional ORMs since it uses its own schema language to define application models which look like this:

• redwood

  114 16,726 10.0 TypeScript

  The App Framework for Startups

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS and other dev tools like Amplication and WASP are using Prisma as their 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.

  

• KeystoneJS

  56 8,837 9.4 TypeScript

  The most powerful headless CMS for Node.js — built with GraphQL and React

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS and other dev tools like Amplication and WASP are using Prisma as their ORM.

• amplication

  148 13,308 10.0 TypeScript

  🔥🔥🔥 Open-source backend development platform. Build production-ready services without wasting time on repetitive coding.

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS and other dev tools like Amplication and WASP are using Prisma as their ORM.

• sequelize-auto

  2 2,858 1.5 TypeScript

  Automatically generate bare sequelize models from your database.

  

In addition, I'd recommend using Sequelize Auto:

• Knex

  95 18,720 8.1 JavaScript

  A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

  

Personally I've mostly used raw queries and Knex. ORMs are nice to start with but often they just don't perform well enough when the project gets more complex.

• slonik

  71 4,367 9.2 TypeScript

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

When I need CRUD-like interaction with application clients I use Graphile, which serves a GraphQL server based on your Postgres schema. My service layers more often use Slonik for highly customized queries and the elusive SQL syntax highlighting in Node/TypeScript.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• Bookshelf

  8 6,338 0.0 JavaScript

  A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

  

I made the transition from LAMP to Node-based stacks 6 or 7 years ago and started out using BookshelfJS. Node is a different world though, one that lends itself to distributed services and server-less infrastructure, and it's changed how I interact with DBs.

Suggest a related project