Show HN: ESQLate – Build minimum viable admin panels with just SQL (github.com)

Article summary

The article introduces ESQLate, a tool that allows users to build minimum viable admin panels quickly with just SQL. ESQLate interprets a simple JSON file to produce a web interface, allowing users to execute SQL queries with their own parameters. The tool aims to provide a quick and easy form of administration panel for small teams, solving the problem of investing time into creating admin panels that only internal employees will use. ESQLate also supports linking between reports and forms, and allows users to download result sets as CSV files.

Main themes

• SQL-based admin panels
• Low-code development
• Database administration
• Admin interface generation
• SQL injection protection

What commenters say

• Using SQL to generate admin panels can be a viable alternative to creating full-blown back-ends with boilerplate code.
• Some commenters suggest that database administration tools already exist, but may lack user-friendly interfaces.
• Others argue that using database procedures could be a simpler approach, but may not be suitable for all use cases.
• There are differing opinions on the best approach to generating admin interfaces, with some preferring low-code solutions and others advocating for more traditional development methods.
• Some commenters appreciate the potential time-saving benefits of using tools like ESQLate for building simple admin panels.
• The use of SQL to generate admin panels raises concerns about SQL injection attacks, but some argue that parameterized queries can mitigate this risk.
• The discussion touches on the idea that many projects could be automatically generated based on API and model specifications, reducing the need for manual development.