Using mysql2 package alongside Prisma for optimizing query performance with large tables

• safeql

  8 1,221 5.6 TypeScript

  Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

  

Anyways, an alternative if you're interested in using raw sql for max efficiency is an interesting project called SafeQLwhich treats inline queries as something to be linted. The only issue with that is if you develop on Windows, it doesn't work unless you're using WSL.

• drizzle-orm

  47 19,712 9.7 TypeScript

  Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  

I have started using drizzle orm lately, which is real close to raw SQL, fully typed, and those prepared statements are blazingly fast. Check it out at drizzle docs

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

  

Suggest a related project