ESQLate

Dev tools

admin panel generator

SHOW HN2020

Legend

ESQLate

Build minimum viable admin panels with just SQL

github.com

#admin panel#sql#back office#postgresql#crud

505points
79comments
#50of 3,028 in 2020
Top 2%of 2020 by points

How HN took it

CuriousMostly questions and neutral comments

12 positive, 17 neutral or asking, 0 mixed, 5 critical, out of 34 comments about the project. Thread score +0.20.

Idea: 11 for, 2 againstDesign: 1 for, 2 againstExecution: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful idea that reduces admin panel work

    From 3 comments
    • This is awesome! Saves so much work on building simple admin panels. I have experience in custom software development, and that's such a huge pile of work for developers it's…
      saviorand on HN
    • Thank you so much I've wanted something like this for years but never invested the time into finding or building it.
      xupybd on HN
    • That looks quite useful. The name's pretty clever, too. Tools like these are a viable, low-code (to use a hyped-up term) alternative to creating full-blown back-ends with all the…
      BjoernKW on HN
  • Name and approach praised

    From 2 comments
    • That looks quite useful. The name's pretty clever, too. Tools like these are a viable, low-code (to use a hyped-up term) alternative to creating full-blown back-ends with all the…
      BjoernKW on HN
    • Great work! I once was a fan of custom well tailored DSL's for each tool. However, nowadays I really like the current direction of providing a lot of tooling with only SQL…
      cube2222 on HN

Objections

  • Authentication not handled by the tool

    From 1 comment
    • Authentication is not handled at all. Given it is a project with a front and back end (using a REST interface between) I think the correct approach is to do authentication on a…
      mattatkeyboard on HN
  • Setup instructions did not work for one commenter

    From 2 comments
    • Super neat idea and tool! I tried to clone it and run it locally, but it doesn't run. Tried with both yarn and npm. ``` > node-sass src/index.scss > public/index.css sh: 1:…
      gavinray on HN
    • could you check the code ? i think esqlate-server is .gitignored
      sandGorgon on HN
  • UI config in JSON is unappealing

    From 1 comment
    • Good, but, I don't want to write UI configs in JSON. Making the UI should be as minimally difficult as the rest of the app makes tasks.
      howmayiannoyyou on HN

Requests

  • Support for one-to-many and many-to-many relationships

    From 1 comment
    • Interesting. How would you make this to support one-to-many/many-to-many relationships?
      trungdq88 on HN
  • Authentication via OpenID

    From 1 comment
    • This looks really useful. How is authentication and authorization handled? Can I connect it to my Openid provider?
      _frkl on HN
  • Store admin panel configuration in a database

    From 1 comment
    • Why not have the admin panels configuration stored in a database itself instead of json? And use the admin panels to add more admin panels...
      janci on HN

Questions

  • How does it prevent SQL injection

    From 1 comment
    • Interesting idea. Are you doing anything to protect against sql injection attacks?
      jimmar on HN
  • How it differs from Redash

    From 1 comment
    • It looks excellent! But I know https://redash.io already and used it in my last business - does this do something different? I'm always hungry for better SQL business admin tools…
      mattbee on HN

Alternatives named

  • react-admin

    From 1 comment
    • This looks pretty interesting! If anyone is looking for a tool to build a full fledge Back Office I warmly recommend react-admin (https://github.com/marmelab/react-admin/). Been…
      Rowern on HN
  • PostgREST

    From 1 comment
    • Another worthy mention (not FE, but also exploiting power of sql): https://github.com/PostgREST/postgrest "PostgREST serves a fully RESTful API from any existing PostgreSQL…
      xwowsersx on HN
  • Hasura

    From 1 comment
    • You might also find Hasura interesting for instant GraphQL with Postgres: https://hasura.io/
      hadem on HN
  • Metabase

    From 1 comment
  • Adminer

    From 1 comment
    • I use adminer for this. https://www.adminer.org/ It's a single PHP file, and does everything I need.
      milankragujevic on HN
  • Django Admin

    From 1 comment
    • I think forestadmin.com / jetadmin.io are the SQL introspection equivalent of the Django Admin. Both are commercial products though.
      cdrx on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/22073037)