Cut Out the Middle Tier: Generating JSON Directly from Postgres

1. htmx

   1 633 43,034 9.7 JavaScript

   </> htmx - high power tools for HTML

   

   > Too often, web tiers are full of boilerplate that does nothing except convert a result set into JSON.

   Yeah. This is the problem: we've abandoned the hypermedia architecture of the web for a dumb-data, RPC model. I suppose if you are going to go that direction and things are simple enough, you can jam it in the DB and get smoking perf.

   But as things get more complicated, where does the business logic live? Maybe in the database as stored procedures? It's less crazy than it sounds.

   An alternative is to cut out the other middle man: JSON, ditch heavy front-end javascript and return HTML instead, going back to the hypermedia approach. The big problem with that is a step back in UX functionality, but there are tools[1][2][3] for addressing that.

   [1] - https://htmx.org (my library)

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. hotwire-rails

   2 98 960 3.2 Ruby

   Discontinued Use Hotwire in your Ruby on Rails app

   

4. fquery

   3 5 10 7.0 Python

   A graph query engine (by adsharma)

   

Suggest a related project