PostgREST: Providing HTML Content Using Htmx

• plmustache

  2 25 6.8 PLpgSQL

  Logic-less templates for Postgres

  

This doc was meant to be a POC, just to show what's possible. We're working on migrating it to Mustache templates which do automatic escaping: https://github.com/PostgREST/plmustache?tab=readme-ov-file#e...

You're right though, we'll put a warning there. Thanks for the feedback.

• sqitch

  6 2,700 7.2 Perl

  Sensible database change management

  

I'm experimenting with it right now using Squitch [1] to make maintenance easier. It still feels like a hack and I also still have my doubts about the viability of this for real-world use. It's fun though and I'm learning about all kinds of advanced Postgres features.

[1] https://sqitch.org/

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

  

• couchapp

  1 829 10.0 Python

  Utilities to make standalone CouchDB application development simple

  

A really interesting (old) take on that type of stack I used was couchdb/couchapps (https://github.com/couchapp/couchapp)

• omnigres

  15 1,263 9.7 C

  Postgres as a Platform

  

If you think that's cool, you might also want to check out Omnigres:

https://github.com/omnigres/omnigres

• astro

  503 42,342 10.0 TypeScript

  The web framework for content-driven websites. ⭐️ Star to support our work!

  

• neurelo-go-htmx-example

  1 1 7.9 HTML

  A go project built using Neurelo and Htmx.

I love POSTGRES. I've been using it since last 6 years and I like how easy it is to get started and there is also ton of support and ecosystem available for PG.

Recently, I tried a new product called "Neurelo". It provides API for PostgreSql. And I love how easy it is to migrate my existing database on their platform, they have an option called introspection which helps to generate json schema which you can also modify in visual mode. On top I generated some SDKs for TS and it works so much better directly with any Js/Ts framework. You can download json spec from auto generated docs and run any generator of your choice if you want more from it. You can also write custom queries (AI assisted) which gives you custom endpoint to hit. They also provide a free data source if you want to check it out. Migrations included. Here is an example I built using HTMX and NEURELO: https://github.com/smitpatelx/neurelo-go-htmx-example

https://www.neurelo.com/

I was so impressed with their work, I recently joined the team Neurelo. If you have an existing solution you wanna migrate to cloud, have a look, you might get surprised how easy it is. Happy Coding

• saasufy-components

  4 4 9.5 JavaScript

  Components for Saasufy

  

I really like this general approach of using HTML as a declarative language.

I've been working on a similar concept as a serverless platform which updates all data in real time: https://saasufy.com/

Docs: https://github.com/saasufy/saasufy-components/#saasufy-compo...

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

  

• htmx

  565 32,656 9.6 JavaScript

  </> htmx - high power tools for HTML

  

yep, htmx will happily run that script. they even had this bug in their demos: https://github.com/bigskysoftware/htmx/pull/1995/files

• smoothdb

  2 16 9.0 Go

  SmoothDB provides an automatic RESTful API to PostgreSQL databases

For those who might be interested, I've recently published SmoothDB on GitHub [1], which, like PostgREST, provides a RESTful API to PostgreSQL databases.

It's a beta, aiming for compatibility with PostgREST, but it's not ready for production yet (so continue to use the very good PostgREST).

Written in Go, SmoothDB can be used both stand-alone and as a module for more complex server applications, which was my main motivation for writing this.

Your thoughts and contributions are greatly appreciated as they will help in the ongoing development and refinement of SmoothDB.

[1] https://github.com/sted/smoothdb

• SQLpage

  36 777 9.8 Rust

  SQL-only webapp builder, empowering data analysts to build websites and applications quickly

I feel obligated to add a shameless plug here. The idea is very close to a project I presented at pgconf.eu last week: SQLPage

https://sql.ophir.dev/

SQLPage has the same goal as postgrest+htmx, but is a little bit higher level. It let's you build your application using prepackaged components you can invoke directly from SQL, without having to write any HTML, CSS, or JS.

• postgrest

  100 22,282 9.7 Haskell

  REST API for any Postgres database

  

[2]: Also part of the PostgREST team and major contributor https://github.com/PostgREST/postgrest/graphs/contributors

Suggest a related project