Don’t we all just want to use SQL on the front end?

• supabase

  767 65,869 10.0 TypeScript

  The open source Firebase alternative.

  

This is such a useful abstraction.

I love working with PostGREST and have used it quite often for quick services (e.g. a vote button on a static site), internal tools (recently a covid checkin-screener), and for Proof of Concepts (postgres-powered full text search for address lookups in a webmap without using an external geocoder).

I personally have yet to use it for something with more than 200 users, but it sounds like others certainly have successfully. Supabase (https://supabase.io/) uses this for parts of their backend.

• pgress

  3 2 0.0 TypeScript

  Native PostgreSQL JavaScript client library for web browsers

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

  

• Meteor JS

  61 44,038 9.8 JavaScript

  Meteor, the JavaScript App Platform

  

> we should have an SQL database in the frontend

Although not SQL, this is essentially the approach Meteor takes where you have your same DB on the front and back end https://www.meteor.com/

• daita

  1 1 6.3 TypeScript

  typed sql made simple

],

Sadly documentation is quite poor for now, but you can check it out here https://github.com/no0dles/daita

• postgraphile-plugin-connection-filter

  6 279 0.0 TypeScript

  Filtering on PostGraphile connections

  

More examples here: https://github.com/graphile-contrib/postgraphile-plugin-conn...

(Personally, I think their docs are good at telling you how to use it but fairly bad at showing how great the tool is)

• postgraphile-plugin-conn

  2 - -

More examples here: https://github.com/graphile-contrib/postgraphile-plugin-conn...

(Personally, I think their docs are good at telling you how to use it but fairly bad at showing how great the tool is)

• HashQL-todos-sample

  1 13 0.0 JavaScript

With HashQL there actually was an experimental implementation of this idea

https://github.com/porsager/HashQL-todos-sample/blob/master/...

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• storage-foundation-api-explainer

  2 65 0.0

  Explainer showcasing a new web storage API, NativeIO

  

i think it's changed names (maybe) since i've last seen it? but here is the low level io spec:

https://github.com/WICG/storage-foundation-api-explainer

• postgrest

  100 22,282 9.7 Haskell

  REST API for any Postgres database

  

• mingo

  4 933 8.8 TypeScript

  MongoDB query language for in-memory objects

We are doing this under the covers in our app using https://github.com/kofrasa/mingo to let us write data queries on the SPA side.

It lets us build reports and other configurable data queries in a standard way for our case.

I can completely see how this makes sense using SQL although I think the complexity of the implementation might be a fair bit higher than mingo.

• mongo-parse

  1 40 0.0 JavaScript

  A parser for mongo db queries and projections.

I basically did this for tixit.me with mongo. I even wrote a module to parse mongo queries on the frontend so we could query our cache identically to our back end. https://github.com/fresheneesz/mongo-parse

It was a pretty big pain to write the middle ware necessary to make this happen. So I kind of agree.

• datsync

  2 323 1.8 Clojure

  Datomic <-> DataScript syncing/replication utilities

Suggest a related project