Question: what would make you less nervous putting validation and consistency logic back into the DB layer?

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

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
  • Prisma

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

  • CONS * Kindergarten level SQL options: anything a tiny bit complicated is most likely not implemented or... * In a lot of cases encourages you to write code that is ineffective and/or dangerous compared to what any mid-level database folk would write, essentially you write logic/structure to play nice with the ORM in contrast to writing code for satisfying product, safety or efficiency principles.

  • slonik

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

  • I did stumble upon Slonik which was enlightening: you can write proper SQL queries inside javascript with the magic Tagged template literals.

  • 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
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