Querying SQL from React without a backend (bear with me here)

• postgrest

  100 22,103 9.7 Haskell

  REST API for any Postgres database

  

PostgREST is what you are looking for. If you don't want to set it up yourself, supabase is a basically a hosted version of PostgREST (and more, but the rest is likely irrelevant for you).

• thin-backend

  43 1,227 0.0 JavaScript

  🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps

  

Check out Thin Backend. It provides a simple way to query your Postgres Database with TypeScript and React Hooks. For displaying simple tables quickly, you might also like the CRUD table component :)

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

  

• supabase

  761 65,456 10.0 TypeScript

  The open source Firebase alternative.

  

PostgREST is what you are looking for. If you don't want to set it up yourself, supabase is a basically a hosted version of PostgREST (and more, but the rest is likely irrelevant for you).

• Prisma

  442 37,076 9.9 TypeScript

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

  

I am using Prisma https://www.prisma.io/ which works perfectly for my personal website.

Suggest a related project